FROM OBJ_HEADER, OBJ_POLOZKY, CENIK, S_DPH, S_ZBOZI_SK, RABAT, OBCHODNI_PARTNERI, S_DEAL_SK
WHERE S_deal_sk.DEAL_ID=Obchodni_partneri.DEAL_SK AND Obchodni_partneri.ID=Obj_header.ID_ORG AND Rabat.METODA=S_zbozi_sk.RABAT AND S_zbozi_sk.ID_SKUPINY=Cenik.SKUPINA_ZBOZI AND S_dph.ID_DPH=Cenik.DPH AND Cenik.ID_CENIK=Obj_polozky.ID_CNK AND Obj_polozky.ID_DOBJ=Obj_header.ID_DOBJ
AND (S_dph.uc_rok=year(today))
ORDER BY Obj_header.id_dobj,Obj_polozky.id_pol,Rabat.nad_mnoz