SELECT c.customers_id
                FROM customers c 
                JOIN customers_vip v ON c.customers_id=v.customers_id 
                WHERE c.customers_id='' AND v.fecha_baja IS NULL AND c.customers_group_id=0

SELECT 
                    (
                        SELECT customizations_code_value 
                        FROM customizations_code 
                        WHERE customizations_code_id = P.customizations_code_id
                    ) as codigo_maquina,
                    P.products_id,
                    PD.products_name,
                    PD.products_description,
                    PD.ai,
                    PD.doc_1,
                    PD.doc_2,
                    PD.doc_3,
                    PD.publicar,
                    P.products_quantity, 
                    P.products_type,
                    P.products_cost_price,
                    IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
                    P.products_price_text,
                    P.barcode,
                    P.es_promocion,
                    P.btn_visible_solo_comerciales,
                    P.barcodeGenerate,
                    P.manufacturers_id,
                    (
                        SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
                    ) manufacturers_name,
                    P.products_reorder_level,
                    P.ref_fabricante,
                    P.customization,

                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail,
                    NULL as products_image_video,
                    P.products_embed_video,

                    P.showPreview,
                    P.is_exclusive,
                    P.products_production_days,
                    P.dias_produccion_a_causa_de,
                    DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available,
                    P.products_model,
                    P.products_status,
                    P.products_date_added,
                    P.customizations_code_id,
                    P.products_color_rgb,
                    P.products_tax_class_id, 
                    s.status as specstat,
                    s.specials_new_products_price specials_new_products_price,
                    P.products_tasks,
                    P.puntos,
                    P.sumar_personalizacion,
                    P.ref_catalogo,
                    ISNULL(fp.products_id) as disponibleFueraUE,
                    P.es_dropshipping,
                    P.meses_min,
                    P.meses_max,
                    0 discount,
                    P.es_producto_manufacturado as PERSONALIZADO,
					
                    ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
                
                FROM products P
                
                
                INNER JOIN products_description PD ON P.products_id = '21082' AND PD.language_id = '3' AND PD.products_id = P.products_id
                
                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'
                
                group by P.products_id
                
       

SELECT COUNT(*) as cuantas_no_exclusivas 
                FROM categories c
                JOIN products_to_categories p2c ON
                    p2c.products_id='21082' AND c.is_exclusive='0' AND p2c.categories_id = c.categories_id
                

SELECT 
                PO.products_options_id, 
                PO.products_options_name, 
                PO.products_options_track_stock, 
                PO.products_options_type,
                
                POV.products_options_values_id,
                POV.products_options_values_name,
                POV.showing_order,
                PA.active, 
                PA.price_prefix, 
                PA.options_values_price, 
                PA.options_values_weight,
                PS.products_stock_quantity,
                PS.products_reorder_level,
                PS.barcode,
                PS.barcodeGenerate,
                PS.ref_fabricante 
                FROM products_attributes PA
                JOIN products_options PO ON 
                        PA.products_id='21082' AND
                        PA.active='1' AND  
                        PO.language_id='3' AND
                        PO.products_options_id=PA.options_id
                JOIN products_options_values POV ON 
                        POV.language_id='3' AND
                        POV.products_options_values_id=PA.options_values_id
                LEFT JOIN products_stock PS ON
                        PS.products_stock_attributes=CONCAT(PO.products_options_id, '-', POV.products_options_values_id) AND
                        PS.products_id=PA.products_id
                group by PO.products_options_id, POV.products_options_values_id
                ORDER BY PA.attribute_sort, PO.products_options_id, POV.showing_order DESC, POV.products_options_values_name
        

        SELECT p2c.categories_id 
        FROM products p
        JOIN products_to_categories p2c ON 
            p.products_id = p2c.products_id AND p.products_id = '21082' 
        JOIN categories c ON p2c.categories_id = c.categories_id AND c.parent_id != 0
        ORDER BY IF(p2c.categories_id=0, 9999999, IF(p2c.categories_id IN (83,94,402,334), 1, 0))
        LIMIT 1
    

select parent_id from categories where categories_id = '649'

select parent_id from categories where categories_id = '67'

SELECT languages_id FROM languages WHERE code='es'

SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='67' AND language_id='3' 

SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='649' AND language_id='3' 

SELECT products_name FROM products_description WHERE products_id='21082' AND language_id='3' 

SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
            c.parent_id,
            c.sort_order,
            c.mostrar_solo_landing,
            c.is_exclusive,
            c.activa_en_fechas,
            DATE(c.fecha_ini_activa) as fecha_ini_activa,
            DATE(c.fecha_fin_activa) as fecha_fin_activa,
            cd.categories_name,
            cd.categories_description,
            cd.short_description,
            cd.metadescription,
            cd.categories_image_description categories_image_description2, 
            cd.h1, 
            cd.customcss, 
            cd.metakeywords, 
            cd.enmascarada, 
            cd.categories_friendly_url, 
            c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header, 
            mi.profile_id as hideInProfile
            FROM categories c
            JOIN categories_description cd
               ON c.categories_id='67' AND cd.language_id = '3' AND cd.categories_id = c.categories_id 
            LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
            ORDER BY c.parent_id, c.sort_order, cd.categories_name

SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
            c.parent_id,
            c.sort_order,
            c.mostrar_solo_landing,
            c.is_exclusive,
            c.activa_en_fechas,
            DATE(c.fecha_ini_activa) as fecha_ini_activa,
            DATE(c.fecha_fin_activa) as fecha_fin_activa,
            cd.categories_name,
            cd.categories_description,
            cd.short_description,
            cd.metadescription,
            cd.categories_image_description categories_image_description2, 
            cd.h1, 
            cd.customcss, 
            cd.metakeywords, 
            cd.enmascarada, 
            cd.categories_friendly_url, 
            c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header, 
            mi.profile_id as hideInProfile
            FROM categories c
            JOIN categories_description cd
               ON c.categories_id='649' AND cd.language_id = '3' AND cd.categories_id = c.categories_id 
            LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
            ORDER BY c.parent_id, c.sort_order, cd.categories_name

SELECT ROUND(AVG(rating),1) as media,COUNT(pr.products_id) as numReviews,SUM(rating) AS sumReviews,pd.products_name
                FROm products_reviews pr
                JOIN products_description pd
                ON pd.products_id = pr.products_id AND pr.products_id = '21082' AND pr.status_id = 1 AND pr.language_id = '3' AND pd.language_id = '3' 
                GROUP BY pr.products_id

SELECT
                    m.manufacturers_id,
                    m.manufacturers_name, 
                    m.manufacturers_image,
                    m.date_added,
                    m.last_modified,
                    m.frecuencia_pedidos,
                    m.tiempo_entrega,
                    m.proveedor_id,
                    mi.short_description,
                    mi.metadescription,
                    #mi.manufacturers_image_description manufacturers_image_description2, 
                    mi.h1, 
                    mi.metakeywords, 
                    mi.enmascarada, 
                    mi.manufacturers_friendly_url
                FROM manufacturers m
                JOIN manufacturers_info mi
                   ON mi.manufacturers_id=m.manufacturers_id AND mi.languages_id = '3'  
                WHERE m.manufacturers_id=33 
                GROUP BY m.manufacturers_name
                ORDER BY m.manufacturers_name
        

SELECT * 
                    FROM products_config_lines 
                        WHERE products_id=21082 AND codigo_maquina_exclusivo='' ORDER BY numLine ASC 

SELECT * FROM products p
          JOIN
          products_attributes pa
          ON
          p.products_id = '21082'
          AND pa.products_id = p.products_id
          AND ((pa.options_id=3 OR pa.options_id = 12 OR pa.options_id = 20))

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 
                P.customers_profiles_id as id,                
                PD.customers_profiles_name as name, 
                PD.customers_profiles_text as text, 
                P.customers_profiles_color as color,
                P.customers_profiles_color_claro as colorClaro,
                P.customers_profiles_color_texto as colorTexto,
                P.es_publico,
                P.activo
                FROM customers_groups_profiles P
                JOIN customers_groups_profiles_description PD ON
                    P.customers_profiles_id =  '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '3'
       

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '195') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '164') and tr.tax_class_id = '0' group by tr.tax_priority

SELECT *
                FROM products_options_values_specials
                WHERE active!=0

SELECT child_products_id
                FROM combined_products
                WHERE parent_products_id = 21082

SELECT *
                FROM products_options_values_specials
                WHERE active!=0

SELECT t.tags_name, t.tags_id, t.tags_friendly_url FROM tags t JOIN tags_products tp ON tp.products_id='21082' AND languages_id='3' AND t.tags_id=tp.tags_id ORDER BY t.tags_name ASC

SELECT pdtl.template_description 
                        FROM products_description_templates_to_products pdttp, products_description_templates_languages pdtl
                            WHERE pdttp.template_id = pdtl.template_id
                                AND pdtl.language_id = '3'
                                AND pdttp.products_id = '21082'

        SELECT p2c.categories_id FROM
        (
            SELECT categories_id
            FROM categories
            WHERE (categories_id='96' OR parent_id='96')
        ) as c
        JOIN products_to_categories p2c ON
            c.categories_id=p2c.categories_id AND p2c.products_id='21082'            
        

SELECT * FROM products_attributes where products_id =21082 AND custom_image != ''

SELECT pdtl.template_description 
                        FROM products_description_templates_to_products pdttp, products_description_templates_languages pdtl
                            WHERE pdttp.template_id = pdtl.template_id
                                AND pdtl.language_id = '3'
                                AND pdttp.products_id = '21082'

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 = '3' AND cd.categories_id = c.categories_id 
            LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
            ORDER BY c.parent_id, c.sort_order, cd.categories_name

SELECT c.categories_id, c.categories_image, c.categories_image_2,c.marca_asociada,
            c.parent_id,
            c.sort_order,
            c.mostrar_solo_landing,
            c.is_exclusive,
            c.activa_en_fechas,
            DATE(c.fecha_ini_activa) as fecha_ini_activa,
            DATE(c.fecha_fin_activa) as fecha_fin_activa,
            cd.categories_name,
            cd.categories_description,
            cd.short_description,
            cd.metadescription,
            cd.categories_image_description categories_image_description2, 
            cd.h1, 
            cd.customcss, 
            cd.metakeywords, 
            cd.enmascarada, 
            cd.categories_friendly_url, 
            c.categories_image_mobile, c.categories_image_item, cd.categories_image_description_header, 
            mi.profile_id as hideInProfile
            FROM categories c
            JOIN categories_description cd
               ON c.categories_id='652' AND cd.language_id = '3' AND cd.categories_id = c.categories_id 
            LEFT JOIN manufacturers_excluidos_por_idioma mi ON mi.manufacturers_id = c.id_marca_profesional AND mi.language_id = cd.language_id
            ORDER BY c.parent_id, c.sort_order, cd.categories_name

select 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
                manufacturers_id,
                manufacturers_name, 
                manufacturers_image,
                date_added,
                last_modified,
                frecuencia_pedidos,
                tiempo_entrega,
                proveedor_id
                FROM manufacturers
                WHERE manufacturers_id = '33'
                

                    select 
                    mi.languages_id, 
                    mi.manufacturers_info_image,
                    mi.manufacturers_description,
                    mi.manufacturers_title,
                    mi.short_description,
                    mi.metadescription
                    from manufacturers_info mi
                      where mi.manufacturers_id = 33
                    

SELECT t.tags_name, t.tags_id, t.tags_friendly_url FROM tags t JOIN tags_products tp ON tp.products_id='21082' AND languages_id='3' AND t.tags_id=tp.tags_id ORDER BY t.tags_name ASC

        SELECT p2c.categories_id 
        FROM products p
        JOIN products_to_categories p2c ON 
            p.products_id = p2c.products_id AND p.products_id = '21082' 
        JOIN categories c ON p2c.categories_id = c.categories_id AND c.parent_id != 0
        ORDER BY IF(p2c.categories_id=0, 9999999, IF(p2c.categories_id IN (83,94,402,334), 1, 0))
        LIMIT 1
    

select parent_id from categories where categories_id = '649'

select parent_id from categories where categories_id = '67'

SELECT languages_id FROM languages WHERE code='es'

SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='67' AND language_id='3' 

SELECT categories_name, categories_friendly_url, enmascarada FROM categories_description WHERE categories_id='649' AND language_id='3' 

SELECT products_name FROM products_description WHERE products_id='21082' AND language_id='3' 

Alimentación Infantil > Tazas Personalizadas > Taza de Plástico Personalizada Osito

Taza de Plástico Personalizada Osito

Tutete

14.95€

IVA incluido

14.95€

IVA incluido

Línea 1:

Línea 1 obligatoria

Añadir Cesta

Este producto requiere días extra de producción.

• taza personalizada
• tazas
• tutete
• Colección Osito Tutete
• taza plastico

Taza de plástico personalizado con diseño exclusivo de Tutete.

Son ideales para el desayuno de los peques, para llevar su taza personalizada a la guadería o para hacer un regalo original.

Características

• Taza de plástico BPT (libre de BPA)
  
• Capacidad 300ml
• No apto para microondas
  
• Apto para lavavajillas
• Puedes grabar una línea de 12 caracteres

MÁS INFORMACIÓN

SELECT id_review,products_id,rating,comentario,nombre,ref,date_added,status_id,language_id,titulo,IF(comentario!='',1,0) as tieneComentario
                FROM products_reviews
                WHERE status_id = 1 AND products_id = '21082' AND language_id = '3'  
                ORDER BY tieneComentario DESC,date_added DESC
                LIMIT 5

SELECT id_respuesta,id_review, comentario, nombreRespuesta,isRespuestaTutete,fecha_respuesta
                FROm products_reviews_respuestas
                WHERE id_review = '21229'

SELECT cd.categories_name FROM products_to_categories p2c 
                JOIN categories_description cd ON cd.categories_id=p2c.categories_id AND cd.language_id=3 
                WHERE p2c.products_id=21082 
                LIMIT 1;

SELECT c.customers_id
                FROM customers c 
                JOIN customers_vip v ON c.customers_id=v.customers_id 
                WHERE c.customers_id='' AND v.fecha_baja IS NULL AND c.customers_group_id=0

SELECT 
                    IF(
                        pa.products_id IS NOT NULL AND p.products_type=1,
                        
                        # Si la personalización cuesta dinero: precio de personalización + precio de oferta o normal
                        IF(
							s.products_id IS NOT NULL , 
							s.specials_new_products_price + pa.options_values_price,
                            p.products_price_text + pa.options_values_price
                        ),
                        
                        # Si no hay coste de personalización: precio de oferta o normal del producto
                        IF(
							s.products_id IS NOT NULL , 
							s.specials_new_products_price,
                            p.products_price_text
                        )
                    ) precio,
                    IF(
						s.products_id IS NOT NULL , 
						s.specials_new_products_price,
                        p.products_price_text
                    ) precio_sin_personalizar,
                    IF(s.products_id IS NULL OR s.expires_date='0000-00-00 00:00:00' OR s.expires_date IS NULL, null, DATE(s.expires_date)) caducidad 
                    

                FROM products p 
                
                # Precio de oferta (si la hay)
				LEFT JOIN specials s ON s.products_id=p.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
				# Precio de oferta (si la hay)
				LEFT JOIN specials svip ON svip.products_id=p.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
                
                # Precio de la personalizacion (si lo hay) 
                LEFT JOIN products_attributes pa 
                    ON pa.products_id=p.products_id AND pa.options_id=17 AND pa.price_prefix='+' AND active AND pa.options_values_id!=946 
                
                WHERE p.products_id=21082 
                GROUP BY p.products_id;