|
|
| HTC – Designed for you. You don’t need to get a phone, you need a phone that gets you! Choose from the stunning HD2, Desire, Legend or the Wildfire and choose a phone made for you. |
|
 |
1305 - FUNCTION db134029.get_bundle_price does not exist
select count(distinct p.products_id) cnt
from products p
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 m.manufacturers_id = '4272'
and IF(s.status, s.specials_new_products_price, get_bundle_price(p.products_id)) < 25
[TEP STOP]
| |
