|
|
 |
Secciones principales |
 |
|
|
|
1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
select products_id, products_model, products_image, products_tax_class_id, products_price from products where products_status = '1' and products_id in (select pd.products_id from products_description pd join products p on p.products_id=pd.products_id join products_to_categories pc on p.products_id=pc.products_id where pd.language_id = '3' and (('2008-07-06' < pd.fecha_fin and '2008-07-06' >= pd.fecha_inicio and pd.fecha_fin <> '0000-00-00') or (pd.fecha_inicio < '2008-07-06' and pd.fecha_fin >= '2008-07-06' and pd.fecha_fin <> '0000-00-00') or ('2008-07-06' <= pd.fecha_inicio and '2008-07-06' >= pd.fecha_fin and pd.fecha_fin <> '0000-00-00') or ('2008-07-06' = pd.fecha_inicio)) and p.Estado=0 and pc.categories_id =191 order by pd.products_id desc limit 10) order by products_date_added desc limit 10
[TEP STOP]
|
