Advertisement
Guest User

Untitled

a guest
Jan 18th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. SELECT COUNT(*)
  2. FROM
  3. (
  4. SELECT `i`.`entity_id`
  5. FROM `catalog_product_index_price_bundle_idx` AS `i`
  6. INNER JOIN `catalog_product_bundle_option` AS `bo` ON bo.parent_id = i.entity_id
  7. INNER JOIN `catalog_product_bundle_selection` AS `bs` ON bs.option_id = bo.option_id
  8. LEFT JOIN `catalog_product_bundle_selection_price` AS `bsp` ON bs.selection_id = bsp.selection_id AND bsp.website_id = i.website_id
  9. 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
  10. INNER JOIN `catalog_product_entity` AS `e` ON bs.product_id = e.entity_id AND e.required_options = 0
  11. WHERE (i.price_type = 0)
  12. ) sub;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement