select configuration_key as cfgKey, configuration_value as cfgValue from configuration
SELECT p2c.categories_id
FROM products p
JOIN products_to_categories p2c ON
p.products_id = p2c.products_id AND p.products_id = '0' AND p.products_status = '1'
JOIN categories c ON p2c.categories_id = c.categories_id AND c.parent_id != 0
ORDER BY IF(p2c.categories_id=0, 9999999, IF(p2c.categories_id IN (83,94,402,334), 1, 0))
LIMIT 1
select categories_name from categories_description where categories_id = '0' and language_id = '0'
select categories_name from categories_description where categories_id = '0' and language_id = '0'
select value from sessions where sesskey = '5j84oas48qceqiragbtitt8ri5' and expiry > '1753170711'
select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
select languages_id, name, code, image, directory from languages where active!='0' order by sort_order
select categories_name, categories_friendly_url from categories_description where categories_id = '334' and language_id = '3'
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='90' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT P.manufacturers_id, M.manufacturers_name,COUNT(P.products_id) C FROM products P
INNER JOIN products_to_categories P2C ON P2C.products_id = P.products_id
LEFT JOIN manufacturers M ON M.manufacturers_id = P.manufacturers_id
INNER JOIN products_description PD ON PD.language_id = '3' AND PD.products_id = P.products_id
WHERE P2C.categories_id = '334' AND P.products_status = 1 AND PD.publicar = 1
GROUP BY P.manufacturers_id
ORDER by M.manufacturers_name ASC
SELECT P.manufacturers_id, M.manufacturers_name,
COUNT(P.products_id) AS cantidad_productos,
ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
FROM products P
INNER JOIN products_to_categories P2C ON P2C.products_id = P.products_id
LEFT JOIN manufacturers M ON M.manufacturers_id = P.manufacturers_id
INNER JOIN products_description PD ON PD.language_id = '3' AND PD.products_id = P.products_id
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
WHERE P2C.categories_id = '334' AND P.products_status = 1 AND PD.publicar = 1
GROUP BY descuento
HAVING descuento IS NOT NULL
ORDER by descuento ASC
SELECT CP.categories_id, COUNT(P2C.products_id) Count, D.categories_name FROM categories C
JOIN products_to_categories P2C ON C.categories_id = P2C.categories_id
JOIN categories CP ON CP.categories_id = C.parent_id
JOIN categories_description D ON CP.categories_id = D.categories_id AND D.language_id = 3
INNER JOIN products_description PD ON PD.language_id = '3' AND PD.products_id = P2C.products_id
WHERE P2C.products_id IN (
SELECT P.products_id FROM products P
JOIN products_to_categories P2C2 ON P2C2.products_id = P.products_id
WHERE P2C2.categories_id = 334 AND P.products_status = 1
GROUP BY P2C.products_id
) AND C.categories_id != 334
AND C.categories_id IN (
SELECT categories_id
FROM categories CV
WHERE CV.parent_id=0 OR CV.parent_id IN (
SELECT categories_id
FROM categories
WHERE parent_id=0
)
) AND C.is_exclusive=0
AND PD.publicar = 1
GROUP BY C.parent_id
ORDER BY D.categories_name ASC
SELECT pc.categories_id, d.categories_name, COUNT(pc.products_id) AS total, cp.parent_id AS idPadre, GROUP_CONCAT(pc.products_id) AS ids
FROM products_to_categories pc
JOIN categories cp ON cp.categories_id = pc.categories_id
JOIN categories_description d ON cp.categories_id = d.categories_id AND d.language_id = '3'
WHERE pc.categories_id != 334 AND pc.products_id IN (
SELECT p.products_id FROM products p
INNER JOIN products_to_categories pc ON p.products_id = pc.products_id
LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = '3'
WHERE p.products_status = 1 AND p.is_exclusive=0 AND pc.categories_id = 334 AND p.products_type!='4' AND p.products_type!='8'
AND p.products_id NOT IN (
SELECT pa1.products_id
FROM products_attributes pa1
WHERE pa1.options_id IN (5) AND pa1.options_values_id IN (1170) AND pa1.active=0
UNION
SELECT cp1.parent_products_id
FROM products_attributes pa1
JOIN combined_products cp1 ON
pa1.products_id=cp1.child_products_id
WHERE pa1.options_id IN (5) AND pa1.options_values_id IN (1170) AND pa1.active=0
) AND pd.publicar = 1 AND (p.products_status='1' OR (p.mostrar_en_web_si_agotado='1' AND p.products_status='0' AND DATE(p.products_date_available)>CURDATE()))
) AND cp.parent_id IN (SELECT categories_id FROM categories WHERE parent_id=0) AND d.categories_name != ''
GROUP BY pc.categories_id;
SELECT P.products_id, (IFNULL(s.specials_new_products_price, P.products_price_text)) precio,
(P.meses_min) MesMin,
(P.meses_max) MesMax,
(P.es_producto_manufacturado) as Personalizado
FROM products P
LEFT JOIN specials s ON P.products_id = s.products_id
INNER JOIN products_to_categories P2C ON P2C.products_id = P.products_id
WHERE P2C.categories_id = '334' AND P2C.categories_id != 0 AND P.products_status = 1
ORDER BY precio ASC
SELECT metas_key, metas_value FROM page_header_seo_metas WHERE language_id='3' ORDER BY metas_id ASC
SELECT cd.categories_name, cd.categories_image_description,cd.categories_description,cd.categories_title,cd.metadescription,cd.metakeywords
FROM categories c
JOIN categories_description cd ON
c.categories_id = cd.categories_id AND cd.language_id='3' AND (c.categories_id='334')
ORDER BY c.parent_id ASC
Black Friday 2024. Ofertas en productos de bebé | Black Friday Tutete
SELECT * FROM languages WHERE active=1 ORDER BY sort_order ASC
SELECT languages_id FROM languages WHERE code='es'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='3'
SELECT languages_id FROM languages WHERE code='it'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='4'
SELECT languages_id FROM languages WHERE code='en'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='9'
SELECT languages_id FROM languages WHERE code='pt'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='10'
SELECT languages_id FROM languages WHERE code='fr'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='15'
SELECT parent_id FROM categories WHERE categories_id='334'
SELECT parent_id FROM categories WHERE categories_id='117'
SELECT parent_id FROM categories WHERE categories_id='90'
SELECT languages_id FROM languages WHERE code='es'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='90' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='117' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='3'
Ordenar
Novedades
Precio de menor a mayor
Precio de mayor a menor
No ordenar
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
/Bañeras Bebé/Black Friday
Envío ordinario gratuito desde 60€ en España (Península).
Envío ordinario gratuito desde 60€ en España (Península).
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups G
join customers_groups_profiles_view_customers_groups_profiles cview on
G.customers_group_id = '0' AND G.customers_group_profile_id = cview.customers_profiles_id
JOIN customers_groups_profiles P ON
cview.customers_profiles_id_visible = P.customers_profiles_id AND P.activo='1'
LEFT JOIN customers_groups_profiles_description PD ON
cview.customers_profiles_id_visible = PD.customers_profiles_id AND PD.language_id = '3'
ORDER BY P.customers_profiles_id DESC
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT parent_id FROM categories WHERE categories_id='334'
SELECT parent_id FROM categories WHERE categories_id='117'
SELECT parent_id FROM categories WHERE categories_id='90'
SELECT languages_id FROM languages WHERE code='es'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='90' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='117' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='3'
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='90' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
Filtros
Ordenar por
Ofertas Especiales de Juguetes para Niños y Bebés en Black Friday
Este Black Friday en Tutete, te ofrecemos descuentos únicos en una gran variedad de productos para bebés. Desde chupetes hasta mochilas y juguetes, encuentra todo lo que necesitas para tu peque a precios especiales. ¡No dejes pasar esta oportunidad para llenar tu carrito!
Leer más
SELECT parent_id FROM categories WHERE categories_id='334'
SELECT parent_id FROM categories WHERE categories_id='117'
SELECT parent_id FROM categories WHERE categories_id='90'
SELECT languages_id FROM languages WHERE code='es'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='90' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='117' AND language_id='3'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='334' AND language_id='3'
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='90' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
Filtros
Ordenar por
Este Black Friday en Tutete, te ofrecemos descuentos únicos en una gran variedad de productos para bebés. Desde chupetes hasta mochilas y juguetes, encuentra todo lo que necesitas para tu peque a precios especiales. ¡No dejes pasar esta oportunidad para llenar tu carrito!
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3' AND (P.customers_profiles_id = '0' OR P.es_publico='1') AND P.activo='1'
ORDER BY (P.customers_profiles_id = '0') DESC, P.customers_profiles_id ASC
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON (c.is_exclusive='0') AND c.parent_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT c.customers_id
FROM customers c
JOIN customers_vip v ON c.customers_id=v.customers_id
WHERE c.customers_id='0' AND v.fecha_baja IS NULL AND c.customers_group_id=0
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT
count(DISTINCT P.products_id) as numero,
MAX(IFNULL(s.specials_new_products_price, P.products_price_text)) AS precio_maximo,
MIN(IFNULL(s.specials_new_products_price, P.products_price_text)) AS precio_minimo
FROM products P
INNER JOIN products_to_categories P2C ON P2C.categories_id = '334' AND P2C.products_id = P.products_id
JOIN manufacturers manu ON P.manufacturers_id = manu.manufacturers_id
JOIN products_description PD ON P.is_exclusive='0' AND PD.language_id = '3' AND PD.publicar = 1 AND (P.products_status='1' OR (P.mostrar_en_web_si_agotado='1' AND P.products_status='0' AND DATE(P.products_date_available)>CURDATE()))
AND P.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
) AND PD.products_id = P.products_id AND ('3'!='15' OR PD.ya_editado='1')
LEFT JOIN filtros_products fp ON
P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
LEFT JOIN specials svip ON
P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
WHERE P.products_type!='4' AND P.products_type!='8' AND P.products_id NOT IN (
SELECT pa1.products_id
FROM products_attributes pa1
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
UNION
SELECT cp1.parent_products_id
FROM products_attributes pa1
JOIN combined_products cp1 ON
pa1.products_id=cp1.child_products_id
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
)
Filtrar
Marca
Categoría
Tipo de producto
Edad
0 - 6 meses
6 - 12 meses
12 - 18 meses
1 - 3 años
3 - 6 años
+ 6 años
Precio
0 €
268 €
0 €
134 €
268 €
0.00 € - 10.00 €
10.00 € - 20.00 €
20.00 € - 30.00 €
30.00 € - 40.00 €
40.00 € - 50.00 €
50.00 € - 60.00 €
60.00 € - 70.00 €
70.00 € - 80.00 €
80.00 € - 90.00 €
90.00 € - 100.00 €
100.00 € - 110.00 €
110.00 € - 120.00 €
120.00 € - 130.00 €
130.00 € - 140.00 €
140.00 € - 150.00 €
150.00 € - 160.00 €
160.00 € - 170.00 €
170.00 € - 180.00 €
200.00 € - 210.00 €
210.00 € - 220.00 €
220.00 € - 230.00 €
240.00 € - 250.00 €
DESCUENTO
Borrar
Aplicar
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='334' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT COUNT(p.products_id) cuenta FROM products p
JOIN products_description pd ON pd.products_id=p.products_id AND pd.language_id=3 AND pd.publicar=1
JOIN products_to_categories p2c ON p2c.products_id=p.products_id AND p2c.categories_id=334
WHERE p.is_exclusive=0 AND (p.products_status=1 OR (p.mostrar_en_web_si_agotado=1 AND p.products_status=0 AND DATE(p.products_date_available)>CURDATE()))
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
);
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT c.customers_id
FROM customers c
JOIN customers_vip v ON c.customers_id=v.customers_id
WHERE c.customers_id='' AND v.fecha_baja IS NULL AND c.customers_group_id=0
SELECT
(
SELECT customizations_code_value
FROM customizations_code
WHERE customizations_code_id = P.customizations_code_id
) as codigo_maquina,
P.products_id,
PD.products_name,
PD.products_description,
PD.ai,
PD.doc_1,
PD.doc_2,
PD.doc_3,
PD.publicar,
P.products_quantity,
P.products_type,
P.products_cost_price,
IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
P.products_price_text,
P.barcode,
P.es_promocion,
P.btn_visible_solo_comerciales,
P.barcodeGenerate,
P.manufacturers_id,
(
SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
) manufacturers_name,
P.products_reorder_level,
P.ref_fabricante,
P.customization,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail,
NULL as products_image_video,
P.products_embed_video,
P.showPreview,
P.is_exclusive,
P.products_production_days,
P.dias_produccion_a_causa_de,
DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available,
P.products_model,
P.products_status,
P.products_date_added,
P.customizations_code_id,
P.products_color_rgb,
P.products_tax_class_id,
s.status as specstat,
s.specials_new_products_price specials_new_products_price,
P.products_tasks,
P.puntos,
P.sumar_personalizacion,
P.ref_catalogo,
ISNULL(fp.products_id) as disponibleFueraUE,
P.es_dropshipping,
P.meses_min,
P.meses_max,
0 discount,
P.es_producto_manufacturado as PERSONALIZADO,
ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
FROM products P
INNER JOIN products_to_categories P2C ON P2C.categories_id = '334' AND P2C.products_id = P.products_id
JOIN manufacturers manu ON P.manufacturers_id = manu.manufacturers_id
JOIN products_description PD ON P.is_exclusive='0' AND PD.language_id = '3' AND PD.publicar = 1 AND (P.products_status='1' OR (P.mostrar_en_web_si_agotado='1' AND P.products_status='0' AND DATE(P.products_date_available)>CURDATE()))
AND P.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
) AND PD.products_id = P.products_id AND ('3'!='15' OR PD.ya_editado='1')
LEFT JOIN filtros_products fp ON
P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
LEFT JOIN specials svip ON
P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
WHERE P.products_type!='4' AND P.products_type!='8' AND P.products_id NOT IN (
SELECT pa1.products_id
FROM products_attributes pa1
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
UNION
SELECT cp1.parent_products_id
FROM products_attributes pa1
JOIN combined_products cp1 ON
pa1.products_id=cp1.child_products_id
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
)
group by P.products_id
ORDER BY P2C.orderPositionInYourCategory ASC LIMIT 36 OFFSET 360
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62665'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62665
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62665
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62667'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62667
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62667
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62679'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62679
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62679
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62683'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62683
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62683
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62684'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62684
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62684
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62686'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62686
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62686
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62703'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62703
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62703
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62705'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62705
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62705
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62706'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62706
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62706
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62707'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62707
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62707
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62708'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62708
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62708
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62709'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62709
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62709
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62712'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62712
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62712
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62713'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62713
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62713
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62714'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62714
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62714
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62715'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62715
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62715
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62716'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62716
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62716
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62717'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62717
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62717
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62718'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62718
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62718
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62719'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62719
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62719
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62720'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62720
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62720
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62721'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62721
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62721
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62723'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62723
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62723
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62724'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62724
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62724
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62744'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62744
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62744
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62746'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62746
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62746
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62789'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62789
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62789
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62790'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62790
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62790
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '62791'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62791
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 62791
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73570'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73570
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73570
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73574'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73574
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73574
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73576'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73576
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73576
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73591'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73591
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73591
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73596'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73596
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73596
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73599'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73599
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73599
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT cd.categories_name, c.categories_id, c.parent_id
FROM products p
JOIN products_to_categories ptc ON
p.products_id=ptc.products_id AND p.products_id = '73601'
JOIN categories c ON
ptc.categories_id = c.categories_id AND c.is_exclusive=p.is_exclusive
JOIN categories_description cd ON
cd.language_id = '3'
AND c.categories_id = cd.categories_id
SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
c.parent_id,
c.sort_order,
c.mostrar_solo_landing,
c.is_exclusive,
c.activa_en_fechas,
DATE(c.fecha_ini_activa) as fecha_ini_activa,
DATE(c.fecha_fin_activa) as fecha_fin_activa,
cd.categories_name,
cd.categories_description,
cd.short_description,
cd.metadescription,
cd.categories_image_description categories_image_description2,
cd.h1,
cd.customcss,
cd.metakeywords,
cd.enmascarada,
cd.categories_friendly_url,
c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header,
mi.profile_id as hideInProfile
FROM categories c
JOIN categories_description cd
ON c.categories_id='117' AND cd.language_id = '3' AND cd.categories_id = c.categories_id
LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
ORDER BY c.parent_id, c.sort_order, cd.categories_name
SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73601
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
SELECT *
FROM products_options_values_specials
WHERE active!=0
SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73601
SELECT *
FROM products_options_values_specials
WHERE active!=0
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority
El Black Friday, también conocido como Viernes Negro, es uno de los eventos comerciales más esperados del año, y en Tutete hemos preparado descuentos exclusivos en una amplia variedad de productos para tu bebé. Este 29 de noviembre de 2024, es tu oportunidad para adquirir lo mejor en chupetes personalizados, biberones, accesorios, ropa infantil, y más a precios únicos. ¿Estás buscando productos seguros, de diseño original y prácticos? ¡No dejes pasar esta oportunidad y llena tu carrito con nuestras ofertas especiales!
El Black Friday tiene su origen en Estados Unidos y marca el inicio de la temporada de compras navideñas. Cada año, muchas personas aprovechan esta fecha para adelantarse a sus compras de Navidad, ahorrando en sus regalos. En Tutete, nos sumamos a esta tradición con ofertas irresistibles en nuestras categorías más destacadas de juguetes para niños, productos de paseo y baño para bebés, ¡entre muchas más!
Productos destacados en oferta
Chupetes personalizados con hasta un 50% de descuento, para utilizarlo de forma más higiénica y evitar que se extravíe
Biberones y accesorios de alimentación infantil con hasta un 40% de descuento, de las mejores marcas del mercado.
Mochilas y bolsas de maternidad con descuentos del 30%, perfectas para la vuelta al cole o salidas familiares.
Vajillas infantiles con diseños originales y divertidos a precios imbatibles.
Juguetes educativos con ofertas irresistibles, ideales para estimular el desarrollo de tu bebé.
¿Por qué comprar en Tutete durante el Black Friday?
Comprar en Tutete durante el Black Friday 2024 te garantiza productos de alta calidad, originalidad y diseño, a precios que no querrás dejar escapar. Si buscas productos que combinen practicidad y estilo, en nuestras categorías encontrarás lo que necesitas. Durante todo este mes, hemos preparado descuentos especiales en nuestras secciones de vuelta al cole, moda infantil y decoración para la habitación del bebé, asegurando que encuentres todo lo necesario para tu pequeño.
Algunas razones para elegir Tutete durante el Black Friday incluyen:
Seguridad y calidad: Todos nuestros productos cumplen con los estándares de seguridad más estrictos, para que puedas comprar con total confianza.
Descuentos reales: Ofrecemos ofertas genuinas en todos nuestros productos, para que disfrutes de precios inigualables.
¿Cuándo es el Black Friday 2024?
El Black Friday 2024 será el viernes 29 de noviembre, pero en Tutete podrás disfrutar de descuentos antes de esa fecha y durante todo el mes de noviembre. ¡No te pierdas nuestras ofertas exclusivas y aprovecha para hacerte con todo lo que necesitas para tu bebé!
Consejos para aprovechar al máximo el Black Friday en Tutete
Para sacarle el máximo partido a las ofertas del Black Friday en Tutete, te recomendamos seguir estos consejos:
Suscríbete a nuestras alertas: No te pierdas las promociones exclusivas que lanzaremos a lo largo del mes. ¡Las mejores ofertas vuelan!
Aprovecha nuestras opciones online: Compra cómodamente desde casa en nuestra Tienda Online y evita las colas.
Un Black Friday extendido
En Tutete, el Black Friday no se limita a un solo día. Durante todo el mes de noviembre, encontrarás ofertas y promociones en categorías como accesorios para bebés, juguetes para niños, y mucho más. Así tendrás más tiempo para elegir lo que mejor se adapte a las necesidades de tu familia.
Historia y origen del Black Friday
El Black Friday nació en Estados Unidos como un día de grandes descuentos justo después de Acción de Gracias. Su nombre proviene del hecho de que los comercios "salían de los números rojos" y pasaban a obtener beneficios, gracias a la gran afluencia de compradores. Esta tradición ha cruzado fronteras, y desde 2012 se ha consolidado en España como uno de los eventos comerciales más importantes del año.
En Tutete, hemos abrazado el Black Friday para ofrecerte las mejores ofertas en decoración infantil, moda para bebés y productos para el regreso a las guarderías y colegios. Adelanta tus compras navideñas y aprovecha nuestras ofertas especiales para que todo lo que necesitas esté listo antes de que comience la temporada festiva.
Ofertas durante todo el fin de semana
¿No llegaste a tiempo para el Black Friday? ¡No te preocupes! En Tutete, nuestras ofertas continuarán durante todo el fin de semana y hasta el Ciber Monday. Así tendrás más oportunidades para disfrutar de nuestros descuentos especiales en artículos esenciales para los más mimados de la casa.
Black Friday online
En Tutete, queremos que disfrutes del Black Friday de la manera más cómoda posible. Puedes hacer tus compras en nuestra Tienda Online sin estrés, evitando las largas filas.
No olvides, ¡las ofertas del Black Friday 2024 estarán disponibles por tiempo limitado! Consigue todo lo que necesitas para tu bebé con grandes descuentos y asegúrate de llevarte los productos más exclusivos de Tutete antes de que se agoten.
TE RECOMENDAMOS
NO Soy Alejandro
select count(*) as total from sessions where sesskey = '5j84oas48qceqiragbtitt8ri5'
insert into sessions values ('5j84oas48qceqiragbtitt8ri5', '1753172152', 'cart|O:12:\"shoppingCart\":13:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;s:9:\"productos\";a:0:{}s:11:\"lastProduct\";s:0:\"\";s:18:\"productDisableList\";N;s:29:\"productCartStockAvailableList\";N;s:28:\"separatorUrlDisabledProducts\";s:1:\"|\";s:19:\"productTypeDisabled\";s:8:\"disabled\";s:24:\"productTypeAvailableDate\";s:14:\"date_available\";s:27:\"productTypeNoStockAvailable\";s:18:\"no_stock_available\";s:33:\"productsNotAvailabledConfirmation\";s:33:\"productsNotAvailabledConfirmation\";}language|s:7:\"espanol\";languages_id|s:1:\"3\";language_code|s:2:\"es\";currency|s:3:\"EUR\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:13:\"productos.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:3:\"334\";s:8:\"language\";s:2:\"es\";s:4:\"page\";s:2:\"11\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}categoriaCargada|i:334;')
Filtros
Español
Italiano
Inglés
Portugués
Francés
