How is the plot ? I can't stand plot holes . Also in what order should i read ? I have watched season 1 and 2 of the series and thought it was average and won't be bothering with season 3 as cavil is sacked after this anyway . Also i like the harry potter series as they have fleshed out characters and good plot with very minimal holes (why didn't you break the fucking wand harry your going to be an auror).
Also any good english translation which will cover the whole book ?
They are great. S1 adapted some of the short stories (along with S2E1) in a okayish way, rest of S2 had nothing familiar with the books really. Books are awesome and can recommend, it's my favorite tbh.
As others have said, get Last Wish, a collection of short stories with nothing but some of the characters in common. Sword of Destiny is the same, but it begins to be interconnected. After that begins the Saga of 5 books - Blood of Elves, Time of Contempt, Baptism if Fire, Tower of the Swallow and finally Lady of the Lake. It picks up right where the Sword of Destiny left off. Then there is Season of Storms, which is a prequel.
Can't advise on translations as I didn't read them in English.