veresto:62 sub:62 otro:SELECT categories.categories_id, cd.categories_name, categories.parent_id FROM lista_precios_productos, products_quantity_name pn, products p,categories, products_description pd,categories_description cd, products_to_categories pc LEFT OUTER JOIN products_home USING(products_id) WHERE p.products_status = '1' and pc.products_id=p.products_id and pd.products_id = p.products_id and lista_precios_productos.products_id = p.products_id AND categories.categories_id=cd.categories_id AND pn.products_quantity = p.products_quantity AND categories.categories_id=pc.categories_id and (lista_precios_productos.pesos > 5 or lista_precios_productos.precio_sin_iva > 5 or p.pvp > 5) and p.visible <> 0 AND lista_precios_productos.id_lista = 6 AND pc.categories_id IN(620753,620754,620781,620999,620755,620757,620758,620821,620756,620883,620822,620838,620897,621009,620833,620879,621098,620837,621024,620857) group by categories.categories_id, cd.categories_name, categories.parent_id
  Nombre PVP Precio Web Precio Stock Cantidad Carrito