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 (1748) OR xc_ads_categories.category_id IN (1748)) 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 on the 16th floor of the Andaz Ottawa hotel, this premium lounge boasts the title of city's tallest rooftop bar, providing a view like no other. Overlook copper-topped buildings while sipping ...
Located on the first floor of the Andaz Hotel, Feast + Revel proudly offers a culinary program in celebration of the land on which it stands. Combining old world traditional methods and flavours from ...
Famous for its renowned 3-hour spit-roasted chicken, its perfectly tender ribs and delicious BBQ sauce, the Hull St-Hubert also offers a chic, modern and warm atmosphere with its freshly renovated dec...
Wilfrid’s Restaurant offers diners a vibrant seasonal menu featuring local and regional ingredients. The culinary flavors are rich, the presentation is clean and the service is exceptional. A complet...
Grounded has a ‘made-from-scratch’ philosophy - from the homemade 57 sauce to the DIY concrete bar top. Our name says it all!Grounded features an entirely made-from-scratch kitchen prepared by cultura...
A Northern Italian kitchen inspired by the Bacari of VeniceOur menu is inspired by tradition and dictated by the quality and availability of ingredients. We play off the similarities between the clima...
Carben is located in Hintonburg and thrives from the vibrancy and support of the community. The restauarant is named after the owners Caroline Ngo and Kevin Benes. It is a play on carbon, which is a c...
Famous for its renowned 3-hour spit-roasted chicken, its perfectly tender ribs and delicious BBQ sauce, the Ottawa St-Hubert also offers a relaxed and modern atmosphere which is the ideal spot to gath...
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...