string(553) "-- /is/htdocs/wp1103691_W6JU828YMS/shop/includes/modules/product_list_filters.php (line: 1019)
SELECT DISTINCT m.manufacturers_id AS id,
m.manufacturers_name AS name,
m.manufacturers_image AS image FROM products p JOIN products_description pd ON (pd.products_id = p.products_id) JOIN manufacturers AS m ON (m.manufacturers_id = p.manufacturers_id) WHERE p.products_status = '1' AND pd.language_id = 2 AND trim(pd.products_name) != '' AND m.manufacturers_id > 0 GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name"