MySQL Query Error: INSERT INTO b_sale_product2product (PRODUCT_ID, PARENT_PRODUCT_ID, CNT)
select b.PRODUCT_ID as PRODUCT_ID, b1.PRODUCT_ID as PARENT_PRODUCT_ID, COUNT(b1.PRODUCT_ID) as CNT
from b_sale_basket b
left join b_sale_basket b1 on (b.ORDER_ID = b1.ORDER_ID)
inner join b_sale_order o on (o.ID = b.ORDER_ID)
o.ALLOW_DELIVERY = 'Y'
AND b.ID <> b1.ID
GROUP BY b.PRODUCT_ID, b1.PRODUCT_ID[The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay]
DB query error.
Please try later.