DEBUG MODE - FILM TITLES SEARCH
Search query: 'the war to end all wars and its american veterans'
Database connected: YES
SQL:
SELECT id, title, original_title, year, poster_url,
CASE
WHEN title LIKE '%the war to end all wars and its american veterans%' THEN 1
WHEN original_title LIKE '%the war to end all wars and its american veterans%' THEN 2
ELSE 3
END as relevance
FROM films
WHERE title LIKE '%the war to end all wars and its american veterans%' OR original_title LIKE '%the war to end all wars and its american veterans%'
ORDER BY relevance ASC, year DESC
LIMIT 20
Search term: %the war to end all wars and its american veterans%
Results found: 0
Search Titles: the war to end all wars and its american veterans - Short Movie Database
No films found matching "the war to end all wars and its american veterans"
Try checking your spelling or using different keywords.