sql search query still not producing expected results

[586elsa247thistlethwait244]

I need a count and search query to work properly. The count query appears to be working properly, however the search query is not.Count query:\[code\]SELECT COUNT(DISTINCT tg_id) FROM tg_keywords WHERE tg_keyword LIKE 'keyword_1' OR tg_keyword LIKE 'keyword_2' ORDER BY tg_keyword LIKE 'keyword_1' AND tg_keyword LIKE 'keyword_2 DESCReturns 1 count as expected.\[/code\]Search query:\[code\]SELECT DISTINCT tg_keywords.tg_id FROM tg_keywords LEFT JOIN tg_info.tg_id=tg_keywords.tg_id WHERE tg_keyword LIKE 'keyword_1' OR tg_keyword LIKE 'keyword_2' ORDER BY tg_keyword LIKE 'keyword_1' AND tg_keyword LIKE 'keyword_2' DESC, tg_info.date_added LIMIT 16 OFFSET 1Returns 0 results (1 is expected)\[/code\]Any advice would be greatly appreciatedThanks in advance,Archie