Espanhol
Italiano
Inglês
Português
Francês
Bolsa Térmica Omietote Pink
31.90€
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='126' AND cd.language_id = '10' 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='126' AND cd.language_id = '10' 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_nameSELECT 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='88' AND cd.language_id = '10' 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='126'
SELECT parent_id FROM categories WHERE categories_id='88'
SELECT languages_id FROM languages WHERE code='pt'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='88' AND language_id='10'
SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='126' AND language_id='10'
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='88' AND cd.language_id = '10' 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_nameSELECT 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='126' AND cd.language_id = '10' 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
FiltrosOrganizar por
Bolsas de Merenda
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 = '10' 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='126' AND cd.language_id = '10' 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_nameSELECT 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=0SELECT 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='126' AND cd.language_id = '10' 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_nameSELECT *
FROM products_options_values_specials
WHERE active!=0SELECT
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 = '126' 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 = '10' 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=10
) AND PD.products_id = P.products_id AND ('10'!='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
)
Filtro
Marca
Categoria
Idade do bebé
0 - 6 meses
6 - 12 meses
12 - 18 meses
1 - 3 anos
3 - 6 anos
+ 6 anos
Preço
4 €
39 €
4 €
22 €
39 €
0.00 € - 10.00 €
10.00 € - 20.00 €
20.00 € - 30.00 €
30.00 € - 40.00 €
40.00 € - 50.00 €
50.00 € - 60.00 €
DESCUENTO
Apagar
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='126' AND cd.language_id = '10' 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_nameSELECT COUNT(p.products_id) cuenta FROM products p
JOIN products_description pd ON pd.products_id=p.products_id AND pd.language_id=10 AND pd.publicar=1
JOIN products_to_categories p2c ON p2c.products_id=p.products_id AND p2c.categories_id=126
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=10
);SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT 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=0SELECT
(
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 = '126' 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 = '10' 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=10
) AND PD.products_id = P.products_id AND ('10'!='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 108
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 = '83448'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83448SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83448SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '83449'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83449SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83449SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '83450'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83450SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83450SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '92339'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 92339SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 92339SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97815'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97815SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97815SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97817'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97817SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97817SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97818'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97818SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97818SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '83940'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83940SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 83940SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '87880'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 87880SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 87880SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '87881'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 87881SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 87881SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '80474'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 80474SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 80474SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86275'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86275SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86275SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86276'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86276SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86276SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86277'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86277SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86277SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86278'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86278SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86278SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86279'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86279SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86279SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86280'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86280SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86280SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86281'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86281SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86281SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '86282'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86282SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 86282SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97831'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97831SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97831SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97833'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97833SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97833SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97838'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97838SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97838SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97839'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97839SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97839SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97840'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97840SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97840SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97842'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97842SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97842SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97848'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97848SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97848SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '97850'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97850SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 97850SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '75235'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 75235SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 75235SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '75236'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 75236SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 75236SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60384'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60384SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60384SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60366'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60366SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60366SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '73186'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73186SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 73186SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60121'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60121SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60121SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60123'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60123SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60123SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60122'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60122SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60122SELECT *
FROM products_options_values_specials
WHERE active!=0select 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 = '60120'
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 = '10'
AND c.categories_id = cd.categories_idSELECT 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='88' AND cd.language_id = '10' 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_nameSELECT
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 = '10'
SELECT *
FROM products_options_values_specials
WHERE active!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60120SELECT *
FROM products_options_values_specials
WHERE active!=0select 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!=0SELECT child_products_id
FROM combined_products
WHERE parent_products_id = 60120SELECT *
FROM products_options_values_specials
WHERE active!=0select 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
Seus últimos produtos visualizados
88_back-to-school/126_bolsas-de-merenda