SELECT
						store_products.*,
						store_product_types2customer_types.multiplier,
						customer_types.incvat AS incvat,
						store_warehouses.use_stock, 
						store_warehouses.name AS warehouse_name 
					FROM
						store_products
					INNER JOIN
						 store_product_types ON
						 store_product_types.id = store_products.typeid
					INNER JOIN
						 store_product_types2customer_types ON
						 store_product_types2customer_types.producttypeid = store_product_types.id
					INNER JOIN
						 customer_types ON
						 customer_types.id = store_product_types2customer_types.customertypeid
					INNER JOIN
						store_warehouses ON
						store_warehouses.id = store_products.warehouseid
					WHERE
						store_products.active = '1' AND
						store_products.approved = '1' AND
						store_products.totallyhidden = '0' AND
						customer_types.id = '1' AND
						store_products.id <> '35796' AND 
						(
							 MATCH(store_products.name) AGAINST ("front +fixing +screw" IN NATURAL LANGUAGE MODE) 
						
							
						)
					GROUP BY
						store_products.id
					ORDER BY
						 store_products.buybutton DESC , store_products.`rank` DESC, store_products.id DESC, store_products.price DESC 
					LIMIT
						0,4