Cable: There used to be just ordinary TV coax cable, commonly referred to a "Low Loss Coax" and that was perfectly okay for analogue TV. Then came satellite and with it a higher grade of cable was needed for use between the dish/LNB and receiver. The old brown low loss coax wasn't good enough. The new cable was better engineered but more expensive as a result: hence 'satellite cable' was born. Analogue TV aerial installs used the low loss stuff. Satellite (also analogue at the time) used the better stuff because it was better at handling the higher frequency signal.
In the late 90's the terrestrial TV market started the phased introduction of digital TV. The new standard required a higher grade of cable. In short, satellite grade cable became the preferred standard for TV installation too.
Today it's still possible to buy low loss single screen coax, but no self-respecting installer would use it. Most of the rest of what's sold is double screened coax. There are different qualities of it; RG6 is a bit crap but cheap, WF65 is the commercial equivalent to Sky's thin shotgun cable, WF100 is the good stuff because it's all copper. You'll see retailers refer to "TV coax" or "Satellite coax" depending on who they're selling to, but the fact is that this stuff can be used for either application. What determines the result is the source device which would be either an aerial (for Freeview) or a satellite dish LNB and then the corresponding type of receiver at the other end.
Cable alone can't change one signal type to another any more than your phone line can translate Chinese in to English. Even if the cable is marked up as for satellite use, if there's a TV aerial on the end then you'll get TV aerial signal out of the other end.
