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 (1768) OR xc_ads_categories.category_id IN (1768)) 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
Sur-lie is a contemporary Canadian-French restaurant and wine bar located in Ottawa's By-ward market. We celebrate the finest ingredients paired with genuine hospitality. Sur-lie has a diverse wine ...
In the Byward Market, Blue Cactus Bar and Grill offers the right blend of a modern uptown atmosphere with contemporary cuisine. From starters to main dishes, Blue Cactus Bar and Grill offers excellenc...
Welcome to the Clarendon Tavern! Offering seasonal, locally sourced and handmade ingredients. Beautifully designed to embrace our heritage building roots with a modern twist. Chef Dave Godsoe was insp...
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...
Bold flavors elevate beloved bistro classics in chic and inviting Bazille. Meet up with friends at the bar for internationally sourced wines and handcrafted cocktails. Stay for appetizers, salads, bri...