Select Spr_Tovar.self,
           Spr_Tovar.Min_Count,
           Spr_Tovar.Max_Count, 
           Spr_Tovar.Tree_ID, 
           Spr_Tovar.Caption as Caption,
           Spr_Tovar.Price as Price,
           Spr_Tovar.Hide as Hide,
           Spr_Tovar.Measure_ID as Measure_ID,
           Spr_Tovar.Country_ID as Country_ID,
           PLUI.PLU_int,
           Spr_Country.Caption as Country,
           Spr_Measure.Caption as Measure
From   Spr_Tovar,Spr_Country, Spr_Measure,
 (select PLU_Int as PLU_Int,Tovar_ID from Tovar_Barcode where PLU= 1 )PLUI

where Spr_Tovar.tree_id=:self and
           Spr_Country.self=Spr_Tovar.Country_ID and
           Spr_Measure.self=Spr_Tovar.Measure_ID  and
 PLUI.tovar_id=Spr_Tovar.self