Error found in query : SELECT DISTINCT min(ma.price) min_price, max(ma.price) max_price FROM gf_products p INNER JOIN gf_products_firms f ON f.id=p.id_firm INNER JOIN gf_products_multiple_assign ma ON ma.id_product = p.id INNER JOIN gf_products_target_audience pt ON pt.product_id = ma.id_product INNER JOIN gf_products_to_category tc ON tc.id_product = p.id WHERE 1=1 and (ma.stock > 0 OR ma.sku IN('lego883313','lego5529','inkHKPE6','lego10505','nen9020','LOLPSSNSR','LOLPSSNSPB','LOLPSSNSW','LOLPSSNSO','LOLBNSM1CPP','LOLBNSM1CBB','LOLBNSM1CC','LOLBNSM2CBB','LOLBNSM2CT','LOLPSNCM1CPR','LOLPSNCM1CPB','LOLPSNCM1CW','LOLPSNCM2CPR','LOLPSNCM2CPB','LOLPSNCM2CW','LOLWNBCM','LOLNLS2','LOLBBMSTS10','LOLBBMLS10','LOLBWMS10','LOLBBPLYM1CCS10','LOLBCDM03LCNB','LOLBCDM36LCR','LOLBDDM03LCP','LOLBBDM03LCRO','LOLBBDM36LCRO','LOLBAFMNBLCB','LOLBAFM03LCB','LOLBAFM03SCB','LOLBPBM36LCR','LOLBCM36LCG','LOLPBMNB03CBR','LOLPBMNB03CP','LOLBSBM03CB','LOLBSBM03CP','LOLBLM03FSCP','LOLBLM03FSCB','LOLWABVM03CP','LOLWABVM03CB','LOLLMMUCR','LOLLMMUCP','LOLLMMUCB','LOLHTMUCWN','LOLHTMUCWP','LOLEPM03CP','LOLEPM03CRC','LOLEPM03CRN','LOLSBM03CB','LOLTLM03CB','LOLTLM03CP','LOLMBMUCMULTI','LOLMBMUCMULTIM','LOLBPMUCW','LOLPPMOSCW','MIOSWPSF','MIOSWPSN','MIOSWPSO','MIOSWPMF','MIOSWPMM','MIOSWPMN','MIOSWPMO','MIOSWPLF','MIOSWPLM','MIOSWPLN','MIOSWPLO','MIOSWPXLF','MIOMG','MIOBL8','OLFLC','MIOWPSC60','MIONKSOXMARSHMELLOW','MIONKSOXCOLACUBE','M) ) and (tc.id_category IN (1503) OR tc.id_category = 1503)
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 ''M) ) and (tc.id_category IN (1503) OR tc.id_category = 1503)' at line 7

Jucarii de rol

Scule si unelte copii