| |
|
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 10,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 11,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 12,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 13,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 14,1 |
|
|
