{"action":"closed","issue":{"url":"https://api.github.com/repos/magento/magento2/issues/6860","repository_url":"https://api.github.com/repos/magento/magento2","labels_url":"https://api.github.com/repos/magento/magento2/issues/6860/labels{/name}","comments_url":"https://api.github.com/repos/magento/magento2/issues/6860/comments","events_url":"https://api.github.com/repos/magento/magento2/issues/6860/events","html_url":"https://github.com/magento/magento2/issues/6860","id":180700017,"number":6860,"title":"After upgrade to magento 2.1.1 and created another store it will display a reindexing error in Product Price index ","user":{"login":"mazestricks","id":14094984,"avatar_url":"https://avatars.githubusercontent.com/u/14094984?v=3","gravatar_id":"","url":"https://api.github.com/users/mazestricks","html_url":"https://github.com/mazestricks","followers_url":"https://api.github.com/users/mazestricks/followers","following_url":"https://api.github.com/users/mazestricks/following{/other_user}","gists_url":"https://api.github.com/users/mazestricks/gists{/gist_id}","starred_url":"https://api.github.com/users/mazestricks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mazestricks/subscriptions","organizations_url":"https://api.github.com/users/mazestricks/orgs","repos_url":"https://api.github.com/users/mazestricks/repos","events_url":"https://api.github.com/users/mazestricks/events{/privacy}","received_events_url":"https://api.github.com/users/mazestricks/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/magento/magento2/labels/needs%20update","name":"needs update","color":"b60205"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-03T17:37:14Z","updated_at":"2016-10-25T12:53:04Z","closed_at":"2016-10-25T12:53:04Z","body":"<!--- Provide a general summary of the issue in the Title above -->\r\n<!--- Before adding new issues, please, check this article https://github.com/magento/magento2/wiki/Issue-reporting-guidelines-->\r\n\r\n### Preconditions\r\n<!--- Provide a more detailed information of environment you use -->\r\n<!--- Magento version, tag, HEAD, etc., PHP & MySQL version, etc.. -->\r\n1.  Enter your credentials in ssh.\r\n2.  Login to the site using ssh.\r\n\r\n### Steps to reproduce\r\n<!--- Provide a set of unambiguous steps to reproduce this bug include code, if relevant  -->\r\n1. Run this command after opening ssh\r\n2. php bin/magento indexer:reindex\r\n3. \r\n\r\n### Expected result\r\n<!--- Tell us what should happen -->\r\n1.  It should display the success message of reindexing every indexes required.\r\n\r\n### Actual result\r\n<!--- Tell us what happens instead -->\r\n1. [Screenshot, logs]\r\nphp bin/magento indexer:reindex\r\nDesign Config Grid index has been rebuilt successfully in 00:00:06\r\nCustomer Grid index has been rebuilt successfully in 00:00:19\r\nProduct Flat Data index has been rebuilt successfully in 00:00:28\r\nCategory Products index has been rebuilt successfully in 00:00:33\r\nProduct Categories index has been rebuilt successfully in 00:00:00\r\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tad_price_type.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity` AS `tas_' at line 13, query was: INSERT INTO `mg2_catalog_product_index_price_bundle_idx` SELECT `e`.`entity_id`, `cg`.`customer_group_id`, `cw`.`website_id`, IF(IF(IFNULL(tas_tax_class_id.value_id, -1) > 0, tas_tax_class_id.value, tad_tax_class_id.value) IS NOT NULL, IF(IFNULL(tas_tax_class_id.value_id, -1) > 0, tas_tax_class_id.value, tad_tax_class_id.value), 0) AS `tax_class_id`, 1 AS `price_type`, IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) AS `special_price`, tp.min_price AS `tier_percent`, IF(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) IS NULL, 0, IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value)) AS `orig_price`, IF(IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL) < IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value)), IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL), IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value))) AS `price`, IF(IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL) < IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value)), IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL), IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value))) AS `min_price`, IF(IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL) < IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value)), IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL), IF(IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0) > 0, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (IF(IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) <= cwd.website_date, 1, 0)) > 0 AND IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL, 1, IF(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) >= cwd.website_date, 1, 0)) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) > 0 AND IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value) < 100 , IF(IFNULL(tas_special_price.value_id, -1) > 0, tas_special_price.value, tad_special_price.value), 0)  / 100), 4), IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value))) AS `max_price`, IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL) AS `tier_price`, IF(tp.min_price IS NOT NULL, ROUND(IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) - (IF(IFNULL(tas_price.value_id, -1) > 0, tas_price.value, tad_price.value) * (tp.min_price / 100)), 4), NULL) AS `base_tier` FROM `mg2_catalog_product_entity` AS `e`\r\n CROSS JOIN `mg2_customer_group` AS `cg`\r\n CROSS JOIN `mg2_store_website` AS `cw`\r\n INNER JOIN `mg2_store_group` AS `csg` ON csg.group_id = cw.default_group_id\r\n INNER JOIN `mg2_store` AS `cs` ON cs.store_id = csg.default_store_id\r\n INNER JOIN `mg2_catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id\r\n INNER JOIN `mg2_catalog_product_index_website` AS `cwd` ON cw.website_id = cwd.website_id\r\n LEFT JOIN `mg2_catalog_product_index_tier_price` AS `tp` ON tp.entity_id = e.entity_id AND tp.website_id = cw.website_id AND tp.customer_group_id = cg.customer_group_id\r\n INNER JOIN `mg2_catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 94 AND tad_status.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 94 AND tas_status.store_id = cs.store_id\r\n LEFT JOIN `mg2_catalog_product_entity_int` AS `tad_tax_class_id` ON tad_tax_class_id.entity_id = e.entity_id AND tad_tax_class_id.attribute_id = 129 AND tad_tax_class_id.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_int` AS `tas_tax_class_id` ON tas_tax_class_id.entity_id = e.entity_id AND tas_tax_class_id.attribute_id = 129 AND tas_tax_class_id.store_id = cs.store_id\r\n INNER JOIN `mg2_catalog_product_entity` AS `tad_price_type` ON tad_price_type.entity_id = e.entity_id AND tad_price_type.attribute_id =  AND tad_price_type.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity` AS `tas_price_type` ON tas_price_type.entity_id = e.entity_id AND tas_price_type.attribute_id =  AND tas_price_type.store_id = cs.store_id\r\n LEFT JOIN `mg2_catalog_product_entity_decimal` AS `tad_price` ON tad_price.entity_id = e.entity_id AND tad_price.attribute_id = 74 AND tad_price.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_decimal` AS `tas_price` ON tas_price.entity_id = e.entity_id AND tas_price.attribute_id = 74 AND tas_price.store_id = cs.store_id\r\n LEFT JOIN `mg2_catalog_product_entity_decimal` AS `tad_special_price` ON tad_special_price.entity_id = e.entity_id AND tad_special_price.attribute_id = 75 AND tad_special_price.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_decimal` AS `tas_special_price` ON tas_special_price.entity_id = e.entity_id AND tas_special_price.attribute_id = 75 AND tas_special_price.store_id = cs.store_id\r\n LEFT JOIN `mg2_catalog_product_entity_datetime` AS `tad_special_from_date` ON tad_special_from_date.entity_id = e.entity_id AND tad_special_from_date.attribute_id = 76 AND tad_special_from_date.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_datetime` AS `tas_special_from_date` ON tas_special_from_date.entity_id = e.entity_id AND tas_special_from_date.attribute_id = 76 AND tas_special_from_date.store_id = cs.store_id\r\n LEFT JOIN `mg2_catalog_product_entity_datetime` AS `tad_special_to_date` ON tad_special_to_date.entity_id = e.entity_id AND tad_special_to_date.attribute_id = 77 AND tad_special_to_date.store_id = 0\r\n LEFT JOIN `mg2_catalog_product_entity_datetime` AS `tas_special_to_date` ON tas_special_to_date.entity_id = e.entity_id AND tas_special_to_date.attribute_id = 77 AND tas_special_to_date.store_id = cs.store_id WHERE (e.type_id='bundle') AND (IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1) AND (IF(IFNULL(tas_price_type.value_id, -1) > 0, tas_price_type.value, tad_price_type.value)=1) ON DUPLICATE KEY UPDATE `tax_class_id` = VALUES(`tax_class_id`), `price_type` = VALUES(`price_type`), `special_price` = VALUES(`special_price`), `tier_percent` = VALUES(`tier_percent`), `orig_price` = VALUES(`orig_price`), `price` = VALUES(`price`), `min_price` = VALUES(`min_price`), `max_price` = VALUES(`max_price`), `tier_price` = VALUES(`tier_price`), `base_tier` = VALUES(`base_tier`)\r\nProduct EAV index has been rebuilt successfully in 00:00:30\r\nStock index has been rebuilt successfully in 00:00:02\r\nCatalog Rule Product index has been rebuilt successfully in 00:00:00\r\nCatalog Product Rule index has been rebuilt successfully in 00:00:00\r\nCatalog Search index has been rebuilt successfully in 00:03:26\r\n<!--- (This may be platform independent comment) -->\r\n"}}
{"actor":{"display_login":"veloraven"}}