|
| Get Them While They're Hot! |
 |
|
 |
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9, 9' at line 1
select p.products_id, pp.price as products_price, pp.s_price as specials_new_products_price, min(pp.date_in) as date_in,min(pp.date_out) as date_out, p.products_model,pd.products_name,d.destinations_name from products p, products_description pd, pp, destinations d where p.products_status = '1' and pp.dispo='0' and p.products_id = pp.id_risorsa and p.locality=d.destinations_id and pd.products_id = p.products_id and pd.language_id = '1' and pp.s_status = '2' and pp.date_in >'2010-09-08' group by p.products_id order by date_in asc limit -9, 9
[TEP STOP]
| |
