SESSION:

Array
(
    [app_version_id] => SoftBase 7.1170
    [session_debug] => 
    [sid] => a2ku12aunat27rf118pl6bqn3n
    [captcha] => BXUB
    [autentificat] => 
    [level] => 
    [id_admin] => 
    [ip] => 216.73.216.230
    [idioma] => fr
    [default_idioma] => it
    [public_idioma] => fr
    [auth_private] => 
    [ses_id_client] => 
    [id_tipus_iva] => Array
        (
            [22] => Array
                (
                    [iva] => 22.00
                    [recarrec] => 1.00
                    [descripcio] => Iva al 22%
                )

            [21] => Array
                (
                    [iva] => 21.00
                    [recarrec] => 5.20
                    [descripcio] => Iva al 21%
                )

        )

    [tarifa_web] => Array
        (
            [id] => PVI
            [id_parent] => 0
            [id_divisa] => 1
            [currency] => EUR
        )

    [id_pais] => 11
)

Query 1: SELECT art_subarticles.*,d_items_idioma.titol AS titol_idioma,d_items.*,d_items_idioma.* ,caract_1 as marca, caract_2 as modelo,caract_3 as acabat, art_subarticles.id_article as tipus, IF(art_subarticle_tarifa.preu_oferta > 0,art_subarticle_tarifa.preu_oferta,art_subarticles.preu_oferta) as preu_oferta, art_subarticle_tarifa.pvp, IF(art_subarticle_tarifa.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticle_tarifa.preu_oferta, art_subarticle_tarifa.pvp), /* ELSE */ IF(art_subarticles.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticles.preu_oferta, art_subarticle_tarifa.pvp), art_subarticle_tarifa.pvp)) AS preu_final, IF(art_subarticle_tarifa.preu_oferta > 0,art_subarticle_tarifa.preu_oferta,art_subarticles.preu_oferta) as preu_oferta, art_subarticle_tarifa.pvp, IF(art_subarticle_tarifa.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticle_tarifa.preu_oferta, art_subarticle_tarifa.pvp), /* ELSE */ IF(art_subarticles.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticles.preu_oferta, art_subarticle_tarifa.pvp), art_subarticle_tarifa.pvp)) AS preu_final FROM art_subarticles LEFT JOIN d_items_idioma ON art_subarticles.id_item = d_items_idioma.id LEFT JOIN d_items ON d_items.id=art_subarticles.id_item LEFT JOIN art_articles ON art_articles.id = art_subarticles.id_article LEFT JOIN art_families ON art_families.id = art_subarticles.id_familia LEFT JOIN art_area ON art_area.id = art_subarticles.id_area LEFT JOIN art_subarticle_tarifa ON art_subarticle_tarifa.id_subarticle=art_subarticles.id LEFT JOIN d_items_idioma_tema ON d_items_idioma_tema.id=d_items.id AND d_items_idioma_tema.id_idioma='fr' AND d_items_idioma_tema.id_tema = '1' WHERE art_subarticles.arxivat<>'Y' AND art_subarticles.web='Y' AND d_items_idioma.id_idioma='fr' AND d_items.data_publicacio < '1750437976' AND (d_items.data_caducitat > '1750437976' OR d_items.data_caducitat <= 0) AND art_subarticle_tarifa.id_tarifa='PVI' AND art_subarticle_tarifa.hores='0' AND art_subarticles.id IN( SELECT id_tabla FROM art_caracteristiques_relacions WHERE 1<= ( SELECT count( distinct art_caracteristiques_relacions.id_carac) as total FROM art_caracteristiques_relacions WHERE ( (id_carac='5' AND id_valor='7778' ) AND art_caracteristiques_relacions.tabla='art_subarticles' ) AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles') AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles' ) AND (IF(art_subarticle_tarifa.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticle_tarifa.preu_oferta, art_subarticle_tarifa.pvp), /* ELSE */ IF(art_subarticles.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticles.preu_oferta, art_subarticle_tarifa.pvp), art_subarticle_tarifa.pvp))) >= 0.1 AND art_subarticles.id IN( SELECT id_tabla FROM art_caracteristiques_relacions WHERE 1<= ( SELECT count( distinct art_caracteristiques_relacions.id_carac) as total FROM art_caracteristiques_relacions WHERE ( (id_carac='5' AND id_valor='7778' ) AND art_caracteristiques_relacions.tabla='art_subarticles' ) AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles') AND art_caracteristiques_relacions.id_tabla=art_subarticles.id AND art_caracteristiques_relacions.tabla='art_subarticles' ) AND (IF(art_subarticle_tarifa.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticle_tarifa.preu_oferta, art_subarticle_tarifa.pvp), /* ELSE */ IF(art_subarticles.preu_oferta > 0, IF(art_subarticles.preu_oferta < art_subarticle_tarifa.pvp, art_subarticles.preu_oferta, art_subarticle_tarifa.pvp), art_subarticle_tarifa.pvp))) >= 0.1 AND (d_items_idioma_tema.actiu<>'N' OR d_items_idioma_tema.actiu IS NULL) ORDER BY marca,modelo,tipus,acabat,art_subarticles.model LIMIT 0,99999999