SELECT
a.idarticle as a_id,
a.title as a_title,
a.seo_url as a_url,
a.short_lead as a_short_lead,
a.date_publication as a_date_publication,
a.flag_has_video as a_has_video,
ac.idcategory as idcat,
c.name AS c_name,
c.url as c_url,
c.idcategory as category_id
FROM article a
LEFT JOIN article_category ac ON a.idarticle=ac.idarticle
LEFT JOIN category c ON ac.idcategory=c.idcategory
WHERE a.idarticle<0 and ( a.category_id='1' or a.category_id='2' or a.category_id='3' or a.category_id='4' or a.category_id='5' or a.category_id='6' or a.category_id='7' or a.category_id='8' or a.category_id='9' or a.category_id='10' or a.category_id='11' or a.category_id='12' or a.category_id='79' or a.category_id='80' or a.category_id='81' or a.category_id='82' or a.category_id='83' or a.category_id='84' or a.category_id='85' or a.category_id='86' or a.category_id='87' or a.category_id='89' or a.category_id='90' or a.category_id='91' or a.category_id='92' or a.category_id='93' or a.category_id='94' or a.category_id='95' or a.category_id='96' or a.category_id='97' or a.category_id='98' or a.category_id='104' or a.category_id='105' or a.category_id='106' or a.category_id='107' or a.category_id='108' or a.category_id='109' or a.category_id='110' or a.category_id='111' or a.category_id='112' or a.category_id='113' or a.category_id='114' or a.category_id='115' or a.category_id='116' or a.category_id='117' or a.category_id='118' or a.category_id='119' or a.category_id='120' or a.category_id='121' ) and a.date_publicationHaziallat.hu |
