Il mio account Tutete
Tutete
  • EspañolSpagnolo
  • ItalianoItaliano
  • InglésInglese
  • PortuguésPortoghese
  • FrancésFrancese
Cerca
0
Carrello
Il negozio dove desidererai essere un bimbo
Filtri
Ordinare per
lista
lista

Etichette laminate

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 (31100,31269,31270,31271,31272,31273,37766,37767,37768,37774,37775,37797,40712,40713,40714,40715,40716,40717,40720,40721,44914,44915,76708,88055,88056,88057,88058,88060,88062) 
            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 = 'etichette-laminate' 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
Mostra di più
1