Magento Profiler

connect

SET NAMES utf8

SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 1))

SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL)

SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_category_flat')

SELECT IS_USED_LOCK(?);

SELECT `catalog_category_flat_store_1`.`entity_id` FROM `catalog_category_flat_store_1` LIMIT 1

SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=382)

SELECT `main_table`.* FROM `catalog_category_flat_store_1` AS `main_table` WHERE (entity_id IN ('382', '516', '2', '1')) AND (custom_use_parent_settings = 0) AND (`level` != 0) ORDER BY `level` DESC

SELECT COUNT(catalog_category_flat_store_1.entity_id) FROM `catalog_category_flat_store_1` WHERE (catalog_category_flat_store_1.path LIKE '1/2/516/382/%') AND (catalog_category_flat_store_1.is_active = 1)

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
 INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC

SELECT `main_table`.`entity_id`, `main_table`.`name`, `url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS `main_table`
 LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.entity_id IN ('516', '382')) AND (main_table.is_active = '1') ORDER BY `main_table`.`path` ASC

SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/382') AND (store_id = 1) ORDER BY `is_system` DESC LIMIT 1

SELECT `index_process`.* FROM `index_process` WHERE (`index_process`.`indexer_code`='catalog_product_flat')

SELECT IS_USED_LOCK(?);

SELECT `core_flag`.* FROM `core_flag` WHERE (`core_flag`.`flag_code`='catalog_product_flat')

SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')

SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)

SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 WHERE (e.status = 1)

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.`attribute_id`, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN(4)) AND (`additional_table`.`is_filterable` > 0) GROUP BY `entity_attribute`.`attribute_id` ORDER BY position ASC

begin

INSERT INTO `sheep_debug_request_info` (`token`, `http_method`, `store_id`, `request_path`, `ip`, `session_id`, `date`, `query_time`, `query_count`, `info`) VALUES (?, ?, ?, ?, ?, ?, '2026-02-02 14:49:56', ?, ?, ?)

commit

SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category')

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='description') AND (entity_type_id = :entity_type_id)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='name') AND (entity_type_id = :entity_type_id)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')

SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = 31) AND `at_name_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = 31) AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) = 'Marques')

SELECT `catalog_category_flat_store_1`.* FROM `catalog_category_flat_store_1` WHERE (`catalog_category_flat_store_1`.`entity_id`=382)

SELECT `main_table`.`entity_id`, main_table.`name`, main_table.`path`, `main_table`.`is_active`, `main_table`.`is_anchor`, `url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS `main_table`
 LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.include_in_menu = '1') AND (main_table.is_active = '1') AND (main_table.path like '1/2/516/382/%') AND (`level` <= 4) ORDER BY `main_table`.`position` ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '66') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `Manufacturer_idx`.*, `Manufacturer_idx`.`value`, COUNT(Manufacturer_idx.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0
 INNER JOIN `catalog_product_index_eav` AS `Manufacturer_idx` ON Manufacturer_idx.entity_id = e.entity_id AND Manufacturer_idx.attribute_id = 66 AND Manufacturer_idx.store_id = 1 WHERE (e.status = 1) GROUP BY `Manufacturer_idx`.`value`

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=66)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 66) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '66') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('604', '386', '969', '2426', '611', '11749', '1696', '809', '3024', '2803', '968', '1264', '713', '603', '398', '1190', '32526', '3744', '27985', '32564', '35200')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=449)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 449) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '449') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('1')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=619)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 619) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '619') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('35212', '34681', '34671', '35209', '35211', '35214', '34670', '35222', '35208', '35213', '34680', '35216', '34676', '34672', '35230', '35219', '34678', '34675', '35217', '34677')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=626)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 626) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '626') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('34713', '34711', '')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=627)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 627) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '627') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('34684', '', '34685', '34683', '34686')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=635)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 635) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '635') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=637)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 637) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '637') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=647)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 647) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '647') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('35615', '35378', '', '35379')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=651)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 651) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '651') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '35672', '35681')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=493)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 493) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '493') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('258', '', '1036', '20300', '16219', '9229', '32143', '434', '1028', '17430', '32800', '17569', '35203', '35205', '35207', '35272', '35273', '35206', '35280')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=560)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 560) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '560') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('4406', '20281', '36033', '36017', '11282', '1233', '10068', '6589')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=554)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 554) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '554') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('1279', '33022', '1278', '35575', '36578', '1270', '2029', '35564', '35500', '35473', '35474', '2510', '32722', '3035', '3200', '32632', '', '3455', '3895', '3899', '3036', '4112', '3131', '1271', '35470', '35590', '35578', '31914', '36580', '35552', '35314', '35584', '33021', '32608', '33041', '1206', '1331', '32654', '1191', '33054', '32598', '2053', '2938', '32617', '32628', '32630', '32631', '36573', '33029', '35423', '35202', '35763', '35220', '35762', '35741', '35279', '35377')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=76)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 76) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '76') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('345', '346', '343', '344', '', '80', '26', '10', '65', '61', '3127', '118', '2928', '75', '17605', '538', '545', '59', '991', '3388', '540', '2839', '2558', '3326', '2915', '697', '67', '539', '76', '282', '696', '271', '31770', '18403', '16597', '2948', '106', '1137', '52', '12', '84', '1658', '4070', '26594', '10045', '580', '32413', '31769', '24021')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a`
 INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = :entity_type_code) AND (a.attribute_code = :attribute_code)

SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`=491)

SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)

SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1)

SELECT `catalog_product_entity_int`.* FROM `catalog_product_entity_int` WHERE (attribute_id = 491) AND (entity_id IN (8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75689, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78048, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 83321, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872, 101696, 104492, 104527, 104538, 106369))

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '491') AND (tdv.store_id = 0) AND (`main_table`.`option_id` IN('', '174', '166', '171', '184', '159', '2891', '188', '167', '250', '253', '259', '34432', '706', '192')) ORDER BY main_table.sort_order ASC, value ASC

SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = 382 AND cat_index.is_parent=1 WHERE (e.status = 1) AND (e.visibility = '4')

SELECT `main_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_for_sort_by = 1)

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 382 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC

SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 382 OR category_id IS NULL) AND (product_id IN(101696, 104492, 104527, 104538, 106369, 8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872)) ORDER BY `category_id` DESC

SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN(101696, 104492, 104527, 104538, 106369, 8506, 8507, 8509, 8511, 8512, 8513, 8514, 8515, 8516, 8518, 8519, 8520, 8521, 8522, 8523, 10947, 11856, 11884, 14070, 14093, 14351, 14574, 14661, 14704, 15882, 24621, 25730, 25766, 25767, 25772, 26424, 26428, 26432, 26491, 27028, 27061, 27064, 36075, 36088, 38211, 38218, 38886, 38887, 39352, 39357, 40242, 40245, 41570, 42825, 42837, 42869, 42880, 42883, 42912, 42916, 43297, 44090, 44120, 45293, 52013, 52656, 53532, 57319, 57352, 59776, 61653, 61666, 61670, 61791, 63024, 69022, 69200, 70018, 70044, 70050, 70136, 70139, 70238, 70389, 70795, 71089, 71092, 71166, 72388, 72394, 72735, 72764, 72765, 72779, 72824, 72825, 72952, 72958, 73485, 73975, 74014, 74236, 74400, 74462, 74567, 74575, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75618, 75619, 75621, 75661, 75662, 75663, 75664, 75665, 75666, 75667, 75668, 75671, 75672, 75673, 75674, 75675, 75676, 75677, 75678, 75681, 75682, 75683, 75684, 75685, 75686, 75860, 75868, 76254, 76509, 76563, 76965, 77218, 77328, 77683, 77773, 77774, 77779, 77780, 77781, 77851, 78295, 78401, 78402, 78403, 78459, 78614, 79128, 79266, 79341, 81317, 81581, 81948, 81951, 81953, 82488, 82500, 82515, 82592, 82597, 82601, 82602, 82638, 83007, 83045, 84659, 84672, 85507, 85511, 85512, 85660, 86177, 86382, 87337, 88302, 88379, 88395, 88416, 89196, 89243, 89244, 89245, 89246, 89247, 89249, 89250, 89251, 89252, 89798, 90146, 96600, 97398, 97408, 97440, 97604, 97621, 97652, 97653, 97733, 97871, 97872)) AND (stock_id=1) AND (website_id=1)

SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)

SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (5)) AND (rate.tax_country_id = 'FR') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=101696)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (101697, 101698, 101699, 101824)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=104492)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (88308, 104479, 104480, 104481, 104482, 104483, 104484, 104485, 104486, 104487, 104488, 104489)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=104527)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (104518, 104519, 104520, 104521, 104522, 104523, 104524, 104525)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=104538)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (104511, 104513, 104514, 104516, 104528, 104529, 104542, 104543)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (106369)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8506)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8507)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8509)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8511)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8512)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8513)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8514)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8515)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8516)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8518)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8519)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8520)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8521)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8522)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (8523)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=10947)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (10924, 10926, 10933, 10939, 10942, 10944, 16587, 27234, 27552, 30441, 35865, 44621, 58254, 58255, 72814, 72815, 72816, 77197, 83209, 83210, 86743, 86744, 86745, 102233, 104730, 104731)) AND (qty>'0')

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
 INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
 LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` = '4') ORDER BY entity_attribute.sort_order ASC

SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
 LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_id IN (508, 509, 56, 59, 612, 592, 58, 60, 70, 654, 66, 86, 67, 525, 511, 445, 620, 632, 637, 80, 597, 593, 57, 573, 71, 492, 626, 87, 68, 77, 512, 624, 641, 640, 82, 550, 497, 61, 72, 651, 553, 88, 69, 78, 625, 633, 496, 601, 647, 62, 73, 76, 491, 89, 623, 636, 65, 648, 594, 63, 79, 619, 627, 91, 644, 634, 502, 649, 595, 64, 493, 554, 504, 621, 635, 74, 495, 618, 599, 81, 628, 560, 622, 631, 586, 600, 617, 655, 558, 630, 84, 503, 608, 614, 656, 629, 85, 645, 642, 75, 639, 643, 449, 638, 555, 570, 83, 650, 569, 571, 598, 572, 92, 93, 446, 447, 448, 450, 451, 452, 453, 470, 471, 472, 524, 657, 658, 659, 660, 661)) AND (entity.attribute_set_id = :attribute_set_id)

SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (`product_id` = '10947') ORDER BY position  ASC

SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
 INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = 76) AND (`at_color`.`store_id` = 0) WHERE (link_table.parent_id = 10947) AND (at_color.value IS NOT NULL)

SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
 LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (10924, 10926, 10933, 10939, 10942, 10944, 16587, 27234, 27552, 30441, 35865, 44621, 58254, 58255, 72814, 72815, 72816, 77197, 83209, 83210, 86743, 86744, 86745, 102233, 104730, 104731)) AND (t_d.attribute_id IN (70, 71, 451, 452)) AND (t_d.store_id = 0)

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(10924, 10926, 10933, 10939, 10942, 10944, 16587, 27234, 27552, 30441, 35865, 44621, 58254, 58255, 72814, 72815, 72816, 77197, 83209, 83210, 86743, 86744, 86745, 102233, 104730, 104731))

SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def`
 LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 1 WHERE (def.product_super_attribute_id IN (47)) AND (def.store_id = 0)

SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (47)) AND (price.website_id = 0)

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table`
 INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
 LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 1 WHERE (`attribute_id` = '76') AND (`main_table`.`option_id` IN(580, 1658, 128, 278, 427, 285, 1808, 10045, 1753, 2558, 2928, 4070, 26595, 26594, 31770, 31769, 32147, 32413, 67, 32587, 32728, 32727, 32726, 35740, 36265, 36264)) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =10947)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 10947) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 10947) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 10947) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 10947) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 10947) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=10947) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (10947)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=10947) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (10924, 10926, 10933, 10939, 10942, 10944, 16587, 27234, 27552, 30441, 35865, 44621, 58254, 58255, 72814, 72815, 72816, 77197, 83209, 83210, 86743, 86744, 86745, 102233, 104730, 104731)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=11856)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (11857, 11858, 11859, 11861)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (11884)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=14070)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14071, 14072, 14073, 16738, 16739, 16740, 16742, 16743, 16746, 16747, 16748, 16750, 16752, 16751, 70571, 70572, 70573, 70574, 70575, 70576, 70577, 70578, 70579, 70580, 70581, 70582, 70583, 70584, 70585, 70586, 70587, 70588, 70589, 70590, 70591, 70592)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14093)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=14351)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14352, 14353, 62348, 62349, 106612, 106613, 106614, 106615)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14574)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14661)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=14704)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14705, 14706)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=15882)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (15883, 15884)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (24621)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=25730)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25737, 25738, 25741, 25742, 25743, 25744)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=25766)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25750, 25751, 25752, 25753, 25754, 25755, 25756, 25757, 25758, 25759)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=25767)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25768, 25769, 25770, 25771)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=25772)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (25773, 25774, 25775, 25776, 25777, 25778, 25779, 25780)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=26424)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (26426, 26427)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=26428)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (26430, 26431)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=26432)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (26434, 26435, 72241, 75378)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=26491)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (26492, 26494, 26495, 26496)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=27028)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (27030, 27031, 27032)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =27028)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27028) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27028) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27028) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27028) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27028) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=27028) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (27028)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=27028) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (27030, 27031, 27032)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=27061)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (23617, 27062)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=27064)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (17803, 27065, 27066, 18432)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =27064)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27064) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27064) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27064) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27064) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 27064) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=27064) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (27064)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=27064) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (17803, 27065, 27066, 18432)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=36075)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (36076, 36077, 36078, 36079)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=36088)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (36089, 36090, 36091, 36092, 36093)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=38211)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (38212, 38213, 38214, 38215)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=38218)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (38219, 38220, 38223, 38224)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (38886)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =38886)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38886) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38886) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38886) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38886) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38886) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=38886) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (38886)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=38886) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (38886)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=38887)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (28443, 38886, 45256)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =38887)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38887) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38887) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38887) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38887) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 38887) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=38887) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (38887)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=38887) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (28443, 38886, 45256)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=39352)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (39353, 39354, 39355, 39356)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=39357)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (39358, 39359, 39360, 39361)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=40242)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40243, 40245, 40246, 40247, 58380, 74125, 74126, 74127)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =40242)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40242) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40242) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40242) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40242) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40242) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=40242) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (40242)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=40242) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40243, 40245, 40246, 40247, 58380, 74125, 74126, 74127)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40245)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =40245)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40245) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40245) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40245) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40245) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 40245) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=40245) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (40245)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=40245) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (40245)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=41570)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (41571, 41575, 41576, 41578, 41579, 41580, 41584, 41585, 41587, 41588, 74131, 74132, 74133, 74134, 74135, 74136)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42825)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42837)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42869)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=42880)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42881, 42882, 61455)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42883)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42912)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (42916)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (43297)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =43297)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 43297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 43297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 43297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 43297) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 43297) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=43297) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (43297)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=43297) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (43297)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=44090)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (44092, 44093, 44091)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=44120)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (38871, 44121)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=45293)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (45294, 45295, 45296, 45297, 45298, 45299, 35032, 35033, 35034, 35035, 35036, 45255, 78613, 78614, 78615, 78616, 78617, 78618)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =45293)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 45293) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 45293) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 45293) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 45293) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 45293) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=45293) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (45293)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=45293) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (45294, 45295, 45296, 45297, 45298, 45299, 35032, 35033, 35034, 35035, 35036, 45255, 78613, 78614, 78615, 78616, 78617, 78618)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=52013)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (52038, 52040, 52042, 52043, 52044, 52045, 52052, 52055, 52056, 52057, 52058, 52062, 52064, 52066, 52067, 52068, 52069, 52076, 52079, 52080, 52081, 52082, 61896, 70265, 70817, 70818, 70819, 70820, 70821, 70822, 70823, 70824, 77137, 77139, 82967, 82968, 82970, 82971, 86554, 86555, 86556, 86557, 86558, 86559, 98717)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =52013)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52013) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52013) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52013) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52013) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 52013) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=52013) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (52013)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=52013) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (52038, 52040, 52042, 52043, 52044, 52045, 52052, 52055, 52056, 52057, 52058, 52062, 52064, 52066, 52067, 52068, 52069, 52076, 52079, 52080, 52081, 52082, 61896, 70265, 70817, 70818, 70819, 70820, 70821, 70822, 70823, 70824, 77137, 77139, 82967, 82968, 82970, 82971, 86554, 86555, 86556, 86557, 86558, 86559, 98717)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=52656)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14648, 52657)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=53532)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (53856, 53857, 53858, 53855)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=57319)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (34570, 34571, 34572, 34573, 34574, 34575, 57325, 57326, 57327, 57328, 57329, 57330)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=57352)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (34577, 34578, 34579, 34580, 34581, 57372, 57373, 57375, 57376, 57380, 57381, 57382, 57383, 57384, 57385, 57386, 57387, 57388, 57389)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (59776)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=61653)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61655, 61656, 61657, 61658, 61659, 61660, 61661, 61662, 61663, 61664)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=61666)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61667, 61668, 61669, 61670, 61671, 61672, 61673, 61674, 61675, 61676)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =61666)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61666) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61666) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61666) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61666) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61666) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=61666) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (61666)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=61666) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61667, 61668, 61669, 61670, 61671, 61672, 61673, 61674, 61675, 61676)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61670)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =61670)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61670) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61670) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61670) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61670) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 61670) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=61670) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (61670)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=61670) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61670)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=61791)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (14474, 14475, 61762, 61765, 61766, 61767, 61769)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=63024)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (63006, 63007, 63008, 63010, 63011, 63012, 63013, 63014, 63016, 63017, 63020, 63021, 57017, 60163)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =63024)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 63024) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 63024) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 63024) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 63024) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 63024) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=63024) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (63024)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=63024) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (63006, 63007, 63008, 63010, 63011, 63012, 63013, 63014, 63016, 63017, 63020, 63021, 57017, 60163)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=69022)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89503, 89504, 89505, 89506, 89507, 104842)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (69200)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70018)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (61423, 70019)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70044)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70045, 70046, 70047, 74114, 74115, 78175)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70050)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70051, 70052, 70053, 74113)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70136)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70137, 70138, 70139, 70140)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70139)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=70238)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70239, 70240, 70241)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70389)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70795)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =70795)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70795) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70795) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70795) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70795) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 70795) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=70795) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (70795)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=70795) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (76)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (491)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (70795)) AND (qty>'0')

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '71089')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (191, 192)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 59835))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '71089') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '71092')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (193, 195)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 71091))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '71092') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=71166)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (71167, 71169, 71170, 71175, 71176, 71177, 71180, 71181, 71182, 71184, 71185, 71186, 71187, 71188, 71189, 71190, 77107, 87461, 87462, 87463, 87464, 87465, 98731, 105503, 105504)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72388)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=72394)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72387, 72388)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72735)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72764)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72765)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72779)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72824)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (72825)) AND (qty>'0')

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '72952')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (265, 266)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(72954))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '72952') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=72958)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (63175, 63188, 63189, 72955, 72956, 72957)) AND (qty>'0')

SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =72958)

SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 72958) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 72958) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 72958) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 72958) AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
 INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = 4 WHERE (attr_table.entity_id = 72958) AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC

SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE (entity_id=72958) AND (website_id = 0)

SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = 73) AND (main.entity_id in (72958)) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC

SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id=72958) AND (website_id = 0) ORDER BY `qty` ASC

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (647)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_decimal` AS `default_value` WHERE (default_value.attribute_id IN (60)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (651)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (619)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (493)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (66)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (626)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (554)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (560)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (635)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT `default_value`.`attribute_id`, `default_value`.`value` AS `attr_value` FROM `catalog_product_entity_int` AS `default_value` WHERE (default_value.attribute_id IN (637)) AND (default_value.entity_type_id = :entity_type_id) AND (default_value.entity_id = :entity_id) AND (default_value.store_id = 0)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (63175, 63188, 63189, 72955, 72956, 72957)) AND (qty>'0')

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '73485')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (269, 270)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 73484))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '73485') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=73975)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (73980, 73981, 73982, 76607)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=74014)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (89750, 89751, 89752, 89753, 89754, 89756, 89757, 89758, 89759, 89760, 89761, 89762, 89763, 89764, 89766, 89767, 89768, 89769, 89770, 89771, 104843, 104844, 104845, 104846)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (74236)) AND (qty>'0')

SELECT `catalog_product_super_link`.`product_id` FROM `catalog_product_super_link` WHERE (parent_id=74400)

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (67639, 67640, 67641, 67642, 67643, 67644, 67645, 67646, 67647, 67648, 67649, 67650, 67651, 67652, 67653, 67654, 67655, 67656)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (74462)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (74567)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (74575)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75607)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75608)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75609)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75610)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75611)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75612)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75613)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75614)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75618)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75619)) AND (qty>'0')

SELECT sum(qty) AS `tot_qty` FROM `cataloginventory_stock_item` WHERE (product_id IN (75621)) AND (qty>'0')

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75661')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (570, 571)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 75607))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75661') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75662')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (572, 573)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 75608))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75662') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc

SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75663')

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `selection`.*, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`ean`, `e`.`popularity`, `e`.`colisage`, `e`.`magasins`, `e`.`ean_colombus`, `e`.`vendor`, `e`.`vendor_value`, `e`.`desc_json`, `e`.`service`, `e`.`nb_colis`, `e`.`vendor_sku`, `e`.`nuance`, `e`.`nuance_value`, `e`.`diametre`, `e`.`profondeur`, `e`.`largeur`, `e`.`hauteur`, `e`.`longueur`, `e`.`longueur_allonge`, `e`.`outdoor_indoor_les_2`, `e`.`outdoor_indoor_les_2_value`, `e`.`type_parasol`, `e`.`type_parasol_value`, `e`.`puissance`, `e`.`puissance_value`, `e`.`norme`, `e`.`classe_de_consommation`, `e`.`classe_de_consommation_value`, `e`.`variateur`, `e`.`irc`, `e`.`flux`, `e`.`temperature`, `e`.`temperature_value`, `e`.`format_source`, `e`.`format_source_value`, `e`.`energie_radiateur`, `e`.`energie_radiateur_value`, `e`.`declinaisons`, `e`.`bestsellers`, `e`.`profondeur_posee_tout_compris`, `e`.`source_fournie`, `e`.`poids_colis`, `e`.`dimensions_colis`, `e`.`hauteur_assise`, `e`.`availability_status`, `e`.`availability_status_value`, `e`.`colombus_designation_courte`, `e`.`colombus_designation_longue`, `e`.`declinaisons_text`, `e`.`sev_variation_axis`, `e`.`sev_labels`, `e`.`is_purchasable`, `e`.`can_show_price`, `e`.`tax_class_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id WHERE (e.status = 1) AND (((e.required_options != '1') OR (e.required_options IS NULL))) AND (selection.option_id IN (574, 575)) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table`
 INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
 LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id=1 WHERE (`main_table`.`stock_id` = '1') AND (`main_table`.`product_id` IN(71088, 75609))

SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table`
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id and option_value_default.store_id = 0
 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id and option_value.store_id = 1 WHERE (`main_table`.`parent_id` = '75663') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc