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: January 27th 2012 at 7:54 AMExpired: January 27th 2012 at 1:53 PM
Started: January 31st 2012 at 6:58 PMExpired: February 2nd 2012 at 12:22 PM
Started: February 8th 2012 at 1:33 PMExpired: February 9th 2012 at 12:48 PM
Started: February 15th 2012 at 6:08 PMExpired: February 17th 2012 at 11:38 AM
Started: February 20th 2012 at 12:03 PMExpired: February 20th 2012 at 10:29 PM
Started: February 24th 2012 at 11:27 AMExpired: February 26th 2012 at 1:07 PM
Started: March 3rd 2012 at 1:49 PMExpired: March 4th 2012 at 10:02 PM
Started: June 21st 2012 at 5:38 PMExpired: June 22nd 2012 at 12:35 PM
Started: June 11th 2011 at 4:51 PMExpired: June 14th 2011 at 11:23 AM
Started: June 21st 2011 at 12:43 PMExpired: June 22nd 2011 at 4:41 PM
Started: July 16th 2011 at 7:06 AMExpired: July 16th 2011 at 9:28 AM
Started: January 17th 2012 at 12:42 PMExpired: January 17th 2012 at 1:00 PM
Started: January 23rd 2012 at 1:33 PMExpired: January 26th 2012 at 12:10 PM
Started: June 11th 2012 at 11:07 AMExpired: June 14th 2012 at 6:55 PM
Started: June 15th 2012 at 1:39 PMExpired: June 21st 2012 at 5:38 PM
Started: July 22nd 2011 at 12:35 PMExpired: July 23rd 2011 at 4:36 PM
Started: July 25th 2011 at 5:26 PMExpired: July 26th 2011 at 7:03 PM