/home/preisdbo/www.preistipp.de/preistipp-v2/sql/pt_categories/s.2010.products.products.sql

# CW | s.2010.products.products

	SELECT 
		`p`.`id`,
		`p`.`name`,
		`p`.`text`,
		`p`.`flag_offers_min`,
		`p`.`flag_offers_max`,
		`p`.`flag_offers_num`,
		`p`.`flag_offers_num2`,
		`p`.`flag_offers_num3`,
		`p`.`flag_offers_num_m`,
		`m`.`id`   AS `manufacturer_id`,
		`m`.`name` AS `manufacturer_name`,
		(
			SELECT AVG(`flag_rating`)
			FROM `s_products_ratings`
			WHERE `id_product` = `p`.`id`
		) AS `flag_ratings_avg`,
		(
			SELECT COUNT(1)
			FROM `s_products_ratings`
			WHERE `id_product` = `p`.`id`
		) AS `flag_ratings_num`,
		
		CASE
		WHEN (`p`.`flag_offers_min` = 0 AND "`p`.`flag_popularity` DESC" IN ('`p`.`flag_offers_min` ASC')) THEN 1
		ELSE 0 END AS `sort_offline`
		
	FROM `tmp_po_products` AS `tp`
	INNER JOIN `s_products` AS `p`
		ON `p`.`id` = `tp`.`id_product`
	LEFT OUTER JOIN `s_manufacturers` AS `m`
		ON `m`.`id` = `p`.`id_manufacturer`
		
	WHERE `tp`.`id_handle` = "357013"
	AND (
		   (`p`.`flag_offers_min` BETWEEN "0" AND "0")
		OR (`p`.`flag_offers_max` BETWEEN "0" AND "0")
		OR ("0" = "0" AND "0" = "0")
	)
	AND   (`p`.`id_manufacturer` = 0 OR "0" = "0")
	AND (0 = (
		SELECT COUNT(DISTINCT `id_value`)
		FROM `s_products_specifications`
		WHERE `id_product` = `p`.`id`
		AND   `id_value`  IN (0)
		AND   `id_value`  > 0
	))
	GROUP BY `p`.`id`
	ORDER BY `sort_offline`,`p`.`flag_popularity` DESC
	LIMIT 0,10

Got error 28 from storage engine