daily pastebin goal
60%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top