select a.articles_id,a.articles_img, ad.articles_name,ad.articles_description,date_format(a.articles_date_added,'%m-%d-%Y') date 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 = 2 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.articles_date_added desc limit 4
English
簡體中文
