---

SELECT COUNT(*) AS rows FROM tuxm_posts A FORCE INDEX (idx_rss_user_feed) WHERE A.USERID=1095498 AND A.type = 1 AND A.UID = 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 (SELECT A.ID FROM tuxm_posts A FORCE INDEX (idx_rss_user_feed) WHERE A.USERID=1095498 AND A.type = 1 AND A.UID = 0 ORDER BY A.ID DESC LIMIT 0, 5) X INNER JOIN tuxm_posts A ON A.ID=X.ID INNER JOIN tuxm_members B ON B.USERID=A.USERID AND B.status=1 LEFT JOIN tuxm_posts_stats S ON S.idpost=A.ID LEFT JOIN tuxm_posts_infos I ON I.idpost=A.ID LEFT JOIN tuxm_shorturl SHORT ON SHORT.identry=A.ID ORDER BY A.ID DESC