SELECT sid, s.catid, s.aid, s.title, s.time, s.hometext, s.bodytext, s.comments, s.counter, s.topic, s.acomm, s.score, s.ratings, c.title, t.topicid, t.topicname, t.topicimage, t.topictext, z.id, z.kwords, z.sslka, z.mname FROM prefix_table1 AS s LEFT JOIN prefix_table2  AS c on (s.catid=c.catid) LEFT JOIN prefix_table3 AS z on (sid=z.nid) LEFT JOIN prefix_table4 AS t on (s.topic=t.topicid) WHERE ihome='0' AND s.time <= NOW() AND status='1' AND (alanguage='russian' OR alanguage='') ORDER BY s.time DESC LIMIT 0, 10