select distinct pd.products_name, p.products_image, p.products_model, p.products_quantity, m.manufacturers_id, p.products_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id left join (select pt.tags_name, p2t.products_id from products_tags pt, products_to_tags p2t where pt.tags_id = p2t.tags_id) as t on p.products_id = t.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and ( (pd.products_name like '%mr%' or p.products_model like '%mr%' or p.products_replacement like '%mr%' or m.manufacturers_name like '%mr%' or REPLACE(p.products_model,'-','') like '%mr%' or REPLACE(p.products_replacement,'-','') like '%mr%' or p.products_model like REPLACE('%mr%','-','') or p.products_replacement like REPLACE('%mr%','-','') or t.tags_name like '%mr%' or p.products_model like CONCAT((select manufacturers_short from manufacturers_info where manufacturers_name like '%mr%' and languages_id = '4' limit 1), ' %')) and (pd.products_name like '%gasket%' or p.products_model like '%gasket%' or p.products_replacement like '%gasket%' or m.manufacturers_name like '%gasket%' or REPLACE(p.products_model,'-','') like '%gasket%' or REPLACE(p.products_replacement,'-','') like '%gasket%' or p.products_model like REPLACE('%gasket%','-','') or p.products_replacement like REPLACE('%gasket%','-','') or t.tags_name like '%gasket%' or p.products_model like CONCAT((select manufacturers_short from manufacturers_info where manufacturers_name like '%gasket%' and languages_id = '4' limit 1), ' %') or p.products_model like CONCAT((select manufacturers_short from manufacturers_info where manufacturers_name like '%gasket%' and languages_id = '4' limit 1, 1), ' %')) ) order by pd.products_name, p.products_model
Mr Gasket bränslepump eliminerar ånglås och översvämningar. Bränslepumpen fungerar bra som överföringspump och är en utmärkt fristående eller booster pump. Den levereras med en självsugande pump med en enkel två-kabel konstruktion. Den går på 12 volt negativ ... Läs Mer..