B.box porta alimenti

Filtro

Marca

b.box (43)

Categoria

Accessori da Picnic (10) licenze (5) Lunch Box (43) Novità (21) Porta Alimenti (31) Scuola (4) Svezzamento e Stoviglie (26)

Età del bambino

0 - 6 mesi

6 - 12 mesi

12 - 18 mesi

1 - 3 anni

3 - 6 anni

+ 6 anni

Prezzo

4 €

27 €

4 €

16 €

27 €

DESCUENTO

Cancellare

Applicare

SELECT 
                    P.products_id,
                    IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
                    (
                        SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
                    ) manufacturers_name,
                    PD.products_name,
                    P.products_date_added,
                    P.manufacturers_id,
                    P.products_price_text,
					ifnull(tp.tag_order, 99999) as tag_order,
                    ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
             
                FROM products P
                
                INNER JOIN products_to_categories P2C ON P2C.products_id = P.products_id
                INNER JOIN products_description PD ON P.is_exclusive='0' AND P.products_id IN (90093,90094,90096,90118,90120,91979,91981,91982,91983,91984,91985,91987,92110,92111,92112,92553,92554,92555,92556,92558,96383,96384,105422,105423,105424,105425,105426,105427,105428,105429,105430,105431,105432,105433,105434,105435,105436,105437,105438,105439,107864,107878,107879) 
            AND PD.publicar = 1 AND P.products_status < '2' AND PD.language_id = '4' AND PD.products_id = P.products_id 
            AND P.manufacturers_id NOT IN (
                SELECT manufacturers_id
                FROM manufacturers_excluidos_por_idioma
                WHERE profile_id=0 
                    AND language_id=4
            ) AND ('4'!='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
                 LEFT JOIN tags_products tp ON tp.products_id = P.products_id AND tp.tags_id = (SELECT tags_id FROM tags WHERE tags_friendly_url = 'bbox-porta-alimenti' AND languages_id = '4' LIMIT 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 tag_order ASC  LIMIT 36