Sube a esta web las fotos de los muebles que quieres vender (es gratis)
Acceso Vendedores

TIENDAS DE MUEBLES EN ESPAÑA

Elige provincia
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '01' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '01' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '01' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '02' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '02' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '02' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '03' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '03' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '03' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '04' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '04' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '04' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '33' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '33' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '33' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '05' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '05' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '05' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '06' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '06' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '06' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '07' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '07' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '07' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '08' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '08' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '08' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '09' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '09' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '09' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '10' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '10' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '10' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '11' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '11' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '11' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '39' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '39' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '39' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '12' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '12' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '12' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '51' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '51' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '51' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '13' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '13' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '13' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '14' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '14' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '14' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '15' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '15' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '15' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '16' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '16' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '16' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '17' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '17' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '17' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '18' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '18' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '18' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '19' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '19' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '19' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '20' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '20' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '20' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '21' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '21' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '21' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '22' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '22' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '22' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '23' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '23' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '23' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '56' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '56' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '56' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '35' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '35' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '35' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '24' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '24' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '24' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '25' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '25' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '25' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '27' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '27' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '27' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '28' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '28' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '28' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '29' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '29' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '29' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '52' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '52' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '52' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '30' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '30' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '30' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '31' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '31' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '31' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '32' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '32' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '32' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '34' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '34' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '34' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '36' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '36' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '36' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '26' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '26' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '26' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '37' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '37' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '37' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '38' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '38' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '38' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '40' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '40' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '40' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '41' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '41' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '41' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '42' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '42' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '42' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '43' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '43' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '43' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '44' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '44' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '44' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '45' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '45' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '45' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '46' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '46' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '46' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '47' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '47' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '47' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '48' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '48' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '48' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '49' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '49' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '49' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
(SELECT count(b.idarticulo) as num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a INNER JOIN my_mac_articulos b on a.idvendedor = b.vendedorid WHERE a.tipo = 'P' and b.invisible = '0' and b.vendido = 0 AND a.activo = 'S' and cp2digitos like '50' group by b.vendedorid having num_productos > 0 ) UNION (SELECT a.limite AS num_productos, a.vendedor, a.idvendedornumerico, a.idvendedor, a.localidad, a.provincia, a.direccion, a.telefono FROM my_mac_vendedores a WHERE a.tipo = 'P' AND a.activo = 'S' and cp2digitos like '50' AND a.mail IN (SELECT email FROM tiendas_todas WHERE activo LIKE 'S' AND mac LIKE 'S') AND idvendedornumerico NOT IN (SELECT idvendedornumerico FROM my_mac_vendedores a INNER JOIN my_mac_articulos b ON a.idvendedor = b.vendedorid WHERE a.tipo = 'P' AND b.invisible = '0' AND b.vendido = 0 and cp2digitos like '50' GROUP BY a.idvendedor HAVING num_productos > 0 ) GROUP BY a.idvendedor ) order by localidad asc
Cerrar X
Utilizamos cookies propias y de terceros para mejorar nuestros servicios y mostrarle publicidad relacionada con sus preferencias mediante el análisis de sus hábitos de navegación.
Si continua navegando, consideramos que acepta su uso. Puede cambiar la configuración u obtener más información aquí .