All types
 
Français

Companies in Port Saunders, Canada

List of companies in Port Saunders, Newfoundland and Labrador: find addresses, phone numbers, email, social networks, photos, customer reviews and more.

Last reviews about companies in Port Saunders, Canada

  •  
    Betony Ann Added 2017-08-26
    ★ ★ ★ ☆ ☆
    We stopped here on our way through just to check it out. I was not impressed by the staff at this little place. No one got up to greet us or offer us...
    Feedback on The Torrent River Nature Park

Popular companies in Port Saunders

Share this page

Types of companies in Canada

1SELECT * FROM `locality` WHERE url = 'port-saunders-nl' LIMIT 1
1UPDATE locality SET weather = '{\"date\":\"2024-04-18\",\"data\":{\"2024-04-18\":{\"01\":{\"temp\":0,\"pressure\":1018,\"humidity\":78,\"icon\":\"04n\",\"wind\":7},\"04\":{\"temp\":-1,\"pressure\":1019,\"humidity\":75,\"icon\":\"04d\",\"wind\":7},\"07\":{\"temp\":0,\"pressure\":1019,\"humidity\":66,\"icon\":\"04d\",\"wind\":7},\"10\":{\"temp\":2,\"pressure\":1018,\"humidity\":63,\"icon\":\"04d\",\"wind\":7},\"13\":{\"temp\":3,\"pressure\":1017,\"humidity\":60,\"icon\":\"04d\",\"wind\":7},\"16\":{\"temp\":3,\"pressure\":1017,\"humidity\":63,\"icon\":\"04d\",\"wind\":7},\"19\":{\"temp\":1,\"pressure\":1019,\"humidity\":63,\"icon\":\"04n\",\"wind\":8},\"22\":{\"temp\":-0,\"pressure\":1019,\"humidity\":74,\"icon\":\"02n\",\"wind\":7}},\"2024-04-19\":{\"01\":{\"temp\":-0,\"pressure\":1020,\"humidity\":77,\"icon\":\"04n\",\"wind\":5},\"04\":{\"temp\":-1,\"pressure\":1020,\"humidity\":78,\"icon\":\"03d\",\"wind\":4},\"07\":{\"temp\":1,\"pressure\":1021,\"humidity\":65,\"icon\":\"03d\",\"wind\":3},\"10\":{\"temp\":3,\"pressure\":1021,\"humidity\":57,\"icon\":\"03d\",\"wind\":4},\"13\":{\"temp\":4,\"pressure\":1020,\"humidity\":51,\"icon\":\"04d\",\"wind\":2},\"16\":{\"temp\":4,\"pressure\":1019,\"humidity\":52,\"icon\":\"04d\",\"wind\":1},\"19\":{\"temp\":2,\"pressure\":1020,\"humidity\":66,\"icon\":\"04n\",\"wind\":2},\"22\":{\"temp\":1,\"pressure\":1020,\"humidity\":74,\"icon\":\"03n\",\"wind\":2}},\"2024-04-20\":{\"01\":{\"temp\":1,\"pressure\":1018,\"humidity\":75,\"icon\":\"03n\",\"wind\":2},\"04\":{\"temp\":1,\"pressure\":1017,\"humidity\":77,\"icon\":\"04d\",\"wind\":3},\"07\":{\"temp\":5,\"pressure\":1016,\"humidity\":60,\"icon\":\"04d\",\"wind\":4},\"10\":{\"temp\":6,\"pressure\":1014,\"humidity\":54,\"icon\":\"04d\",\"wind\":6},\"13\":{\"temp\":5,\"pressure\":1012,\"humidity\":67,\"icon\":\"04d\",\"wind\":9},\"16\":{\"temp\":4,\"pressure\":1011,\"humidity\":74,\"icon\":\"04d\",\"wind\":8},\"19\":{\"temp\":5,\"pressure\":1011,\"humidity\":73,\"icon\":\"04n\",\"wind\":8},\"22\":{\"temp\":4,\"pressure\":1010,\"humidity\":71,\"icon\":\"04n\",\"wind\":7}}}}' WHERE id = 15889 LIMIT 1
0SELECT * FROM `region` WHERE id = 172 LIMIT 1
2SELECT * FROM `item` WHERE `locality_id` = 15889 ORDER BY count_views LIMIT 12
0SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15889') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('191185','191250','191163','191326','189006','191205','191276','191060','191127','191071','191221','191143')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('191185','191250','191163','191326','189006','191205','191276','191060','191127','191071','191221','191143')
0SELECT * FROM `category` WHERE id IN ('96','107','109','142','103','133','108','99','102','115','104','164') LIMIT 12
1SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 15889 AND `date` < '2024-04-18 04:20:14' ORDER BY `date` DESC LIMIT 3
0SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15889') LIMIT 1
0SELECT * FROM `item` WHERE id IN ('189006') LIMIT 1
2SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 15889 GROUP BY locality_id, category_id
0SELECT * FROM `category` WHERE `id` IN ('96','97','98','99','102','103','104','107','108','109','110','112','114','115','118','120','121','128','130','133','142','143','164','168') ORDER BY name
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
1SELECT * 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 ('168','174','170') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('14247','16041','15174') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('418088','418089','418090','418091')
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