An Error Was Encountered
Error Number: 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 'ORDER BY l.ordem' at line 7
SELECT id_loja,id_loja_cat,titulo_cat_pt,titulo_cat_en,titulo_pt,titulo_en,subtitulo_pt,subtitulo_en,desc_pt,desc_en,preco,l.thumbnail ,l.img_loja ,l.thumbnail_prod FROM tbl_loja l INNER JOIN tbl_loja_cat c on loja_cat_id = id_loja_cat WHERE l.publicado = 1 AND c.publicado = 1 AND id_loja = ORDER BY l.ordem