1305 - FUNCTION db134029.get_bundle_price does not exist
select count(distinct p.products_id) cnt
from products p
inner join products_to_categories p2c on p.products_id = p2c.products_id
STRAIGHT_JOIN products_to_affiliates p2a on p.products_id = p2a.products_id
and p2a.affiliate_id = '3'
left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1'
and pd1.affiliate_id = '3'
inner join products_description pd on pd.products_id = p.products_id and pd.affiliate_id = 0
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join specials s on p.products_id = s.products_id
left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '1'
and pp.currencies_id = '0'
where p.products_status = 1
and pd.affiliate_id = 0
and pd.language_id = '1'
and ( pp.products_group_price is null or pp.products_group_price != -1 )
and p2c.categories_id in('10001', '10002', '10003', '10005', '10006', '10007', '10008', '10009', '10013', '10035', '10046', '10069', '10070', '10072', '1', '4', '5', '7', '8', '10', '11', '13', '14', '15', '16', '17', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '36', '37', '39', '40', '41', '42', '44', '46', '47', '48', '49', '50', '51', '52', '53', '55', '61', '63', '64', '65', '10004', '10017', '10019', '10026', '10027', '10029', '10030', '10033', '10034', '10036', '10038', '10039', '10040', '10043', '10044', '10047', '10063', '10065', '10068', '10071', '10073', '10074', '10075', '32', '0')
and IF(s.status, s.specials_new_products_price, get_bundle_price(p.products_id)) < 25
[TEP STOP]
|
