lat_lng_distance(xc_ads.lat, xc_ads.lng,45.444229125977,-75.692779541016) AS dist, xc_ads.id, xc_ads.date_creation, xc_ads.slug, xc_ads.user_id, xc_ads_params.value_num AS ad_price, xc_ads.ad_title, xc_currencies.name_currency, xc_favourites.id AS fav_id, xc_categories.category_name
SELECT lat_lng_distance(xc_ads.lat, xc_ads.lng,45.444229125977,-75.692779541016) AS dist, xc_ads.id
LEFT JOIN xc_ads_categories
ON xc_ads_categories.ad_id = xc_ads.id WHERE 1=1 AND NOT IsNull(lat) AND NOT IsNull(lng) AND lat<>0 AND lng<>0
AND (xc_ads.category_id IN (1744) OR xc_ads_categories.category_id IN (1744)) AND xc_ads.lat>44.163629782972 AND xc_ads.lat<46.724828468981 AND xc_ads.lng>-76.591252137601 AND xc_ads.lng<-74.79430694443
HAVING dist< 100
ORDER BY dist, xc_ads.bump_up_date DESC
) AS b ON b.id = xc_ads.id
LEFT JOIN xc_currencies
ON xc_currencies.ID = xc_ads.currency_id
LEFT JOIN xc_categories
ON xc_categories.id = xc_ads.category_id
LEFT JOIN xc_ads_params
ON xc_ads_params.param_id=5 AND xc_ads_params.ad_id=xc_ads.id
LEFT JOIN xc_favourites
ON xc_favourites.ad_id=xc_ads.id AND xc_favourites.user_id=0
WHERE xc_ads.status='approved' AND xc_ads.is_deal=0 GROUP BY xc_ads.id ORDER BY 1, dist
Located in the heart of downtown Ottawa at the corner of Sparksand Bank Streets, the 3 Brewers is a Microbrewery where we brewall of our beer on site. Steps from Parliament, we have a fantasticlocatio...
We have a thing for stories. We tell ours through our fresh ingredients and our passion for the plate. Twenty-five years ago, the Milestones story began in Vancouver on Denman Street. Today, we span c...
3 Brewers Kanata is located at the Kanata Centrum Shopping Centre. We are a microbrewery / restaurant with 2 floors of great dining and 2 bars. A great place to watch the game on the big screen, rela...
Our mission? Great people helping other great people totally have a blast while enjoying amazing food. Wow, that was a mouthful. But can you blame us? We’re a restaurant. One that specializes in delic...