Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*)
- FROM
- (
- SELECT `i`.`entity_id`
- FROM `catalog_product_index_price_bundle_idx` AS `i`
- INNER JOIN `catalog_product_bundle_option` AS `bo` ON bo.parent_id = i.entity_id
- INNER JOIN `catalog_product_bundle_selection` AS `bs` ON bs.option_id = bo.option_id
- LEFT JOIN `catalog_product_bundle_selection_price` AS `bsp` ON bs.selection_id = bsp.selection_id AND bsp.website_id = i.website_id
- INNER JOIN `catalog_product_index_price_idx` AS `idx` ON bs.product_id = idx.entity_id AND i.customer_group_id = idx.customer_group_id AND i.website_id = idx.website_id
- INNER JOIN `catalog_product_entity` AS `e` ON bs.product_id = e.entity_id AND e.required_options = 0
- WHERE (i.price_type = 0)
- ) sub;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement