SELECT art.*,fam.*, grup.nombre_grupo, sust.*,
sustituyea AS refSusti, sustituyea_codigo AS codSusti, art.consumible AS articulo_consumible, art.herramienta_personal AS articulo_herramienta_personal, cate.clase_categoria, grup.id_grupo_familias, multi.valor AS valorMultiple, esMultiple, fk_rel_multiple
FROM art_articulos AS art
LEFT JOIN art_familias AS fam ON art.fk_familia = fam.id_familia
LEFT JOIN art_familias_grupos AS grup ON fam.fk_grupo = grup.id_grupo_familias
LEFT JOIN art_grupos_categorias AS cate ON grup.fk_categoria = cate.id_categoria
LEFT JOIN art_sustitutos AS sust ON art.id_articulo = sust.fk_articuloSustituto
LEFT JOIN alm_relprodis AS prodis ON art.id_articulo = prodis.fk_producto AND art.fk_proveedor <> prodis.fk_entidad
LEFT JOIN art_articulos_rel_refmultiples AS multi ON art.id_articulo = multi.fk_articulo_multiple
WHERE 1 = 1 AND (art.visible_web_articulo = 1 || (art.visible_web_articulo = 0 AND art.bOfertaWeb = 1)) AND art.pendiente_revisar <> 1 AND art.bActivo = 1 AND IF( esMultiple = 1, seleccionadoMultiple = 1, 1=1 ) AND bloquea_particulares = 0 GROUP BY id_articulo ORDER BY verMasVendidos DESC, art.nombre asc
