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 id asc' at line 1syntax error: SELECT tenkodau_vi as tenkodau FROM table_product_collection where shows=1 and id_list= order by id asc