Koelkasten met inoxlook

select distinct a.id from categories c right join ez_artikels_cat ac on ac.scat_id=c.ID left join ez_artikels a on a.id=ac.artikel_id where c.active_cz=1 and a.type in (1) and a.active=1 and a.datum_online<=curdate() and a.hcatid=2 and a.id not in (6533)

select distinct a.id, a.title, a.title_fr, a.hcatid, a.content, a.content_fr, a.content_short, a.content_short_fr, a.fotonaam, year(a.created)-2000 jaarcode, a.type, a.datum_online, a.main_image from categories c right join ez_artikels_cat ac on ac.scat_id=c.ID left join ez_artikels a on a.id=ac.artikel_id where c.active_cz=1 and a.type in (1) and a.active=1 and a.datum_online<=curdate() and a.hcatid=2 and a.id not in (6533) order by a.datum_online desc, a.created desc

© 2017 cuizine.be - All rights reserved!