|
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 0,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 1,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 2,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 3,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 4,1 |