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 (1728) OR xc_ads_categories.category_id IN (1728)) 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
Ottawa's upscale Italian restaurant in the heart of Ottawa's downtown core.Tosca Ristorante offers a magnificent blend of traditional and contemporary Italian cuisine in surroundings nothing short of ...
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...
Industria Pizzeria + Bar is a modern pizzeria offering a fusion of authentic and modern Italian cuisine – SFIZI style! What is that ‘S’ word? SFIZI are Italy’s version of tapas or sharing plates. Ital...
Giovanni�s Ristorante, which you can find in Ottawa, Ontario, is proud of its reputation for serving some of the finest Italian cuisine in the surrounding area. The staff insists upon only the finest ...
WHAT DOES ALLEGRO MEAN???? Merry, cheerful, joyful, jolly, mirthful, light-heartedAllegro had been a staple in Ottawa's Little Italy for over 20 years. Whether you are in the mood for traditional Ital...
La Roma is located in Ottawa's Little Italy on Preston Street. We have semi-private dining rooms perfect for corporate events or family affairs, a large outdoor patio and a spacious bar to sip your f...
Welcome to East Side Mario’s! We opened East Side Mario’s in 1987 to bring a little taste of Italy to our guests. Our goal was to bring you the hospitality and passion for great food that Italians are...