Returning results for: LSD1 BHC110
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 '' at line 14

select count(distinct p.products_id) as total from products p LEFT JOIN ( SELECT pfsap.products_id, GROUP_CONCAT(CONCAT_WS(' ', pfsa.products_filters_name, pfsca.products_filters_categories_name) SEPARATOR ' ') AS etk_app_filter_text FROM products_filters_to_products pfsap LEFT JOIN products_filters pfsa ON pfsap.products_filters_id = pfsa.products_filters_id LEFT JOIN products_filters_categories pfsca ON pfsa.products_filters_categories_id = pfsca.products_filters_categories_id WHERE (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LCASE(CONCAT_WS(' ', pfsa.products_filters_name, pfsca.products_filters_categories_name)), '&', ''), '&', ''), '-', ''), ' ', ''), '/', ''), '_', ''), '(', ''), ')', ''), '[', ''), ']', ''), '{', ''), '}', ''), '.', ''), ',', ''), ':', ''), ';', ''), '+', '') LIKE '%lsd1%') GROUP BY pfsap.products_id ) etkapp ON p.products_id = etkapp.products_id left join products_description pd on p.products_id = pd.products_id left join products_references pr on (p.products_id = pr.products_id) left join manufacturers m on p.manufacturers_id=m.manufacturers_id left join specials s on p.products_id = s.products_id left join ( select case when pop_p.products_master > 0 then pop_p.products_master else pop_p.products_id end as products_id, sum(op.products_quantity) as popularity_units from orders_products op left join products pop_p on op.products_id = pop_p.products_id where pop_p.products_id is not null

[TEP STOP]