Nieuws - TABLE

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.active=1 and a.datum_online<=curdate() and a.hcatid=1061

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.active=1 and a.datum_online<=curdate() and a.hcatid=1061 order by a.datum_online desc, a.created desc

cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws
cuizine.be
nieuws

laatste nieuws in table

meer nieuws in table