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 (1732) OR xc_ads_categories.category_id IN (1732)) 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
Welcome to Last Train to Delhi. We are a progressive Indian restaurant in the beautiful Glebe community in Ottawa. Our speciality is Northern Indian food, classics like Murg Mahkini and some modern ...
NH44 is all about introducing Ottawa to a new version of Indian cuisine by using collection of diverse spices and traditions. We bring a collection of dynamic creations of dishes from the streets of ...
Taj Indian Cuisine is a family owned restaurant that opened in 1987 and has remained a fixture in Ottawa for over 30 years. At Taj, our customer experience focuses on personal and customized services ...