SELECT inv.price_for_one AS costPriceGoods
        FROM invoice inv,
             posinfo pi,
             goods g,
             stock_item si,
             warehouses w
        WHERE g.id = 10122
          AND si.goods_id = g.id
          AND pi.client_legal_informations_id = 12
          AND w.pos_info_id = pi.id
          AND si.warehouses_id = w.id
          AND inv.stock_item_id = si.id
          AND inv.id = (SELECT inv_sub.id
                        FROM invoice inv_sub,
                             stock_item si_sub
                        WHERE inv_sub.warehouses_id = w.id
                          AND inv_sub.archive = FALSE
                          AND inv_sub.expense = FALSE
                          AND inv_sub.stock_item_id = si_sub.id
                          ORDER BY inv_sub.id desc
                          limit 1);

SELECT inv_sub.id, inv_sub.price_for_one
                            FROM invoice inv_sub,
                                 stock_item si_sub
                            WHERE inv_sub.id in (289, 290)
                              AND inv_sub.warehouses_id = 205
                              AND inv_sub.archive = FALSE
                              AND inv_sub.expense = FALSE
                              AND inv_sub.stock_item_id = si_sub.id
                            ORDER BY inv_sub.id desc;