
269
HOL TUDOM MEGVENNI?
SELECT news.title, news.image, news.mini_description, fomenu.image_folder, concat( '/', fomenu.link_name, '/', almenu.link_name, '/', news.news_link, '/' ) AS url FROM news LEFT JOIN menus AS almenu ON news.menu_id = almenu.id LEFT JOIN menus AS fomenu ON almenu.menu_id = fomenu.id WHERE news.public_from <= now() AND ( news.public_until >= now() OR news.public_until = '0000-00-00 00:00:00' ) AND news.active = 'yes' AND fomenu.id not in (166, 167) ORDER BY news.date DESC, news.id DESC LIMIT 0,8