SELECT SQL_CALC_FOUND_ROWS  
		spares.id AS id, 
		categories.id AS c_id, 
		categories.ru AS category, 
		spares.info_ru AS info, 
		spares.manufacturer AS manufacturer, 
		spares.price AS price, 
		spares.price_bronze AS price_bronze, 
		spares.price_silver AS price_silver, 
		spares.akcija AS akcija, 
		spares.scramble AS scramble, 
		spares.instock AS instock, 
		cars.id AS car, 
		cars.years AS years, 
		models.ru AS model, 
		brands.short AS brand, 
		brands.id AS b_id, 
		search_ru AS search 
	FROM spares 
	INNER JOIN categories ON spares.category_id = categories.id 
	INNER JOIN spares_cars ON spares.id = spares_cars.spare_id 
	INNER JOIN cars ON spares_cars.car_id = cars.id 
	INNER JOIN brands ON cars.brand_id = brands.id 
	INNER JOIN models ON cars.model_id = models.id
   WHERE IF(c = '', brands.first != 1, brands.first = c)
       AND MATCH (`search_ru`) AGAINST (cr)
	ORDER BY cars.id, categories.ru, spares.id
   LIMIT l;
   SELECT FOUND_ROWS();