SELECT
    ca.id,
    pa.id,
--  (SELECT ct.text FROM char_art ca_s inner JOIN `char` c on ca_s.ca_char_id = c.id and c.cha_type = 't' LEFT JOIN char_text ct on ca_s.ca_char_text_id = ct.id where ca_s.ca_pa_id = ca.ca_pa_id group by ct.text) as art_param,
    ba.NAME_BRANDS,
  dg.dga_id,
    pm.mask_for_id,
    pm.artnum_created,
    cd.char_id,
    ct1.text,
--  (SELECT text from yii_doc.char_text where yii_doc.char_text.id = c.cha_name_id) as param_name,
--      (SELECT text from yii_doc.char_text where yii_doc.char_text.id = ca.ca_char_text_id) as text_param,
--  IFNULL((SELECT text FROM char_text where id=ca.ca_char_text_id), IFNULL(ca.ca_char_int, ca.ca_char_decimal)) as val,
    ct.text,
    ca.ca_char_int,
  ca.ca_char_decimal

FROM prices_all pa

-- LEFT JOIN (SELECT dg.GA_ID, dg.dga_id FROM dok_ga dg GROUP BY dg.GA_ID) dg on dg.GA_ID = pa.pa_ga_id_search
LEFT JOIN dok_ga dg on dg.GA_ID = pa.pa_ga_id_search

LEFT JOIN char_dga cd on cd.dga_id = dg.dga_id

LEFT JOIN `char` c on c.id = cd.char_id
left JOIN char_text ct1 on ct1.id = c.cha_name_id
LEFT JOIN yii_doc.char_art ca on ca.ca_char_id = c.id

LEFT JOIN char_text ct on ca.ca_char_text_id = ct.id

LEFT JOIN yii_doc.brand_all ba on pa.brand_id = ba.id
LEFT JOIN yii_doc.pa_mask         pm on pm.id       = pa.id

where dg.dga_id = @dga

order by pa.id
LIMIT 2000
-- ORDER BY  ca.ca_char_id, ca.ca_pa_id