There are plenty of theories floating about concerning the best methods for beating jetlag, very few of which come backed up with any serious scientific clout.

The SQL below should work:

SELECT*FROM Table1 a 
WHERE(
          acos(sin(a.Latitude *0.0175)* sin(YOUR_LATITUDE_X *0.0175)+ cos(a.Latitude *0.0175)* cos(YOUR_LATITUDE_X *0.0175)*    
                 cos((YOUR_LONGITUDE_Y *0.0175)-(a.Longitude *0.0175)))*3959<= YOUR_RADIUS_INMILES
      )

I usually test a movie by Metacritic .com, Rottentomatoes .com, or its trailer before I see it. This has saved me some time and money. Also, I take it that deep/awe-inspiring and/or thought-provoking movies are the same thing as good quality films. Film is an art and all good art has those qualities. Enjoy.

A fantastically witty reminder of how eager people are to fill in the blanks with themselves and what they like to hear.++-++

A lot of people haven’t seen Vanilla Sky because it has Tom Cruise in it. Let me tell you, it’s not only his best movie, it’s one of the best movies ever made.Not having seen this is almost like not having seen the first Matrix.

Anyone who’s ever accidentally downloaded a large email while on holiday will attest to the ridiculousness of data roaming charges, and though there’s no indication from the networks that they’re working on putting things right, there are measures you can take to avoid an end-of-month sting. Once installed, this app drastically reduces the amount of data required to perform everyday tasks, such as retrieving email and posting to Facebook. We’re not entirely sure how it manages such a feat – we just know that it works and we’re not about to complain.
Available on iPhone (free) and Android (free)

Onavo

Anyone who’s ever accidentally downloaded a large email while on holiday will attest to the ridiculousness of data roaming charges, and though there’s no indication from the networks that they’re working on putting things right, there are measures you can take to avoid an end-of-month sting. Once installed, this app drastically reduces the amount of data required to perform everyday tasks, such as retrieving email and posting to Facebook. We’re not entirely sure how it manages such a feat – we just know that it works and we’re not about to complain.
Available on iPhone (free) and Android (free)

Sunscreen

Until the bashful lobster look finds its way into the style zeitgeist, this is a crucial piece of kit for those venturing to sunny climes. Having detected the UVI rating of your current location, this nifty little app sets a countdown timer to alert you when you’re due your next slathering of sunblock. All you have to do is input your skin type and the SPF of your lotion, then kick back and soak up some worry-free rays.
Available on iPhone (free)

XE Currency

Don’t bother paying up for one of the many currency conversion apps out there in the digital hinterland – this freebie is slick, easy to use, and – best of all, since it uses live currency rates – completely accurate. It’s been downloaded more than five million times to date, so don’t even think about hopping on a plane without it.
Available on iPhone (free), iPad (free), Android (free) and Windows Phone (free)

JetLag Genie

There are plenty of theories floating about concerning the best methods for beating jetlag, very few of which come backed up with any serious scientific clout. Still, it’s generally agreed that gradually altering your sleeping habits before a trip is beneficial, and this clever app will help you do just that. Input your travel dates, destination and usual sleeping times and it’ll come back with personalised alarm clocks to soften the blow when you wake up on Tuesday afternoon convinced it’s still Monday morning.

Available on iPhone (£1.99)