your query:
SELECT * FROM pages
INNER JOIN productsubcategory ON productsubcategory.url = pages.Pageurl
WHERE Category LIKE '%Adhesion%' AND SubCategory LIKE '%Pull Off Adhesion Tester%'
ORDER BY productsubcategory.myorder ASC"
shouldnt have the quotes at the end.
the error:
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
is saying that the collation for the productsubcategory.url column and the pages.Pageurl column do not match.