Home
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 ('lauren+schrero') AS relevance FROM Websites AS c, videos AS v WHERE (MATCH(IF(ISNULL(v.ai_summary),v.SUMMARY,v.ai_summary), v.Title) AGAINST ('lauren+schrero') OR v.id=79215) 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