Inicio » Catalogo » ROPA

   11  12    14      
Mostrar  20  40  60  80  100 
0 -

SELECT distinct p.products_id,pd.altSEOimagen,p.products_antiguo,p.pack_regalos,p.pack_regalos_gold,p.sincronizar,p.producto_oferta_especial,pd.products_description,pd.products_url, p.products_image,c.categories_icono,p.producto_destacado, p.products_tax_class_id,p.products_date_added,p.producto_defectuoso,if((products_antiguo = 0 AND (DATEDIFF(NOW(),products_date_added) < 60)), 1, 0) as products_novedad,p.products_quantity, pd.products_name,p.products_price,s.specials_new_products_price,IF(p.precio_minderest_activo and p.precio_minderest>0,p.precio_minderest,IF(s.status, s.specials_new_products_price, p.products_price)) as precio_final,p.products_seo_descripcion,ifnull(po.orden,100) as orden from products p left join specials s on p.products_id = s.products_id and s.status = 1, products_description pd left join products_orden po on po.producto = pd.products_id and po.idioma = '2' and po.categoria!=0, products_to_categories p2c, categories c where p.products_id = p2c.products_id and ((p.products_quantity > 0 and p.sincronizar = 0) or (p.products_quantity > 0 and p.sincronizar = 1 and p.almacen_cantidad > 0) or (p.categoria LIKE 'PROXIMA TEMPORADA') or (p.forzar_visibilidad = 1)) and p2c.categories_id = c.categories_id and (p2c.categories_id =12 or p2c.categories_id =43 or p2c.categories_id =124 or p2c.categories_id =125 or p2c.categories_id =126 or p2c.categories_id =227 or p2c.categories_id =315 or p2c.categories_id =339 or p2c.categories_id =383 or p2c.categories_id =391 or p2c.categories_id =410 or p2c.categories_id =421 or p2c.categories_id =498 or p2c.categories_id =127 or p2c.categories_id =128 or p2c.categories_id =129 or p2c.categories_id =130 or p2c.categories_id =131 or p2c.categories_id =132 or p2c.categories_id =133 or p2c.categories_id =134 or p2c.categories_id =135 or p2c.categories_id =136 or p2c.categories_id =137 or p2c.categories_id =138 or p2c.categories_id =151 or p2c.categories_id =153 or p2c.categories_id =162 or p2c.categories_id =214 or p2c.categories_id =218 or p2c.categories_id =223 or p2c.categories_id =240 or p2c.categories_id =264 or p2c.categories_id =323 or p2c.categories_id =373 or p2c.categories_id =406 or p2c.categories_id =427 or p2c.categories_id =428 or p2c.categories_id =432 or p2c.categories_id =436 or p2c.categories_id =441 or p2c.categories_id =455 or p2c.categories_id =468 or p2c.categories_id =482 or p2c.categories_id =483 or p2c.categories_id =504 or p2c.categories_id =506 or p2c.categories_id =510 or p2c.categories_id =517 or p2c.categories_id =524 or p2c.categories_id =529 or p2c.categories_id =139 or p2c.categories_id =140 or p2c.categories_id =141 or p2c.categories_id =142 or p2c.categories_id =143 or p2c.categories_id =144 or p2c.categories_id =145 or p2c.categories_id =146 or p2c.categories_id =147 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =150 or p2c.categories_id =152 or p2c.categories_id =184 or p2c.categories_id =194 or p2c.categories_id =219 or p2c.categories_id =244 or p2c.categories_id =265 or p2c.categories_id =289 or p2c.categories_id =304 or p2c.categories_id =322 or p2c.categories_id =372 or p2c.categories_id =405 or p2c.categories_id =429 or p2c.categories_id =431 or p2c.categories_id =440 or p2c.categories_id =454 or p2c.categories_id =467 or p2c.categories_id =470 or p2c.categories_id =481 or p2c.categories_id =484 or p2c.categories_id =505 or p2c.categories_id =508 or p2c.categories_id =509 or p2c.categories_id =516 or p2c.categories_id =523 or p2c.categories_id =528 or p2c.categories_id =530 or p2c.categories_id =423 or p2c.categories_id =424) and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' group by p.products_id order by orden desc, stock desc,precio_final ASC limit 650, 50

[TEP STOP]