|
SELECT t1.idnews, t1.idimage, t1.title, t1.content, t1.utime, t2.src, t3.pageval FROM news AS t1, image AS t2, subpages AS t3 WHERE t1.language='hu' AND t1.valability_date>=CURDATE() AND t1.active='1' AND t1.idimage=t2.idimage AND t1.idsubpages=t3.idsubpages ORDER BY t1.utime DESC LIMIT 30,1 SELECT t1.idnews, t1.idimage, t1.title, t1.content, t1.utime, t2.src, t3.pageval FROM news AS t1, image AS t2, subpages AS t3 WHERE t1.language='hu' AND t1.valability_date>=CURDATE() AND t1.active='1' AND t1.idimage=t2.idimage AND t1.idsubpages=t3.idsubpages ORDER BY t1.utime DESC LIMIT 31,1 SELECT t1.idnews, t1.idimage, t1.title, t1.content, t1.utime, t2.src, t3.pageval FROM news AS t1, image AS t2, subpages AS t3 WHERE t1.language='hu' AND t1.valability_date>=CURDATE() AND t1.active='1' AND t1.idimage=t2.idimage AND t1.idsubpages=t3.idsubpages ORDER BY t1.utime DESC LIMIT 32,1 SELECT t1.idnews, t1.idimage, t1.title, t1.content, t1.utime, t2.src, t3.pageval FROM news AS t1, image AS t2, subpages AS t3 WHERE t1.language='hu' AND t1.valability_date>=CURDATE() AND t1.active='1' AND t1.idimage=t2.idimage AND t1.idsubpages=t3.idsubpages ORDER BY t1.utime DESC LIMIT 33,1 SELECT t1.idnews, t1.idimage, t1.title, t1.content, t1.utime, t2.src, t3.pageval FROM news AS t1, image AS t2, subpages AS t3 WHERE t1.language='hu' AND t1.valability_date>=CURDATE() AND t1.active='1' AND t1.idimage=t2.idimage AND t1.idsubpages=t3.idsubpages ORDER BY t1.utime DESC LIMIT 34,1 |