|
|
| Viamichelin GPS products offer a high quality GPS solution at a very attractive price. With a number of Viamichelin products, including the Viamichelin X-950T and the Viamichelin X-960, we have a number of bargains to choose from. |
|
 |
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 = '4285'
and IF(s.status, s.specials_new_products_price, get_bundle_price(p.products_id)) < 25
[TEP STOP]
| |
