Query error: Unknown column 'tmp_p.description' in 'SELECT' - Invalid query: 
            SELECT
                b.*
        
                , (
                    SELECT
                        GROUP_CONCAT(languages.id_language SEPARATOR '{{kk_l}}')
                    FROM
                    (
                        SELECT
                            ll.id_language AS id_language
                            , ll.id_ref AS ll_id_ref
                        FROM
                            emmeti_com_languages AS l
                        LEFT JOIN
                            emmeti_com_products_languages AS ll
                        ON
                            ll.id_language = l.id
                    ) AS languages
                    WHERE
                        languages.ll_id_ref = b.id
                ) AS kk_languages
                , (
                    SELECT
                        ml.id_language
                    FROM
                        emmeti_com_languages AS l
                    LEFT JOIN
                        emmeti_com_products_languages AS ml
                    ON
                        ml.id_language = l.id
                    WHERE
                        l.code = 'en'
                    AND
                        ml.id_ref = b.id
                ) AS lng_exists
            
                , (
                    SELECT
                        GROUP_CONCAT(variants.fields SEPARATOR '{{kk_r}}')
                    FROM
                        (
                            SELECT
                                tmp_p.id
                                , tmp_p.variant_of
                                , tmp_p.description
                                , tmp_p.publication_date
                                , tmp_p.expiration_date
                                , tmp_p.permanent
                                , tmp_p.enabled
                                , GROUP_CONCAT(
                                    CONCAT(
                                        COALESCE(pf.name, '')
                                        , '{{kk_e}}'
                                        , COALESCE(pf.id, '')
                                        , '{{kk_f}}'
                                        , (
                                            COALESCE
                                            (
                                                (
                                                    SELECT
                                                        pt_c.text
                                                    FROM
                                                        `emmeti_com_products_translations` AS pt_c
                                                    WHERE
                                                        pt_c.id_ref = tmp_p.id
                                                    AND
                                                        language = 'en'
                                                    AND
                                                        type = CONCAT('fields[', pfd.id_field, ']')
                                                    AND
                                                        pt_c.context = 'kk_fields'
                                                )
                                                , 
                                                (
                                                    SELECT
                                                        pfd_c.value
                                                    FROM
                                                        emmeti_com_products_fields_data AS pfd_c 
                                                    WHERE
                                                        pfd_c.id = pfd.id
                                                )
                                                ,
                                                ''
                                            )
                                        )
                                        , '{{kk_d}}'
                                        , (
                                            COALESCE
                                            (
                                                (
                                                    SELECT
                                                        pt_d.text
                                                    FROM
                                                        `emmeti_com_products_translations` AS pt_d
                                                    WHERE
                                                        pt_d.id_ref = tmp_p.id
                                                    AND
                                                        language = 'en'
                                                    AND
                                                        type = CONCAT('fields_info[', pfd.id_field, ']')
                                                    AND
                                                        pt_d.context = 'kk_fields'
                                                )
                                                , 
                                                (
                                                    SELECT
                                                        pfd_d.info
                                                    FROM
                                                        emmeti_com_products_fields_data AS pfd_d 
                                                    WHERE
                                                        pfd_d.id = pfd.id
                                                )
                                                ,
                                                ''
                                            )
                                        )
                                        , '{{kk_i}}'
                                        , COALESCE(pg.file_name, '')
                                        , '{{kk_v}}'
                                        , COALESCE(pf.variant, '')
                                        , '{{kk_id}}'
                                        , tmp_p.id
                                    ) SEPARATOR '{{kk_s}}'
                                ) AS fields
                            FROM
                                emmeti_com_products AS tmp_p
                            LEFT JOIN
                                emmeti_com_products_fields_data AS pfd
                            ON
                                pfd.id_product = tmp_p.id
                            LEFT JOIN
                                emmeti_com_products_fields AS pf
                            ON
                                pf.id = pfd.id_field
                            LEFT JOIN
                                emmeti_com_products_gallery AS pg
                            ON
                                pg.id_ref = tmp_p.id
                            AND
                                pg.type = 'photo'
                            AND
                                `pg`.`order` = (
                                    SELECT
                                        `order`
                                    FROM
                                        emmeti_com_products_gallery
                                    WHERE
                                        id_ref = tmp_p.id
                                    AND
                                        type = 'photo'
                                    ORDER BY
                                        `order` ASC
                                    LIMIT 1
                                )
                            GROUP BY
                                tmp_p.id
                        ) AS variants
                    WHERE
                    (
                        variants.id = b.id
                    OR
                        variants.variant_of = b.id
                    )
            
                    AND
                    (
                        variants.publication_date <= '2026-03-30'
                    AND
                        (
                            variants.expiration_date >= '2026-03-30'
                        OR
                            variants.permanent = 1
                        )
                    )
                
                ) AS kk_fields
            
                    , COALESCE (
                        (
                            SELECT
                                field_pt.text
                            FROM
                                `emmeti_com_products_translations` AS field_pt
                            WHERE
                                field_pt.id_ref = b.id
                            AND
                                field_pt.language = 'en'
                            AND
                                field_pt.type = 'url'
                            AND
                                field_pt.context IN ('', 'list')
                        )
                
                        , b.url
                    ) AS url
                
                    , COALESCE (
                        (
                            SELECT
                                t.text
                            FROM
                                `emmeti_com_products_translations` AS t
                            WHERE
                                t.id_ref = `b`.`id`
                            AND
                                t.language = 'en'
                            AND
                                t.type = 'content'
                            AND
                                t.context IN ('', 'list')
                        )
                
                        , `b`.`content`
                    ) AS `content`
                
                    , COALESCE (
                        (
                            SELECT
                                t.text
                            FROM
                                `emmeti_com_products_translations` AS t
                            WHERE
                                t.id_ref = `b`.`id`
                            AND
                                t.language = 'en'
                            AND
                                t.type = 'details'
                            AND
                                t.context IN ('', 'list')
                        )
                
                        , `b`.`details`
                    ) AS `details`
                
                    , COALESCE (
                        (
                            SELECT
                                t.text
                            FROM
                                `emmeti_com_products_translations` AS t
                            WHERE
                                t.id_ref = `b`.`id`
                            AND
                                t.language = 'en'
                            AND
                                t.type = 'note'
                            AND
                                t.context IN ('', 'list')
                        )
                
                        , `b`.`note`
                    ) AS `note`
                
                    , COALESCE (
                        (
                            SELECT
                                t.text
                            FROM
                                `emmeti_com_products_translations` AS t
                            WHERE
                                t.id_ref = `b`.`id`
                            AND
                                t.language = 'en'
                            AND
                                t.type = 'title'
                            AND
                                t.context IN ('', 'list')
                        )
                
                        , `b`.`title`
                    ) AS `title`
                
            FROM
                emmeti_com_products AS b
         WHERE b.id_category = '217' AND 
                (
                    b.publication_date <= '2026-03-30'
                AND
                    (
                        b.expiration_date >= '2026-03-30'
                    OR
                        b.permanent = 1
                    )
                )
			 HAVING url = 'double-pre-insulated-copper-pipe' AND lng_exists IS NOT NULL