SELECT SQL_CALC_FOUND_ROWS 
        BA.ARTICLE_ID -- ,
        -- BA.ARTICLE_NAME,
        -- BA.ACTUAL_PRICE,"" PRICE_RECALC,
        -- BA.AMOUNT_UNIT,
        -- AMOUNT_TYPE_NAME_SHORT amount_type_name_short,
        -- BA.AMOUNT_TYPE_ID,
        -- get_stream_name(STREAM_ID) STREAM_NAME,
        -- BA.STREAM_ID,
        -- BA.COMPOSITE,
        -- BA.IS_FOR_SALE IS_FOR_SALE_MASS,
        -- BA.IS_FOR_LOAD IS_FOR_LOAD_MASS,
        -- BA.DELETE_FLAG DELETE_FLAG 
  FROM b_articles BA 
 INNER JOIN b_amount_types USING (AMOUNT_TYPE_ID) 
 WHERE BA.MENU_ID = 1 
   AND BA.PARENT_ID IS NULL 
   AND BA.ARTICLE_TYPE = 1 
   -- AND BA.DELETE_FLAG = 0 
 ORDER BY ARTICLE_NAME 
 LIMIT 0,100;