910 38 28 41
0
SELECT * FROM RSQ_CAMPANAS WHERE CAMPANA='outlet_tecnolog��a' AND BANNER_MAILING!='' AND BANNER_MAILING IS NOT NULL AND SOLO_WEB=0SELECT * FROM RSQ_CAMPANAS WHERE CAMPANA='outlet_tecnolog��a' AND (FECHA_INICIO IS NULL OR FECHA_INICIO<=CURDATE()) AND (FECHA_FIN IS NULL OR FECHA_FIN>=CURDATE()) AND SOLO_WEB=0SELECT * FROM RSQ_BUSCADOR_BANNERS WHERE TAG='outlet_tecnolog��a'
SELECT P.* FROM RSQ_PROMOS P, RSQ_ARTICULOS A LEFT JOIN RSQ_PRECIOS_TACHADOS T ON T.ARTICULO=A.ARTICULO AND T.FECHA_VALIDEZ>=CURDATE() WHERE P.ARTICULO=A.ARTICULO AND UPPER(P.PROMO)=UPPER('OUTLET_TECNOLOG��A') AND(T.PRECIO>=P.PRECIO OR T.PRECIO IS NULL)SELECT * FROM RSQ_ARTICULOS_TAGS WHERE UPPER(TAG)=UPPER('OUTLET_TECNOLOG��A') ORDER BY ORDENSELECT ID FROM ELASTIC_TERMINOS WHERE TERMINO='OUTLET_TECNOLOG��A'SELECT TRIM(DATOS_PARTICULARES) as CARACTERISTICA, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND (UPPER(ARTICULO)=UPPER('OUTLET_TECNOLOG��A') AND TRIM(DATOS_PARTICULARES)!='' OR A.ARTICULO IN ('OUTLET_TECNOLOG��A') ) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY DATOS_PARTICULARES ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT GRUPO, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND (UPPER(ARTICULO)=UPPER('OUTLET_TECNOLOG��A') OR A.ARTICULO IN ('OUTLET_TECNOLOG��A') ) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY GRUPO ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT MARCA, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND (UPPER(ARTICULO)=UPPER('OUTLET_TECNOLOG��A') OR A.ARTICULO IN ('OUTLET_TECNOLOG��A') ) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY MARCA ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT A.ARTICULO, A.NOMBRE, A.DATOS_PARTICULARES, A.ENLACE, A.COD_EXTERNO, A.MARCA, A.FAMILIA, A.FOTO, A.DISPONIBILIDAD, A.AGRUPACION, A.OCULTO, IFNULL(CI.CANTIDAD, 1) AS DE_X_EN_X, A.STOCK, A.IVA FROM RSQ_ARTICULOS A LEFT JOIN RSQ_OPC_DE_X_EN_X CI ON A.ARTICULO=CI.ARTICULO WHERE DISPONIBILIDAD != 'No disponible' AND (UPPER(A.ARTICULO)=UPPER('OUTLET_TECNOLOG��A') OR A.ARTICULO IN ('OUTLET_TECNOLOG��A') ) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY A.ARTICULO ORDER BY FIELD(A.ARTICULO, 'OUTLET_TECNOLOG��A'), STOCK DESC, ORDEN LIMIT 30 OFFSET 0SELECT TRIM(DATOS_PARTICULARES) as CARACTERISTICA, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND UPPER(COD_EXTERNO)=UPPER('OUTLET_TECNOLOG��A') AND TRIM(DATOS_PARTICULARES)!='' AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY DATOS_PARTICULARES ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT GRUPO, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND UPPER(COD_EXTERNO)=UPPER('OUTLET_TECNOLOG��A') AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY GRUPO ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT MARCA, COUNT(*) AS 'CUENTA' FROM RSQ_ARTICULOS A WHERE DISPONIBILIDAD != 'No disponible' AND UPPER(COD_EXTERNO)=UPPER('OUTLET_TECNOLOG��A') AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY MARCA ORDER BY CUENTA DESC, NOMBRE LIMIT 5SELECT A.ARTICULO, A.NOMBRE, A.DATOS_PARTICULARES, A.ENLACE, A.COD_EXTERNO, A.MARCA, A.FAMILIA, A.FOTO, A.DISPONIBILIDAD, A.AGRUPACION, A.OCULTO, IFNULL(CI.CANTIDAD, 1) AS DE_X_EN_X FROM RSQ_ARTICULOS A LEFT JOIN RSQ_OPC_DE_X_EN_X CI ON A.ARTICULO=CI.ARTICULO WHERE DISPONIBILIDAD != 'No disponible' AND UPPER(COD_EXTERNO)=UPPER('OUTLET_TECNOLOG��A') AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY A.ARTICULO ORDER BY ORDEN LIMIT 30 OFFSET 0SELECT A.ARTICULO, A.NOMBRE, A.DATOS_PARTICULARES, A.ENLACE, A.COD_EXTERNO, A.MARCA, A.FAMILIA, A.FOTO, A.ORDEN, A.DISPONIBILIDAD, A.AGRUPACION, A.OCULTO, IFNULL(CI.CANTIDAD, 1) AS DE_X_EN_X , CASE when A.NOMBRE_BUSCADOR like 'OUTLET_TECNOLOG��A%' then 200 else 0 END AS EMPIEZA, (IFNULL(TA.PUNTUACION, 0)) + (MATCH(KEYWORDS) AGAINST (QUITAR_ACENTOS('OUTLET_TECNOLOG��A') IN BOOLEAN MODE)*3) + (MATCH(NOMBRE_BUSCADOR) AGAINST (QUITAR_ACENTOS('OUTLET_TECNOLOG��A') IN BOOLEAN MODE)*5) AS RELEVANCIA FROM RSQ_ARTICULOS_BUSCADOR A LEFT JOIN ELASTIC_TERMINOS_ARTICULOS_V TA ON A.ARTICULO=TA.ARTICULO AND UPPER(TA.TERMINO) LIKE UPPER('OUTLET_TECNOLOG��A') LEFT JOIN RSQ_OPC_DE_5_EN_5 CI ON A.ARTICULO=CI.ARTICULO WHERE DISPONIBILIDAD != 'No disponible' AND ((MATCH(KEYWORDS, NOMBRE_BUSCADOR, DATOS_PARTICULARES, GRUPO) AGAINST (QUITAR_ACENTOS('+OUTLET_TECNOLOG��A*') IN BOOLEAN MODE) OR MATCH(KEYWORDS, NOMBRE_BUSCADOR, DATOS_PARTICULARES, GRUPO) AGAINST (QUITAR_ACENTOS('+OUTLET_TECNOLOG��*') IN BOOLEAN MODE))) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY A.ARTICULO ORDER BY EMPIEZA+RELEVANCIA DESC, ORDEN DESC, ARTICULO ASC LIMIT 30 OFFSET 0SELECT A.ARTICULO, A.NOMBRE, A.DATOS_PARTICULARES, A.ENLACE, A.COD_EXTERNO, A.FOTO, A.ORDEN, A.DISPONIBILIDAD, A.AGRUPACION, A.OCULTO, R.RECOMENDACION, IFNULL(CI.CANTIDAD, 0) AS DE_X_EN_X , CASE when A.NOMBRE_BUSCADOR like 'OUTLET_TECNOLOG��A%' then 200 else 0 END AS EMPIEZA, (IFNULL(TA.PUNTUACION, 0)) + (MATCH(KEYWORDS) AGAINST (QUITAR_ACENTOS('OUTLET_TECNOLOG��A') IN BOOLEAN MODE)*3) + (MATCH(NOMBRE_BUSCADOR) AGAINST (QUITAR_ACENTOS('OUTLET_TECNOLOG��A') IN BOOLEAN MODE)*5) AS RELEVANCIA FROM RSQ_ARTICULOS_BUSCADOR A LEFT JOIN ELASTIC_TERMINOS_ARTICULOS_V TA ON A.ARTICULO=TA.ARTICULO AND UPPER(TA.TERMINO) LIKE UPPER('OUTLET_TECNOLOG��A') LEFT JOIN RSQ_OPC_DE_5_EN_5 CI ON A.ARTICULO=CI.ARTICULO, BUSCADOR_RECOMENDACION R WHERE A.ARTICULO=R.ARTICULO AND DISPONIBILIDAD != 'No disponible' AND ((MATCH(KEYWORDS, NOMBRE_BUSCADOR, DATOS_PARTICULARES, GRUPO) AGAINST (QUITAR_ACENTOS('+OUTLET_TECNOLOG��A*') IN BOOLEAN MODE) OR MATCH(KEYWORDS, NOMBRE_BUSCADOR, DATOS_PARTICULARES, GRUPO) AGAINST (QUITAR_ACENTOS('+OUTLET_TECNOLOG��*') IN BOOLEAN MODE))) AND NOT ((A.ID_FAMILIA=41 AND A.ID_SUBFAMILIA=2 AND A.ID_GRUPO=1) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=8) OR (A.ID_FAMILIA =41 AND A.ID_SUBFAMILIA=3 AND A.ID_GRUPO=6)) AND OCULTO='0' AND (NOT EXISTS (SELECT B.ARTICULO FROM RSQ_ARTICULOS_BLACKLIST B WHERE A.ARTICULO=B.ARTICULO) OR EXISTS (SELECT W.ARTICULO FROM RSQ_ARTICULOS_CLIENTES_WHITELIST W WHERE A.ARTICULO=W.ARTICULO AND W.CLIENTE='')) GROUP BY A.ARTICULO ORDER BY EMPIEZA+RELEVANCIA DESC, ORDEN DESC, ARTICULO ASC LIMIT 3

Lo sentimos, no hemos encontrado nada :(