/home/preisdbo/www.preistipp.de/preistipp-v2/sql/pt_products/s.products.details.sql

# CW | s.products.details

	SELECT
		`p`.`id`,
		`p`.`id_category`,
		`p`.`id_level_1`,
		`p`.`name`,
		`p`.`text`,
		`p`.`flag_new`,
		`p`.`flag_offers_num`,
		`p`.`flag_offers_num2`,
		`p`.`flag_offers_num3`,
		`p`.`flag_offers_num_m`,
		`p`.`flag_offers_min`,
		`p`.`flag_offers_max`,
		`p`.`flag_offers_min_m`,
		`cp`.`name` AS `category_p`,
		`c`.`id`   AS `category_id`,
		`c`.`name` AS `category_name`,
		`m`.`id`   AS `manufacturer_id`,
		`m`.`name` AS `manufacturer_name`,
		(
			SELECT AVG(`flag_rating`)
			FROM `s_products_ratings`
			WHERE `id_product` = `p`.`id`
			AND `flag_active` = "1"
		) AS `flag_ratings_avg`,
		(
			SELECT COUNT(1)
			FROM `s_products_ratings`
			WHERE `id_product` = `p`.`id`
			AND `flag_active` = "1"
		) AS `flag_ratings_num`,
		(
			SELECT COUNT(DISTINCT `o`.`id_partner`)
			FROM `s_offers` AS `o`
			INNER JOIN `s_partners` AS `h`
				ON  `h`.`id`             = `o`.`id_partner`
			WHERE `o`.`id_product`   	  = `p`.`id`
			AND   `h`.`flag_offline` > 0
			AND   `h`.`flag_distributor` = 0
			AND (
				0 IN (51.4438926,7.3531970,50)
			   OR SQRT(
					pow((51.4438926 - `h`.`coords_x`), 2) + 
					pow((7.3531970 - `h`.`coords_y`), 2)
				) * 111 < 50
			)
		) AS `num_offline`,
		(
			SELECT COUNT(DISTINCT `h`.`id`)
			FROM `s_offers` AS `o`
			INNER JOIN `s_partners` AS `h`
				ON  `h`.`id_distributor`  = `o`.`id_partner`
			WHERE `o`.`id_product`   	  = `p`.`id`
			AND   `h`.`flag_offline` > 0
			AND   `h`.`flag_distributor` = 0
			AND (
				0 IN (51.4438926,7.3531970,50)
			   OR SQRT(
					pow((51.4438926 - `h`.`coords_x`), 2) + 
					pow((7.3531970 - `h`.`coords_y`), 2)
				) * 111 < 50
			)
		) AS `num_offline_distributor`
	FROM `s_products` AS `p`
	LEFT OUTER JOIN `s_categories` AS `c`
		ON `c`.`id` = `p`.`id_category`
	LEFT OUTER JOIN `s_categories` AS `cp`
		ON `cp`.`id` = `c`.`id_parent`
	LEFT OUTER JOIN `s_manufacturers` AS `m`
		ON `m`.`id` = `p`.`id_manufacturer`
	WHERE `p`.`id` = "3224865"

Table 'usrdb_texmedcn_cw.s_offers' doesn't exist