SELECT a.* FROM advtext as a INNER JOIN advtext_publish ap ON a.id = ap.id_adv WHERE ap.startdate <= '2013-06-20' AND ap.enddate >= '2013-06-20' AND a.foralbum = 0 AND a.tinhtrangnoibo = 1 AND ap.activate = 1 AND khachhang = 0 AND ap.id_category = 70 LIMIT 1
| X | ||||||
| CN | T2 | T3 | T4 | T5 | T6 | T7 |