SELECT A.articleID, `movieID`, `articleTitle`, `seoUri`, `articleImg`, `detailImg`, `imageCaption`, `imgTagName`, `isVideo`, `embedCode`, `synopsys`, `articleDesc`, `authorID`, `categoryID`, `articleStatus`, `comment`, `movieRating`, `isFeatured`, `datePublish` FROM `fx_article` AS A JOIN `fx_articletag` AS AT ON A.articleID = AT.articleID WHERE A.status= '1' AND A.articleStatus=1 AND (AT.tagName LIKE '%celebrity%' OR A.articleTitle LIKE '%celebrity%') AND DATE_FORMAT(datePublish, '%Y-%m-%d %H:%i')<='2018-04-23 09:41' GROUP BY A.articleID ORDER BY A.datePublish DESC LIMIT 100-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Loading
