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 c.idparent='1' and a.date_publicationHaziallat.hu | Kutya

Kutya - 105. oldal