You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by priority asc' at line 1
select * from product_cat_db where pid = order by priority asc