SELECT a.articles_id,td.topics_name,a.news_images, ad.articles_name,ad.articles_description from articles a, articles_to_topics a2t, topics t, topics_description td, articles_description ad where a2t.topics_id = td.topics_id and t.topics_id = td.topics_id and t.topics_type = 4 and t.topics_id=119 and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1' order by a.sort_order asc
