| mysql |
Mage_Core_Model_Resource_Store_Collection |
SELECT `main_table`.* FROM `core_store` AS `main_table` |
| mysql |
Mage_Core_Model_Resource_Website_Collection |
SELECT `main_table`.* FROM `core_website` AS `main_table` |
| mysql |
Mage_Core_Model_Resource_Store_Group_Collection |
SELECT `main_table`.* FROM `core_store_group` AS `main_table` |
| eav |
Mage_Catalog_Model_Resource_Category_Collection |
SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '937') AND `at_custom_use_parent_settings_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '937') AND (`at_custom_use_parent_settings`.`store_id` = 3) WHERE (`e`.`entity_type_id` = '9') AND (`e`.`entity_id` IN('1278', '1277', '3', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) |
| mysql |
Mage_Catalog_Model_Resource_Product_Attribute_Collection |
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 = 3 WHERE (main_table.entity_type_id = 10) AND (`entity_attribute`.`attribute_set_id` IN('64')) AND (`additional_table`.`is_filterable` > 0) GROUP BY `entity_attribute`.`attribute_id` |
| eav |
Mage_Catalog_Model_Resource_Category_Collection |
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '119') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '119') AND (`at_is_active`.`store_id` = 3) WHERE (`e`.`entity_type_id` = '9') AND (`e`.`entity_id` IN('1277', '1278')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') |
| eav |
OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Collection |
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=3 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1278' 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 |
| eav |
Mage_ConfigurableSwatches_Model_Resource_Catalog_Product_Type_Configurable_Product_Collection |
SELECT `e`.*, `link_table`.`parent_id` 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_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' WHERE (link_table.parent_id in ('28286', '28548', '28473', '28472', '28350', '28346', '28344', '28338', '28337', '28336', '28335', '28330', '28313', '28310', '28307', '28306', '28304', '28289', '28549')) |
| mysql |
Mage_ConfigurableSwatches_Model_Resource_Catalog_Product_Attribute_Super_Collection |
SELECT `main_table`.*, `eav_attributes`.* FROM `catalog_product_super_attribute` AS `main_table`
INNER JOIN `eav_attribute` AS `eav_attributes` ON `eav_attributes`.`attribute_id` = `main_table`.`attribute_id` WHERE (`product_id` IN('28286', '28548', '28473', '28472', '28350', '28346', '28344', '28338', '28337', '28336', '28335', '28330', '28313', '28310', '28307', '28306', '28304', '28289', '28549')) AND (`eav_attributes`.`attribute_id` IN('1039', '1046', '1081', '1011', '1046')) |
| eav |
Mage_Catalog_Model_Resource_Category_Collection |
SELECT `e`.*, `core_url_rewrite`.`request_path`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='3' AND core_url_rewrite.id_path LIKE 'category/%')
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '119') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '119') AND (`at_is_active`.`store_id` = 3) WHERE (`e`.`entity_type_id` = '9') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('1406', '1408', '1413', '1417', '1420', '1423')) |
| mysql |
Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection |
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 = '3' WHERE (`attribute_id` = '975') AND (tdv.store_id = 0) |
| mysql |
Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection |
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 = '3' WHERE (`attribute_id` = '1011') AND (tdv.store_id = 0) |
| mysql |
Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection |
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 = '3' WHERE (`attribute_id` = '1051') AND (tdv.store_id = 0) |
| mysql |
Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection |
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 = '3' WHERE (`attribute_id` = '1046') AND (tdv.store_id = 0) |
discussion en ligne/chat 
Envoyer un message Demandez votre catalogue Grimaud & Gelard
