EXPLAIN SELECT COUNT(*) as cnt
FROM tuxm_members B
INNER JOIN tuxm_posts A ON B.USERID = A.USERID
LEFT JOIN tuxm_posts_stats S ON A.ID = S.idpost
LEFT JOIN tuxm_posts_infos I ON I.idpost = A.ID
LEFT JOIN tuxm_shorturl SHORT ON A.ID = SHORT.identry
WHERE B.status = 1
AND A.USERID = 1100862
AND A.UID = 0 AND I.costperview >0 SELECT A.ID, A.type, A.edited, A.USERID, A.PID, A.UID, A.UIDO, A.msg,
A.time_added, S.views, S.repost, S.liked, A.origineid, A.origineuser, A.typepost, S.com,
A.linkpost, COALESCE(SHORT.url, A.linkpost) as linkpost2, A.realtime, COALESCE(I.costperview, 0) AS costperview, A.button, B.username,
B.lastname, B.firstname, B.verified, B.public, B.adult, B.utype ,
SHORT.id as shorturl_id, SHORT.user as shorturl_user
FROM tuxm_members B
INNER JOIN tuxm_posts A ON B.USERID = A.USERID
LEFT JOIN tuxm_posts_stats S ON A.ID = S.idpost
LEFT JOIN tuxm_posts_infos I ON A.ID = I.idpost
LEFT JOIN tuxm_shorturl SHORT ON A.ID = SHORT.identry
WHERE B.status = 1
AND A.USERID = 1100862
AND A.UID = 0 AND I.costperview >0 ORDER BY A.ID DESC
LIMIT 0, 5