SELECT dcp_idproducto,
dcp_descuento,
dcp_modificadoman,
dcp_preciotarifa,
ccl_nombre
FROM descuentoscclienteproducto,
categoriacliente
WHERE dcp_idcatcliente = ccl_id
AND ccl_id = 25
AND dcp_idproducto IN ( SELECT pdt_id
FROM producto
WHERE pdt_id IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863')
UNION
SELECT DISTINCT tcp_idpdtvinculado
FROM tallasxcolorxprod,
catalogoxsite_publicacion
WHERE tcp_idpdtpadre = cxsp_id
AND cxsp_idsite = '176'
AND cxsp_idioma = '50'
AND cxsp_tipo = 'producto'
AND tcp_idpdtpadre IN ( SELECT tcp_idpdtpadre
FROM tallasxcolorxprod
WHERE tcp_idpdtvinculado IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863') ) )
indice = dcp_idproducto
A1
count_res = 21
A1
A3
SELECT DISTINCT mar_id, mar_nombre
FROM marca,
producto
WHERE mar_id = pdt_idmarca
AND pdt_id IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863')
indice = mar_id
A1
count_res = 6
A1
A3
SELECT DISTINCT ccp_id, ccp_orden, ccp_exclusivo, ccp_multiplicar_unidades
FROM catconfprod,
refconfprod
WHERE ccp_id = rcp_idcategoria
AND ccp_idprod IN ( SELECT pdt_id
FROM producto
WHERE pdt_id IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863')
UNION
SELECT DISTINCT tcp_idpdtvinculado
FROM tallasxcolorxprod,
catalogoxsite_publicacion
WHERE tcp_idpdtpadre = cxsp_id
AND cxsp_idsite = '176'
AND cxsp_idioma = '50'
AND cxsp_tipo = 'producto'
AND tcp_idpdtpadre IN ( SELECT tcp_idpdtpadre
FROM tallasxcolorxprod
WHERE tcp_idpdtvinculado IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863') ) )
AND ccp_idsite = '176'
AND ccp_idioma = '50'
ORDER BY ccp_orden ASC;
indice = ccp_id
A1
count_res = 0
SELECT *
FROM refconfprod,
producto,
iva
WHERE pdt_idiva = iva_id
AND pdt_id = rcp_idref
AND rcp_idcategoria IN (
SELECT DISTINCT ccp_id
FROM catconfprod
WHERE ccp_idprod IN ( SELECT pdt_id
FROM producto
WHERE pdt_id IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863')
UNION
SELECT DISTINCT tcp_idpdtvinculado
FROM tallasxcolorxprod,
catalogoxsite_publicacion
WHERE tcp_idpdtpadre = cxsp_id
AND cxsp_idsite = '176'
AND cxsp_idioma = '50'
AND cxsp_tipo = 'producto'
AND tcp_idpdtpadre IN ( SELECT tcp_idpdtpadre
FROM tallasxcolorxprod
WHERE tcp_idpdtvinculado IN ('81835','83241','126217','119865','69583','81833','125998','126285','128726','81863') ) )
AND ccp_idsite = '176'
AND ccp_idioma = '50'
)
AND rcp_default = 1
indice = rcp_idcategoria
A1
count_res = 0
SELECT tcp_id, pdt_id, pdt_stock
FROM tallasxcolorxprod
INNER JOIN producto ON tcp_idpdtvinculado = pdt_id
WHERE (tcp_idpdtpadre, tcp_cxpid) = ( SELECT tcp_idpdtpadre, tcp_cxpid
FROM tallasxcolorxprod
WHERE tcp_idpdtvinculado = 83241)
AND pdt_stock > 0
indice = pdt_id
A1
count_res = 2
A1
A3
SELECT tcp_id, pdt_id, pdt_stock
FROM tallasxcolorxprod
INNER JOIN producto ON tcp_idpdtvinculado = pdt_id
WHERE (tcp_idpdtpadre, tcp_cxpid) = ( SELECT tcp_idpdtpadre, tcp_cxpid
FROM tallasxcolorxprod
WHERE tcp_idpdtvinculado = 81863)
AND pdt_stock > 0
indice = pdt_id
A1
count_res = 1
A1
A3