There has been an error processing your request
SELECT `e`.*, `at_special_price`.`value` AS `special_price`, IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) AS `special_from_date`, IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) AS `special_to_date`, `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`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_short_description.value_id > 0, at_short_description.value, at_short_description_default.value) AS `short_description`, `at_price`.`value` AS `price`, IF(at_small_image.value_id > 0, at_small_image.value, at_small_image_default.value) AS `small_image`, IF(at_thumbnail.value_id > 0, at_thumbnail.value, at_thumbnail_default.value) AS `thumbnail`, IF(at_news_from_date.value_id > 0, at_news_from_date.value, at_news_from_date_default.value) AS `news_from_date`, IF(at_news_to_date.value_id > 0, at_news_to_date.value, at_news_to_date_default.value) AS `news_to_date`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_tax_class_id.value_id > 0, at_tax_class_id.value, at_tax_class_id_default.value) AS `tax_class_id`, IF(at_url_key.value_id > 0, at_url_key.value, at_url_key_default.value) AS `url_key`, `at_price_type`.`value` AS `price_type`, `at_weight_type`.`value` AS `weight_type`, `at_price_view`.`value` AS `price_view`, `at_shipment_type`.`value` AS `shipment_type`, IF(at_image_label.value_id > 0, at_image_label.value, at_image_label_default.value) AS `image_label`, IF(at_small_image_label.value_id > 0, at_small_image_label.value, at_small_image_label_default.value) AS `small_image_label`, IF(at_thumbnail_label.value_id > 0, at_thumbnail_label.value, at_thumbnail_label_default.value) AS `thumbnail_label`, `at_links_purchased_separately`.`value` AS `links_purchased_separately`, `at_links_exist`.`value` AS `links_exist`, `at_is_imported`.`value` AS `is_imported`, IF(at_msrp_enabled.value_id > 0, at_msrp_enabled.value, at_msrp_enabled_default.value) AS `msrp_enabled`, IF(at_msrp_display_actual_price_type.value_id > 0, at_msrp_display_actual_price_type.value, at_msrp_display_actual_price_type_default.value) AS `msrp_display_actual_price_type`, `at_msrp`.`value` AS `msrp`, `at_fb_product`.`value` AS `fb_product`, IF(at_vendibile.value_id > 0, at_vendibile.value, at_vendibile_default.value) AS `vendibile`, IF(at_testoprezzo.value_id > 0, at_testoprezzo.value, at_testoprezzo_default.value) AS `testoprezzo`, IF(at_combustibile.value_id > 0, at_combustibile.value, at_combustibile_default.value) AS `combustibile`, `at_prezzolistino`.`value` AS `prezzolistino`, `at_c2c_salable`.`value` AS `c2c_salable`, `at_c2c_marca`.`value` AS `c2c_marca`, `at_c2c_tipologia`.`value` AS `c2c_tipologia`, IF(at_c2c_design.value_id > 0, at_c2c_design.value, at_c2c_design_default.value) AS `c2c_design`, `at_c2c_potenza`.`value` AS `c2c_potenza`, `at_c2c_tecnologia`.`value` AS `c2c_tecnologia`, `at_c2c_combustibile`.`value` AS `c2c_combustibile`, `at_c2c_diametro`.`value` AS `c2c_diametro`, `at_c2c_portata_nom`.`value` AS `c2c_portata_nom`, `at_c2c_portata_max`.`value` AS `c2c_portata_max`, `at_c2c_tipologia_valvola`.`value` AS `c2c_tipologia_valvola`, `at_c2c_colore`.`value` AS `c2c_colore`, `at_c2c_lunghezza`.`value` AS `c2c_lunghezza`, `at_c2c_attacchi`.`value` AS `c2c_attacchi`, `at_c2c_classe`.`value` AS `c2c_classe`, `at_c2c_pompa_di_calore`.`value` AS `c2c_pompa_di_calore`, IF(at_c2c_ad_uso.value_id > 0, at_c2c_ad_uso.value, at_c2c_ad_uso_default.value) AS `c2c_ad_uso`, IF(at_c2c_ambienti_mq.value_id > 0, at_c2c_ambienti_mq.value, at_c2c_ambienti_mq_default.value) AS `c2c_ambienti_mq`, `at_c2c_prezzolistino`.`value` AS `c2c_prezzolistino`, `at_c2c_estetica`.`value` AS `c2c_estetica`, `at_c2c_per_ambienti`.`value` AS `c2c_per_ambienti`, `at_c2c_uso`.`value` AS `c2c_uso`, IF(at_c2c_tipo_filtrazione.value_id > 0, at_c2c_tipo_filtrazione.value, at_c2c_tipo_filtrazione_default.value) AS `c2c_tipo_filtrazione`, IF(at_c2c_erogazione_acqua.value_id > 0, at_c2c_erogazione_acqua.value, at_c2c_erogazione_acqua_default.value) AS `c2c_erogazione_acqua`, `catalogrule_product_price`.`rule_price`, `catalogrule_product_price`.`latest_start_date` AS `rule_start_date`, `catalogrule_product_price`.`rule_date`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '61') AND (`at_special_price`.`store_id` = 0) LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '62') AND `at_special_from_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '62') AND (`at_special_from_date`.`store_id` = 7) LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date_default` ON (`at_special_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date_default`.`attribute_id` = '63') AND `at_special_to_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '63') AND (`at_special_to_date`.`store_id` = 7) 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 LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '56') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '56') AND (`at_name`.`store_id` = 7) LEFT JOIN `catalog_product_entity_text` AS `at_short_description_default` ON (`at_short_description_default`.`entity_id` = `e`.`entity_id`) AND (`at_short_description_default`.`attribute_id` = '58') AND `at_short_description_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_text` AS `at_short_description` ON (`at_short_description`.`entity_id` = `e`.`entity_id`) AND (`at_short_description`.`attribute_id` = '58') AND (`at_short_description`.`store_id` = 7) LEFT JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '60') AND (`at_price`.`store_id` = 0) LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image_default` ON (`at_small_image_default`.`entity_id` = `e`.`entity_id`) AND (`at_small_image_default`.`attribute_id` = '71') AND `at_small_image_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image` ON (`at_small_image`.`entity_id` = `e`.`entity_id`) AND (`at_small_image`.`attribute_id` = '71') AND (`at_small_image`.`store_id` = 7) LEFT JOIN `catalog_product_entity_varchar` AS `at_thumbnail_default` ON (`at_thumbnail_default`.`entity_id` = `e`.`entity_id`) AND (`at_thumbnail_default`.`attribute_id` = '72') AND `at_thumbnail_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_thumbnail` ON (`at_thumbnail`.`entity_id` = `e`.`entity_id`) AND (`at_thumbnail`.`attribute_id` = '72') AND (`at_thumbnail`.`store_id` = 7) LEFT JOIN `catalog_product_entity_datetime` AS `at_news_from_date_default` ON (`at_news_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_news_from_date_default`.`attribute_id` = '77') AND `at_news_from_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_news_from_date` ON (`at_news_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_news_from_date`.`attribute_id` = '77') AND (`at_news_from_date`.`store_id` = 7) LEFT JOIN `catalog_product_entity_datetime` AS `at_news_to_date_default` ON (`at_news_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_news_to_date_default`.`attribute_id` = '78') AND `at_news_to_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_news_to_date` ON (`at_news_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_news_to_date`.`attribute_id` = '78') AND (`at_news_to_date`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '80') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '80') AND (`at_status`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_tax_class_id_default` ON (`at_tax_class_id_default`.`entity_id` = `e`.`entity_id`) AND (`at_tax_class_id_default`.`attribute_id` = '81') AND `at_tax_class_id_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_tax_class_id` ON (`at_tax_class_id`.`entity_id` = `e`.`entity_id`) AND (`at_tax_class_id`.`attribute_id` = '81') AND (`at_tax_class_id`.`store_id` = 7) LEFT JOIN `catalog_product_entity_varchar` AS `at_url_key_default` ON (`at_url_key_default`.`entity_id` = `e`.`entity_id`) AND (`at_url_key_default`.`attribute_id` = '82') AND `at_url_key_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_url_key` ON (`at_url_key`.`entity_id` = `e`.`entity_id`) AND (`at_url_key`.`attribute_id` = '82') AND (`at_url_key`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_price_type` ON (`at_price_type`.`entity_id` = `e`.`entity_id`) AND (`at_price_type`.`attribute_id` = '441') AND (`at_price_type`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_weight_type` ON (`at_weight_type`.`entity_id` = `e`.`entity_id`) AND (`at_weight_type`.`attribute_id` = '443') AND (`at_weight_type`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_price_view` ON (`at_price_view`.`entity_id` = `e`.`entity_id`) AND (`at_price_view`.`attribute_id` = '444') AND (`at_price_view`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_shipment_type` ON (`at_shipment_type`.`entity_id` = `e`.`entity_id`) AND (`at_shipment_type`.`attribute_id` = '445') AND (`at_shipment_type`.`store_id` = 0) LEFT JOIN `catalog_product_entity_varchar` AS `at_image_label_default` ON (`at_image_label_default`.`entity_id` = `e`.`entity_id`) AND (`at_image_label_default`.`attribute_id` = '452') AND `at_image_label_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_image_label` ON (`at_image_label`.`entity_id` = `e`.`entity_id`) AND (`at_image_label`.`attribute_id` = '452') AND (`at_image_label`.`store_id` = 7) LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image_label_default` ON (`at_small_image_label_default`.`entity_id` = `e`.`entity_id`) AND (`at_small_image_label_default`.`attribute_id` = '453') AND `at_small_image_label_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image_label` ON (`at_small_image_label`.`entity_id` = `e`.`entity_id`) AND (`at_small_image_label`.`attribute_id` = '453') AND (`at_small_image_label`.`store_id` = 7) LEFT JOIN `catalog_product_entity_varchar` AS `at_thumbnail_label_default` ON (`at_thumbnail_label_default`.`entity_id` = `e`.`entity_id`) AND (`at_thumbnail_label_default`.`attribute_id` = '454') AND `at_thumbnail_label_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_thumbnail_label` ON (`at_thumbnail_label`.`entity_id` = `e`.`entity_id`) AND (`at_thumbnail_label`.`attribute_id` = '454') AND (`at_thumbnail_label`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_links_purchased_separately` ON (`at_links_purchased_separately`.`entity_id` = `e`.`entity_id`) AND (`at_links_purchased_separately`.`attribute_id` = '471') AND (`at_links_purchased_separately`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_links_exist` ON (`at_links_exist`.`entity_id` = `e`.`entity_id`) AND (`at_links_exist`.`attribute_id` = '531') AND (`at_links_exist`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_is_imported` ON (`at_is_imported`.`entity_id` = `e`.`entity_id`) AND (`at_is_imported`.`attribute_id` = '539') AND (`at_is_imported`.`store_id` = 0) LEFT JOIN `catalog_product_entity_varchar` AS `at_msrp_enabled_default` ON (`at_msrp_enabled_default`.`entity_id` = `e`.`entity_id`) AND (`at_msrp_enabled_default`.`attribute_id` = '541') AND `at_msrp_enabled_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_msrp_enabled` ON (`at_msrp_enabled`.`entity_id` = `e`.`entity_id`) AND (`at_msrp_enabled`.`attribute_id` = '541') AND (`at_msrp_enabled`.`store_id` = 7) LEFT JOIN `catalog_product_entity_varchar` AS `at_msrp_display_actual_price_type_default` ON (`at_msrp_display_actual_price_type_default`.`entity_id` = `e`.`entity_id`) AND (`at_msrp_display_actual_price_type_default`.`attribute_id` = '542') AND `at_msrp_display_actual_price_type_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_msrp_display_actual_price_type` ON (`at_msrp_display_actual_price_type`.`entity_id` = `e`.`entity_id`) AND (`at_msrp_display_actual_price_type`.`attribute_id` = '542') AND (`at_msrp_display_actual_price_type`.`store_id` = 7) LEFT JOIN `catalog_product_entity_decimal` AS `at_msrp` ON (`at_msrp`.`entity_id` = `e`.`entity_id`) AND (`at_msrp`.`attribute_id` = '543') AND (`at_msrp`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_fb_product` ON (`at_fb_product`.`entity_id` = `e`.`entity_id`) AND (`at_fb_product`.`attribute_id` = '566') AND (`at_fb_product`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_vendibile_default` ON (`at_vendibile_default`.`entity_id` = `e`.`entity_id`) AND (`at_vendibile_default`.`attribute_id` = '583') AND `at_vendibile_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_vendibile` ON (`at_vendibile`.`entity_id` = `e`.`entity_id`) AND (`at_vendibile`.`attribute_id` = '583') AND (`at_vendibile`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_testoprezzo_default` ON (`at_testoprezzo_default`.`entity_id` = `e`.`entity_id`) AND (`at_testoprezzo_default`.`attribute_id` = '586') AND `at_testoprezzo_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_testoprezzo` ON (`at_testoprezzo`.`entity_id` = `e`.`entity_id`) AND (`at_testoprezzo`.`attribute_id` = '586') AND (`at_testoprezzo`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_combustibile_default` ON (`at_combustibile_default`.`entity_id` = `e`.`entity_id`) AND (`at_combustibile_default`.`attribute_id` = '588') AND `at_combustibile_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_combustibile` ON (`at_combustibile`.`entity_id` = `e`.`entity_id`) AND (`at_combustibile`.`attribute_id` = '588') AND (`at_combustibile`.`store_id` = 7) LEFT JOIN `catalog_product_entity_decimal` AS `at_prezzolistino` ON (`at_prezzolistino`.`entity_id` = `e`.`entity_id`) AND (`at_prezzolistino`.`attribute_id` = '590') AND (`at_prezzolistino`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_salable` ON (`at_c2c_salable`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_salable`.`attribute_id` = '622') AND (`at_c2c_salable`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_marca` ON (`at_c2c_marca`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_marca`.`attribute_id` = '623') AND (`at_c2c_marca`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_tipologia` ON (`at_c2c_tipologia`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_tipologia`.`attribute_id` = '624') AND (`at_c2c_tipologia`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_design_default` ON (`at_c2c_design_default`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_design_default`.`attribute_id` = '625') AND `at_c2c_design_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_c2c_design` ON (`at_c2c_design`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_design`.`attribute_id` = '625') AND (`at_c2c_design`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_potenza` ON (`at_c2c_potenza`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_potenza`.`attribute_id` = '626') AND (`at_c2c_potenza`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_tecnologia` ON (`at_c2c_tecnologia`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_tecnologia`.`attribute_id` = '627') AND (`at_c2c_tecnologia`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_combustibile` ON (`at_c2c_combustibile`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_combustibile`.`attribute_id` = '628') AND (`at_c2c_combustibile`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_diametro` ON (`at_c2c_diametro`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_diametro`.`attribute_id` = '629') AND (`at_c2c_diametro`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_portata_nom` ON (`at_c2c_portata_nom`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_portata_nom`.`attribute_id` = '630') AND (`at_c2c_portata_nom`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_portata_max` ON (`at_c2c_portata_max`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_portata_max`.`attribute_id` = '631') AND (`at_c2c_portata_max`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_tipologia_valvola` ON (`at_c2c_tipologia_valvola`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_tipologia_valvola`.`attribute_id` = '632') AND (`at_c2c_tipologia_valvola`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_colore` ON (`at_c2c_colore`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_colore`.`attribute_id` = '633') AND (`at_c2c_colore`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_lunghezza` ON (`at_c2c_lunghezza`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_lunghezza`.`attribute_id` = '634') AND (`at_c2c_lunghezza`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_attacchi` ON (`at_c2c_attacchi`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_attacchi`.`attribute_id` = '635') AND (`at_c2c_attacchi`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_classe` ON (`at_c2c_classe`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_classe`.`attribute_id` = '636') AND (`at_c2c_classe`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_pompa_di_calore` ON (`at_c2c_pompa_di_calore`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_pompa_di_calore`.`attribute_id` = '637') AND (`at_c2c_pompa_di_calore`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_ad_uso_default` ON (`at_c2c_ad_uso_default`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_ad_uso_default`.`attribute_id` = '638') AND `at_c2c_ad_uso_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_c2c_ad_uso` ON (`at_c2c_ad_uso`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_ad_uso`.`attribute_id` = '638') AND (`at_c2c_ad_uso`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_ambienti_mq_default` ON (`at_c2c_ambienti_mq_default`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_ambienti_mq_default`.`attribute_id` = '639') AND `at_c2c_ambienti_mq_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_c2c_ambienti_mq` ON (`at_c2c_ambienti_mq`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_ambienti_mq`.`attribute_id` = '639') AND (`at_c2c_ambienti_mq`.`store_id` = 7) LEFT JOIN `catalog_product_entity_decimal` AS `at_c2c_prezzolistino` ON (`at_c2c_prezzolistino`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_prezzolistino`.`attribute_id` = '640') AND (`at_c2c_prezzolistino`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_estetica` ON (`at_c2c_estetica`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_estetica`.`attribute_id` = '641') AND (`at_c2c_estetica`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_per_ambienti` ON (`at_c2c_per_ambienti`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_per_ambienti`.`attribute_id` = '642') AND (`at_c2c_per_ambienti`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_uso` ON (`at_c2c_uso`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_uso`.`attribute_id` = '643') AND (`at_c2c_uso`.`store_id` = 0) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_tipo_filtrazione_default` ON (`at_c2c_tipo_filtrazione_default`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_tipo_filtrazione_default`.`attribute_id` = '644') AND `at_c2c_tipo_filtrazione_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_c2c_tipo_filtrazione` ON (`at_c2c_tipo_filtrazione`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_tipo_filtrazione`.`attribute_id` = '644') AND (`at_c2c_tipo_filtrazione`.`store_id` = 7) LEFT JOIN `catalog_product_entity_int` AS `at_c2c_erogazione_acqua_default` ON (`at_c2c_erogazione_acqua_default`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_erogazione_acqua_default`.`attribute_id` = '645') AND `at_c2c_erogazione_acqua_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_c2c_erogazione_acqua` ON (`at_c2c_erogazione_acqua`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_erogazione_acqua`.`attribute_id` = '645') AND (`at_c2c_erogazione_acqua`.`store_id` = 7) LEFT JOIN `catalogrule_product_price` ON (catalogrule_product_price.product_id=e.entity_id) AND ((catalogrule_product_price.rule_date is null) or (catalogrule_product_price.rule_date='2024-03-28' and catalogrule_product_price.website_id='1' and catalogrule_product_price.customer_group_id='0')) INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='7' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '16' WHERE (at_special_price.value > 0) AND (IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) <= '2024-03-28 00:00:00') AND ((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2024-03-28 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS null)) ORDER BY `cat_index`.`position` ASC LIMIT 16
Trace: #0 /home/admin/web/frizzi.it/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/admin/web/frizzi.it/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/admin/web/frizzi.it/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/admin/web/frizzi.it/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.*, `...', Array) #4 /home/admin/web/frizzi.it/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.*, `...', Array) #5 /home/admin/web/frizzi.it/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.*, `...', Array) #6 /home/admin/web/frizzi.it/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.*, `...', Array) #7 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1046): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.*, `...') #8 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false) #9 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load() #10 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Model/App.php(1358): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer)) #11 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Model/App.php(1331): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), 'catalogBlockPro...', Object(Varien_Event_Observer)) #12 /home/admin/web/frizzi.it/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('catalog_block_p...', Array) #13 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Catalog/Block/Product/List.php(161): Mage::dispatchEvent('catalog_block_p...', Array) #14 /home/admin/web/frizzi.it/public_html/app/code/local/Primi/PromotedProducts/Block/Product/List.php(87): Mage_Catalog_Block_Product_List->_beforeToHtml() #15 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Abstract.php(922): Primi_PromotedProducts_Block_Product_List->_beforeToHtml() #16 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #17 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #18 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #19 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true) #20 /home/admin/web/frizzi.it/public_html/app/design/frontend/base/temapsm/template/page/2columns-left.phtml(64): Mage_Core_Block_Abstract->getChildHtml('content') #21 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/admin/web...') #22 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/t...') #23 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #24 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #25 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #26 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #27 /home/admin/web/frizzi.it/public_html/app/code/local/Primi/PromotedProducts/controllers/DetailController.php(52): Mage_Core_Controller_Varien_Action->renderLayout() #28 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Primi_PromotedProducts_DetailController->indexAction() #29 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index') #30 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #31 /home/admin/web/frizzi.it/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #32 /home/admin/web/frizzi.it/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #33 /home/admin/web/frizzi.it/public_html/index.php(83): Mage::run('', 'store') #34 {main}
Error log record number: 1329931480813