Database error: Invalid SQL: SELECT pm.prod_id , pm.prod_image, pm.prod_colour, pm.prod_gender, pm.prod_tailor_made, pm.prod_febric, pm.prod_sef_url, pm.prod_title, pm.prod_base_price, pm.prod_visible, pm.prod_code_id, pm.prod_similar, pm.prod_desc, pp.price_country_code, pp.price_prod_special, pp.price_markup, pp.final_markup_price FROM product_master as pm LEFT JOIN product_price as pp on pp.price_prod_id = pm.prod_id AND CONCAT(pp.price_prod_id,pp.price_country_code,pp.price_prod_startdate,pp.price_prod_enddate) = (SELECT concat(pps.price_prod_id,pps.price_country_code,pps.price_prod_startdate,pps.price_prod_enddate) FROM product_price as pps WHERE pps.price_prod_id = pm.prod_id AND (pps.price_country_code='US' OR pps.price_country_code = '0') AND ((pps.price_prod_startdate = '0000-00-00' AND pps.price_prod_enddate = '0000-00-00') OR (pps.price_prod_startdate <= '2024-05-09' AND pps.price_prod_endtime = '0000-00-00') OR (pps.price_prod_startdate= '0000-00-00' AND pps.price_prod_enddate >= '2024-05-09') OR (pps.price_prod_startdate <= '2024-05-09' AND pps.price_prod_enddate >= '2024-05-09')) ORDER BY pps.price_country_code DESC, pps.price_prod_startdate, pps.price_prod_enddate limit 1) WHERE prod_sef_url = '' measurinfo.a '' And prod_visible='Yes'
MySQL Error: 1064 (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 'measurinfo.a '' And prod_visible='Yes'' at line 1)
Session halted.