BAJAJ test News & Top Stories

SELECT pageUrl, title, thumbnailUrl, thumbnailAltText, shortDescription,fullContent, publishDateandTime from tblcontents a LEFT JOIN tbltagging b ON a.id = b.contentId WHERE contentType = 2 AND publishDateandTime <= NOW() AND contentPublishType IN (1,2) AND contentPublishStatus = 2 and mbId = 1052 and type = 1 and tagContentType = 0 ORDER BY publishDateandTime desc LIMIT 15