Deals on the Fly Past Item History
Share
Display Options
View The Deals on the Fly Merchant ProfileSelect 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,' ','') = 'DealsontheFly' 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,' ','') = 'DealsontheFly' 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,' ','') = 'DealsontheFly' HAVING (distance<='50' or Special like '%Ashburn%') and started > DATE_SUB( NOW( ) , INTERVAL 7 DAY)
Started: October 26th 2012 at 12:55 PMExpired: October 29th 2012 at 8:09 AM
Started: October 30th 2012 at 6:20 PMExpired: October 31st 2012 at 12:33 PM
Started: November 6th 2012 at 1:59 PMExpired: November 7th 2012 at 12:11 PM
Started: November 9th 2012 at 3:47 PMExpired: November 10th 2012 at 3:19 PM
Started: October 17th 2012 at 11:40 AMExpired: October 18th 2012 at 11:54 AM
Started: October 22nd 2012 at 10:15 AMExpired: October 22nd 2012 at 1:04 PM
Started: November 7th 2012 at 12:11 PMExpired: November 9th 2012 at 12:48 PM
Started: November 10th 2012 at 3:19 PMExpired: November 13th 2012 at 11:56 AM
Started: September 27th 2012 at 12:08 PMExpired: September 29th 2012 at 3:24 PM
Started: October 24th 2012 at 12:32 PMExpired: October 25th 2012 at 1:57 PM
