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 '¼ltiselect_maincat=10⊂cat=57μltiselect_subcat=57 ORDER BY prod_p' at line 10|SELECT prod_id, prod_std_short_desc, prod_std_img_params, t_adm_produit.man_id, prod_sku, prod_part_number, prod_name, t_adm_Prod_Main_cat, t_adm_Prod_Sub_cat, t_adm_Prod_Third_cat, prod_img, prod_prix_reg, prod_prix_spe, prod_inventory, prod_prix_cost, prod_ship_weight, prod_ship_cost, prod_prix_C1, prod_prix_C2, prod_prix_C3, prod_prix_C4, prod_prix_C5, prod_SupplierWasStock, prod_promo_calc_margin_by_percentage, prod_InventoryOverride, prod_promo_while_stock_last_tag, prod_promo_priority, prod_promo_start_date, prod_promo_end_date, prod_promo_margin_value, prod_pomo_presale_mode, prod_promo_actif, prod_promo_only_if_stock, prod_promo_calc_by_margin, prod_promo_fixed_price, prod_prix_spec_expire, prod_future_std
,t_cat_main.cat_name as MainCatName,
t_sub_cat.sub_name as SubCatName,
t_third_cat.third_name as ThirdCatName,
t_adm_manufacturiers.man_nom as mfgname
FROM t_adm_produit
LEFT JOIN t_cat_main ON t_adm_produit.t_adm_Prod_Main_cat = t_cat_main.id
LEFT JOIN t_sub_cat ON t_adm_produit.t_adm_Prod_Sub_cat = t_sub_cat.sub_id
LEFT JOIN t_third_cat ON t_adm_produit.t_adm_Prod_Third_cat = t_third_cat.sub_id
LEFT JOIN t_adm_manufacturiers ON t_adm_produit.man_id = t_adm_manufacturiers.man_id WHERE prod_virtuel <> 1 AND prod_inventory > 0 AND prod_prix_cost > 0 AND t_adm_Prod_Main_cat = 10μltiselect_maincat=10⊂cat=57μltiselect_subcat=57 ORDER BY prod_prix_C3 ASCYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¼ltiselect_maincat=10⊂cat=57μltiselect_subcat=57 ORDER BY prod_p' at line 10|SELECT prod_id, prod_std_short_desc, prod_std_img_params, t_adm_produit.man_id, prod_sku, prod_part_number, prod_name, t_adm_Prod_Main_cat, t_adm_Prod_Sub_cat, t_adm_Prod_Third_cat, prod_img, prod_prix_reg, prod_prix_spe, prod_inventory, prod_prix_cost, prod_ship_weight, prod_ship_cost, prod_prix_C1, prod_prix_C2, prod_prix_C3, prod_prix_C4, prod_prix_C5, prod_SupplierWasStock, prod_promo_calc_margin_by_percentage, prod_InventoryOverride, prod_promo_while_stock_last_tag, prod_promo_priority, prod_promo_start_date, prod_promo_end_date, prod_promo_margin_value, prod_pomo_presale_mode, prod_promo_actif, prod_promo_only_if_stock, prod_promo_calc_by_margin, prod_promo_fixed_price, prod_prix_spec_expire, prod_future_std
,t_cat_main.cat_name as MainCatName,
t_sub_cat.sub_name as SubCatName,
t_third_cat.third_name as ThirdCatName,
t_adm_manufacturiers.man_nom as mfgname
FROM t_adm_produit
LEFT JOIN t_cat_main ON t_adm_produit.t_adm_Prod_Main_cat = t_cat_main.id
LEFT JOIN t_sub_cat ON t_adm_produit.t_adm_Prod_Sub_cat = t_sub_cat.sub_id
LEFT JOIN t_third_cat ON t_adm_produit.t_adm_Prod_Third_cat = t_third_cat.sub_id
LEFT JOIN t_adm_manufacturiers ON t_adm_produit.man_id = t_adm_manufacturiers.man_id WHERE prod_virtuel <> 1 AND prod_inventory = 0 AND prod_prix_cost > 0 AND t_adm_Prod_Main_cat = 10μltiselect_maincat=10⊂cat=57μltiselect_subcat=57 ORDER BY prod_prix_C3 ASC