1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%' OR products_description.products_name LIKE '%Train%'
SELECT *
FROM
`products`
INNER JOIN `products_description` ON (`products`.`products_id` = `products_description`.`products_id`)
INNER JOIN `products_to_categories` ON (`products_description`.`products_id` = `products_to_categories`.`products_id`)
LEFT JOIN `manufacturers` ON (`products`.`manufacturers_id` = `manufacturers`.`manufacturers_id`)
WHERE products_description.products_name LIKE '%Character%' OR products_description.products_name LIKE '%Options%' OR products_description.products_name LIKE '%Peppa%' OR products_description.products_name LIKE '%Pig%' OR products_description.products_name LIKE '%on%' OR products_description.products_name LIKE '%Grandpa%' OR products_description.products_name LIKE '%Pig's%' OR products_description.products_name LIKE '%Train%'
ORDER BY products_to_categories.categories_id,`manufacturers`.`manufacturers_name`, products_description.products_name
LIMIT 100
