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 (1761) OR xc_ads_categories.category_id IN (1761)) 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 ...
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 ...
Opened in the summer of 1999, SOCIAL was conceived as the perfect blend of restaurant and bar. It was envisioned as a place where guests could enjoy an evening drink without feeling obligated to order...
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...