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('10026')
and IF(s.status, s.specials_new_products_price, get_bundle_price(p.products_id)) < 25
[TEP STOP]
|
