select * from product where 1 and part in('500','501','503','600','601','602','603') and CONCAT(',',makes,',') like '%,ME,%' order by find_in_set(part, "500,501,503,600,601,602,603") limit -10,10
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 '-10,10' at line 1