Shopping Cart ICON_RIGHT
0 items
Categories
Discovery 200 TDI
Discovery 300 TDI
Discovery TD5
Freelander up to 2000
Freelander (2000 onwards)
MG F
MG TF
MG ZR
MG ZS
MG ZT
Rover 100 ('95 to '98)
Rover 200 up to ('95)
Rover 200 ('95 to '99)
Rover 25 (2000 onwards)
Rover 400 up to ('95)
Rover 400 ('95 to '99)
Rover 45 (2000 onwards)
Rover 600 ('93 to '99)
Rover 75 ('99 onwards)
Rover 800 ('92 to '98)
Your Account
Your Email Address
Your Password
Currencies
1054 - Unknown column 'EXPIRE_NEW_PRODUCTS' in 'where clause'

select count(*) as total from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_date_added > SUBDATE( now( ) , INTERVAL EXPIRE_NEW_PRODUCTS DAY ) and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]