All types
 
Français

Companies in Mavillette, Canada

List of companies in Mavillette, Nova Scotia: find addresses, phone numbers, email, social networks, photos, customer reviews and more.

Last reviews about companies in Mavillette, Canada

  •  
    Michael Steeves Added 2018-05-16
    ★ ★ ★ ★ ★
    Thoroughly enjoyed our meal and the view. Try the rappie pie for an interesting local dish.
    Feedback on Cape View Restaurant

Popular companies in Mavillette

Share this page

Types of companies in Canada

0SELECT * FROM `locality` WHERE url = 'mavillette-ns' LIMIT 1
1UPDATE locality SET weather = '{\"date\":\"2024-04-26\",\"data\":{\"2024-04-26\":{\"07\":{\"temp\":1,\"pressure\":1030,\"humidity\":78,\"icon\":\"02d\",\"wind\":1},\"10\":{\"temp\":4,\"pressure\":1030,\"humidity\":62,\"icon\":\"01d\",\"wind\":4},\"13\":{\"temp\":5,\"pressure\":1031,\"humidity\":47,\"icon\":\"01d\",\"wind\":4},\"16\":{\"temp\":6,\"pressure\":1031,\"humidity\":45,\"icon\":\"01d\",\"wind\":4},\"19\":{\"temp\":4,\"pressure\":1032,\"humidity\":64,\"icon\":\"01n\",\"wind\":3},\"22\":{\"temp\":4,\"pressure\":1032,\"humidity\":72,\"icon\":\"01n\",\"wind\":3}},\"2024-04-27\":{\"01\":{\"temp\":4,\"pressure\":1032,\"humidity\":79,\"icon\":\"03n\",\"wind\":3},\"04\":{\"temp\":3,\"pressure\":1031,\"humidity\":80,\"icon\":\"04n\",\"wind\":3},\"07\":{\"temp\":5,\"pressure\":1033,\"humidity\":58,\"icon\":\"03d\",\"wind\":4},\"10\":{\"temp\":7,\"pressure\":1033,\"humidity\":47,\"icon\":\"01d\",\"wind\":7},\"13\":{\"temp\":8,\"pressure\":1032,\"humidity\":43,\"icon\":\"01d\",\"wind\":7},\"16\":{\"temp\":9,\"pressure\":1029,\"humidity\":43,\"icon\":\"01d\",\"wind\":5},\"19\":{\"temp\":5,\"pressure\":1030,\"humidity\":65,\"icon\":\"01n\",\"wind\":2},\"22\":{\"temp\":3,\"pressure\":1030,\"humidity\":71,\"icon\":\"01n\",\"wind\":1}},\"2024-04-28\":{\"01\":{\"temp\":2,\"pressure\":1028,\"humidity\":64,\"icon\":\"03n\",\"wind\":2},\"04\":{\"temp\":1,\"pressure\":1027,\"humidity\":62,\"icon\":\"04n\",\"wind\":3},\"07\":{\"temp\":5,\"pressure\":1027,\"humidity\":48,\"icon\":\"04d\",\"wind\":1},\"10\":{\"temp\":7,\"pressure\":1025,\"humidity\":52,\"icon\":\"04d\",\"wind\":3},\"13\":{\"temp\":7,\"pressure\":1023,\"humidity\":56,\"icon\":\"04d\",\"wind\":3},\"16\":{\"temp\":7,\"pressure\":1021,\"humidity\":63,\"icon\":\"04d\",\"wind\":3},\"19\":{\"temp\":5,\"pressure\":1019,\"humidity\":74,\"icon\":\"04n\",\"wind\":3},\"22\":{\"temp\":5,\"pressure\":1017,\"humidity\":86,\"icon\":\"04n\",\"wind\":2}}}}' WHERE id = 16199 LIMIT 1
0SELECT * FROM `region` WHERE id = 174 LIMIT 1
3SELECT * FROM `item` WHERE `locality_id` = 16199 ORDER BY count_views LIMIT 12
1SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('16199') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('42028','41927','41903','42083','32779','32693','32679','41876','32578','17585','32666','32861')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('42028','41927','41903','42083','32779','32693','32679','41876','32578','17585','32666','32861')
0SELECT * FROM `category` WHERE id IN ('96','104','107','97','98','108','99','118','102') LIMIT 9
1SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 16199 AND `date` < '2024-04-26 10:05:28' ORDER BY `date` DESC LIMIT 3
1SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('16199') LIMIT 1
0SELECT * FROM `item` WHERE id IN ('32693') LIMIT 1
2SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 16199 GROUP BY locality_id, category_id
0SELECT * FROM `category` WHERE `id` IN ('96','97','98','99','102','104','107','108','118','120','121') ORDER BY name
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
2SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 4
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16901','17077','16993') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('21513','21514','21515','21516')
0SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1