SELECT SQL_CALC_FOUND_ROWS AS id, video.title AS title, video.webUrl AS webUrl, video.views AS views, DATE_FORMAT(video.addedDate,'%b %D, %Y') AS addedDate, video.videoType AS videoType, video.duration, video.image AS videoImage, ctgryVideo.ctgry AS videoCtgries FROM videos_videos AS video INNER JOIN videos_ctgryVideo AS ctgryVideo ON = INNER JOIN videos_providers AS provider ON = video.provider WHERE ctgryVideo.ctgry IN (52,84,336,368,321,175,51,311,83,85,91,101,343,146,329,298,344) AND video.status = 1 AND ctgryVideo.status = 1 AND provider.status = 1 AND seoTags like ? ORDER BY video.addedDate DESC LIMIT ? , ?