Search Results
SELECT SQL_CALC_FOUND_ROWS DISTINCT(v.ID), v.SOURCE_ID, v.TITLE, IF(ISNULL(v.ai_summary),v.SUMMARY,v.ai_summary) AS SUMMARY, v.STATICPREVIEW, v.MEDIA_DURATION, v.MEDIA_TYPE, v.DATE, v.TranslatedURL, v.Source, v.CHANNEL, v.ALTIMAGE, MATCH(IF(ISNULL(v.ai_summary),v.SUMMARY,v.ai_summary), v.Title) AGAINST ('HENRY+TAYLOR') AS relevance FROM Websites AS c, videos AS v WHERE (MATCH(IF(ISNULL(v.ai_summary),v.SUMMARY,v.ai_summary), v.Title) AGAINST ('HENRY+TAYLOR') OR (v.id=46394 OR v.id=20651 OR v.id=20651 OR v.id=22280 OR v.id=25785 OR v.id=9 OR v.id=12982 OR v.id=26007 OR v.id=143164 OR v.id=25201 OR v.id=24774 OR v.id=24665 OR v.id=22268 OR v.id=22267 OR v.id=18775 OR v.id=18503 OR v.id=1548 OR v.id=144971)) AND c.ID=v.CHANNEL AND c.Status=1 AND v.Status=1 AND (v.FreshnessDate>=NOW() OR v.FreshnessDate='0000-00-00 00:00:00') ORDER BY relevance, v.Date DESC LIMIT 0, 10