Envío ordinario gratuito desde 60€ en España (Península).
Acceso clientesTutete
Tutete
  • EspañolEspañol
  • ItalianoItaliano
  • InglésInglés
  • PortuguésPortugués
  • FrancésFrancés
Buscar
0
Cesta
Desearás ser un niño
Filtros
Ordenar por
lista
lista

Chupetes con Diseños 

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,
					
                    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 = '102' AND P2C.products_id = P.products_id
                 JOIN manufacturers manu ON P.manufacturers_id = manu.manufacturers_id 
                JOIN products_description PD ON P.is_exclusive='0' AND PD.language_id = '3' AND PD.publicar = 1 AND (P.products_status='1' OR (P.mostrar_en_web_si_agotado='1' AND P.products_status='0' AND DATE(P.products_date_available)>CURDATE()))
                AND P.manufacturers_id NOT IN (
                    SELECT manufacturers_id
                    FROM manufacturers_excluidos_por_idioma
                    WHERE profile_id=0 
                        AND language_id=3
                ) AND PD.products_id = P.products_id AND ('3'!='15' OR PD.ya_editado='1')
                
                LEFT JOIN filtros_products fp ON
                    P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
                LEFT JOIN specials s ON 
                    P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
                LEFT JOIN specials svip ON 
                    P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
                
        
                WHERE P.products_type!='4' AND P.products_type!='8' AND P.products_id NOT IN (
            SELECT pa1.products_id
            FROM  products_attributes pa1
            WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
            UNION
            SELECT cp1.parent_products_id
            FROM  products_attributes pa1
            JOIN combined_products cp1 ON
            pa1.products_id=cp1.child_products_id
            WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
            )
                
                group by P.products_id
                ORDER BY IFNULL(P2C.orderPositionInYourCategory, 9999) ASC, P.products_id ASC LIMIT 36
Mostrar más
123
...
8