/home/preisdbo/www.preistipp.de/preistipp-v2/sql/pt_products_offers/s.offers.details.sql

# CW | s.offers.details

	SELECT
		`p`.`id`   AS `partner_id`,
		`p`.`name` AS `partner_name`,
		`p`.`flag_offline`,
		`p`.`flag_pickup`,
		`p`.`service_name`,
		`p`.`service_street`,
		`p`.`service_zip`,
		`p`.`service_city`,
		`p`.`service_phone`,
		`p`.`flag_shippingfree`,
		`o`.`id`,
		`o`.`price`,
		`o`.`delivery_st` AS `price_incl_st`,
		`o`.`delivery_nd` AS `price_incl_nd`,
		`o`.`name`,
		`o`.`delivery_st`,
		`o`.`delivery_nd`,
		`o`.`flag_mobile`,
		`o`.`timestamp`,
		`os`.`id_status` AS `stockcode_status`,
		`os`.`name`      AS `stockcode_name`,
		`pa`.`flag_award_001`,
		`pa`.`flag_award_002`,
		`pa`.`flag_award_003`,
		`pa`.`flag_award_004`,
		`pa`.`flag_award_005`,
		(
			SELECT AVG(`flag_rating`)
			FROM `s_partners_ratings`
			WHERE `id_partner`  = `p`.`id`
			AND   `flag_active` = "1"
		) AS `flag_ratings_avg`,
		(
			SELECT AVG(`flag_rating`)
			FROM `s_partners_ratings`
			WHERE `id_partner`  = `p`.`id`
			AND   `flag_active` = "1"
		) * 20 AS `flag_ratings_per`,
		(
			SELECT COUNT(1)
			FROM `s_partners_ratings`
			WHERE `id_partner`  = `p`.`id`
			AND   `flag_active` = "1"
		) AS `flag_ratings_num`,
		SQRT(
			pow(("51.4438926" - `p`.`coords_x`), 2) + 
			pow(("7.353197" - `p`.`coords_y`), 2)
		) * 111 AS `distance`,
		(
			SELECT `name`
			FROM `s_partners_sales`
			WHERE `id_partner` = `p`.`id`
			AND   (`timestamp_s` <= NOW() OR `timestamp_s` = '1970-01-01 00:00:00')
			AND   (`timestamp_e` >= NOW() OR `timestamp_e` = '1970-01-01 00:00:00')
			LIMIT 1
		) AS `partner_sale`,
		(
			SELECT COUNT(1)
			FROM `s_partners_flyers`
			WHERE `id_partner` = `p`.`id`
			AND   (`timestamp_s` <= NOW() OR `timestamp_s` = '1970-01-01 00:00:00')
			AND   (`timestamp_e` >= NOW() OR `timestamp_e` = '1970-01-01 00:00:00')
			LIMIT 1
		) AS `partner_flyer`,
		(
			SELECT `delivery_info`
			FROM `usrdb_texmedcn_fe`.`psm_fe_partners`
			WHERE id = p.id
		) AS `delivery_info`,
		(
			SELECT `url_delivery`
			FROM `usrdb_texmedcn_fe`.`psm_fe_partners`
			WHERE id = p.id
		) AS `service_url_delivery`
		
	FROM `s_offers` AS `o`
	INNER JOIN `s_partners` AS `p`
		ON  `p`.`id`             = `o`.`id_partner`
		OR  `p`.`id_distributor` = `o`.`id_partner`
	LEFT OUTER JOIN `s_offers_stockcodes` AS `os`
		ON `os`.`id` = `o`.`id_stockcode`
	LEFT OUTER JOIN `s_partners_awards` AS `pa`
		ON `p`.`id` = `pa`.`id_partner`
	WHERE `o`.`id_product`   	  = "3644268"
	AND   `o`.`flag_mobile`  	  = "0"
	AND   "0" IN (0,`o`.`flag_provider`) 
	AND   `p`.`flag_offline` 	  = "0"
	AND   `p`.`flag_distributor` = "0"
	AND (
		   `p`.`flag_offline` = "0" 
		OR 0 IN ("51.4438926","7.353197","50")
	   OR SQRT(
			pow(("51.4438926" - `p`.`coords_x`), 2) + 
			pow(("7.353197" - `p`.`coords_y`), 2)
		) * 111 < "50"
	)
	ORDER BY 
		`price`, 
		`price_incl_st`, 
		`price_incl_nd`, 
		`flag_ratings_avg` DESC,
		`flag_ratings_num` DESC,
		`p`.`name`
	LIMIT 0,10

Got error 28 from storage engine