SELECT
                (@row_number:=@row_number + 1) AS product_position
                , pa.id as product_id
                , (
                    SELECT DISTINCT
                        ct_art.`text`
                    FROM char_art AS ca_art
                    INNER JOIN `char` AS c_art ON c_art.id =
ca_art.ca_char_id AND c_art.cha_type = 't'
                    LEFT JOIN char_text AS ct_art ON ct_art.id =
ca_art.ca_char_text_id
                    WHERE ca_art.ca_pa_id = pa.id
                    LIMIT 1
                ) AS char_art_num
                , IFNULL (pm.mask_for_id, 'Нет имени') AS
product_title
                , pa.art_num as product_art_num
                , pa.pa_ga_id as product_ga_id
                , ba.NAME_BRANDS AS brand_name
                , bt.country AS brand_country
                , ba.url as brand_url
                , dg.name_ru as product_name
                , pa.price_torg as price
                , pa.avalaible_gen AS available
                , pa.art_num as article
                , pa.pod_zakaz AS pod_zakaz
                , dr.id as razdelId
                , di.id as izdelieId
                , di.grand_parent_id as rubrikaId
                , (
                    SELECT MIN(canonical_prices_all.id)
                    FROM prices_all AS canonical_prices_all
                    WHERE
                      pa.art_num = canonical_prices_all.art_num
                      AND canonical_prices_all.brand_id = pa.brand_id
                ) AS canonical_id
                , (
                    SELECT
                    GROUP_CONCAT(DISTINCT CONCAT(ct1.text, ':',
IFNULL(ct2.text, IFNULL(ca_char_int, ca_char_decimal)), IFNULL(ct3.text,'')
) ORDER BY cd.tile SEPARATOR '/') AS tile
                    FROM char_art ca
                    LEFT JOIN `char` c ON ca.ca_char_id = c.id
                    LEFT JOIN char_dga cd ON c.id = cd.char_id AND cd.dr_id
= :DOK_RAZDEL_ID
                    LEFT JOIN char_text ct1 ON c.cha_name_id = ct1.id
                    LEFT JOIN char_text ct2 ON IFNULL(ca.is_collapse,
ca.ca_char_text_id) = ct2.id
                    LEFT JOIN char_text ct3 ON c.cha_name_unit_id = ct3.id
                    WHERE ca.ca_pa_id = pa.id AND cd.tile IS NOT NULL
                ) AS tile
                , pa_min.rating as rating
                , pa_min.rating_count as rating_count
            FROM (
                    SELECT DISTINCT
                        pa.art_num,
                        (SELECT @row_number:= :OFFSET) AS pos,
                        MAX(pdr.pdr_rounded_rating) as
rating,MAX(pdr.pdr_rating_count) as rating_count,MIN(pa.price_torg) as
price,SUBSTRING_INDEX(GROUP_CONCAT(pa.id ORDER BY pa.price_torg ASC
SEPARATOR ','), ',', 1) as prices_all_id
                    FROM PA_TYP_GA ptg
                    LEFT JOIN prices_all pa ON pa.id = ptg.ptg_pa_id
                    LEFT JOIN char_art ON pa.id = char_art.ca_pa_id
                    LEFT JOIN char_text ON char_art.ca_char_text_id =
char_text.id
                    LEFT JOIN PA_DR_RATING pdr ON pa.id = pdr.pdr_pa_id

                    WHERE
                        pa.avalaible_gen IN (0, 1)
                        AND ptg.ptg_dr_id = :DOK_RAZDEL_ID AND
ptg.ptg_typ_id = :TYP_ID
                         AND pa.price_torg >= 1589.32




                    GROUP BY art_num
                    ORDER BY price ASC
                    LIMIT  :LIMIT
                    OFFSET :OFFSET
            ) pa_min
            LEFT JOIN prices_all pa ON pa.id = pa_min.prices_all_id
            LEFT JOIN dok_ga dg ON pa.pa_ga_id_search = dg.GA_ID
            LEFT JOIN dok_razdel dr ON dg.parent_id = dr.id
            LEFT JOIN dok_izdelie di ON dr.parent_id = di.id
            LEFT JOIN brand_all ba ON pa.brand_id = ba.id
            LEFT JOIN brand_text bt ON ba.id = bt.brand_id
            LEFT JOIN pa_mask pm ON pm.id = pa.id
        . Bound with DOK_RAZDEL_ID=242, LIMIT=12, OFFSET=0, TYP_ID=4154