Display Options
Select Count(*) from (SELECT *, ((ACOS(SIN(39.0437 * PI() / 180) * SIN(latitude * PI() / 180) + COS(39.0437 * PI() / 180) * COS(latitude * PI() / 180) * COS((-77.4875 - longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM siteslocal where (Item like '%zzzxxzzzzzz%')and replace(name,' ','') = 'Golfballs.com' HAVING (distance<='50' or Special like '%Ashburn%') and started > DATE_SUB( NOW( ) , INTERVAL 7 DAY)) as q
SELECT *, ((ACOS(SIN(39.0437 * PI() / 180) * SIN(latitude * PI() / 180) + COS(39.0437 * PI() / 180) * COS(latitude * PI() / 180) * COS((-77.4875 - longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM siteslocal where (Item like '%zzzxxzzzzzz%')and replace(name,' ','') = 'Golfballs.com' HAVING (distance<='50' or Special like '%Ashburn%') and started > DATE_SUB( NOW( ) , INTERVAL 7 DAY)
SELECT *, ((ACOS(SIN(39.0437 * PI() / 180) * SIN(latitude * PI() / 180) + COS(39.0437 * PI() / 180) * COS(latitude * PI() / 180) * COS((-77.4875 - longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM siteslocal where (Item like '%zzzxxzzzzzz%')and replace(name,' ','') = 'Golfballs.com' HAVING (distance<='50' or Special like '%Ashburn%') and started > DATE_SUB( NOW( ) , INTERVAL 7 DAY)
Expired: October 27th 2012 at 12:07 AM
Expired: October 26th 2012 at 8:01 AM
Expired: October 22nd 2012 at 12:03 AM
Expired: October 21st 2012 at 12:06 AM
Expired: October 20th 2012 at 12:04 AM
Expired: October 18th 2012 at 12:07 AM
Expired: October 15th 2012 at 9:41 AM
Expired: October 15th 2012 at 8:37 AM
Expired: October 15th 2012 at 4:45 AM
Expired: October 11th 2012 at 12:01 AM
Expired: October 10th 2012 at 12:11 AM
Expired: October 9th 2012 at 12:04 AM
Expired: October 8th 2012 at 12:12 AM
Expired: October 7th 2012 at 12:02 AM
Expired: October 6th 2012 at 12:16 AM
Expired: October 5th 2012 at 12:03 AM
Expired: October 4th 2012 at 8:28 AM
Expired: September 30th 2012 at 4:13 PM
Expired: September 29th 2012 at 5:01 PM
Expired: September 28th 2012 at 8:38 AM
Expired: September 24th 2012 at 12:14 AM
Expired: September 23rd 2012 at 12:12 AM
Expired: September 22nd 2012 at 12:10 AM
Expired: September 21st 2012 at 11:09 AM
Expired: September 19th 2012 at 9:05 AM
Expired: September 17th 2012 at 10:15 AM
Expired: September 13th 2012 at 12:03 AM
Expired: September 11th 2012 at 12:11 AM
Expired: September 10th 2012 at 8:00 AM
Expired: September 3rd 2012 at 11:48 AM































