All types
 
Français

Establishments in Upper Salmon Creek, Canada

List of Establishments in Upper Salmon Creek, New Brunswick: find addresses, phone numbers, email, social networks, photos, customer reviews and more.

Popular establishments in Upper Salmon Creek

Share this page

Price levels of establishments in Upper Salmon Creek

Types of companies in Canada

1SELECT * FROM `locality` WHERE url = 'upper-salmon-creek-nb' LIMIT 1
1UPDATE locality SET weather = '{\"date\":\"2024-04-23\",\"data\":{\"2024-04-23\":{\"13\":{\"temp\":12,\"pressure\":1020,\"humidity\":33,\"icon\":\"01d\",\"wind\":7},\"16\":{\"temp\":11,\"pressure\":1019,\"humidity\":38,\"icon\":\"02d\",\"wind\":6},\"19\":{\"temp\":5,\"pressure\":1019,\"humidity\":58,\"icon\":\"02n\",\"wind\":4},\"22\":{\"temp\":1,\"pressure\":1019,\"humidity\":65,\"icon\":\"04n\",\"wind\":3}},\"2024-04-24\":{\"01\":{\"temp\":-1,\"pressure\":1016,\"humidity\":87,\"icon\":\"04n\",\"wind\":2},\"04\":{\"temp\":-2,\"pressure\":1014,\"humidity\":88,\"icon\":\"02n\",\"wind\":2},\"07\":{\"temp\":5,\"pressure\":1012,\"humidity\":57,\"icon\":\"02d\",\"wind\":3},\"10\":{\"temp\":12,\"pressure\":1008,\"humidity\":36,\"icon\":\"04d\",\"wind\":3},\"13\":{\"temp\":14,\"pressure\":1004,\"humidity\":39,\"icon\":\"04d\",\"wind\":5},\"16\":{\"temp\":9,\"pressure\":1003,\"humidity\":55,\"icon\":\"04d\",\"wind\":3},\"19\":{\"temp\":3,\"pressure\":1003,\"humidity\":97,\"icon\":\"10n\",\"wind\":3},\"22\":{\"temp\":-0,\"pressure\":1003,\"humidity\":96,\"icon\":\"13n\",\"wind\":7}},\"2024-04-25\":{\"01\":{\"temp\":-4,\"pressure\":1005,\"humidity\":90,\"icon\":\"13n\",\"wind\":7},\"04\":{\"temp\":-4,\"pressure\":1009,\"humidity\":74,\"icon\":\"13n\",\"wind\":8},\"07\":{\"temp\":-2,\"pressure\":1012,\"humidity\":63,\"icon\":\"04d\",\"wind\":8},\"10\":{\"temp\":2,\"pressure\":1015,\"humidity\":45,\"icon\":\"04d\",\"wind\":8},\"13\":{\"temp\":4,\"pressure\":1017,\"humidity\":44,\"icon\":\"04d\",\"wind\":7},\"16\":{\"temp\":5,\"pressure\":1020,\"humidity\":47,\"icon\":\"04d\",\"wind\":6},\"19\":{\"temp\":1,\"pressure\":1023,\"humidity\":61,\"icon\":\"04n\",\"wind\":4},\"22\":{\"temp\":-2,\"pressure\":1025,\"humidity\":80,\"icon\":\"02n\",\"wind\":2}}}}' WHERE id = 15674 LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
0SELECT * FROM `category` WHERE url = 'establishment' LIMIT 1
2SELECT locality_id, category_id, price_level FROM `category_item` WHERE locality_id = 15674 AND category_id = 96 GROUP BY locality_id, category_id, price_level
0SELECT COUNT(*) FROM `category_item` WHERE locality_id = 15674 AND category_id = 96
4SELECT * FROM category_item INNER JOIN item ON category_item.item_id = item.id WHERE category_item.locality_id = 15674 AND category_item.category_id = 96 ORDER BY item.name LIMIT 0,24
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15674') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('96195','46720','46600','46636','46638','46657','46965','96233')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('96195','46720','46600','46636','46638','46657','46965','96233')
0SELECT * FROM `category` WHERE id IN ('96','110','99','102','115','117','118','152','100') LIMIT 9
0SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 15674 GROUP BY locality_id, category_id
0SELECT * FROM `category` WHERE `id` IN ('96','99','100','102','110','115','117','118','152') ORDER BY name
0SELECT * FROM counts where updated="2024-04-23" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-23" and table_name like 'news'
1SELECT * 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 ('176','174','178') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('16653','16339','17570') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('311321','311322','311323','311324')
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 ('169') LIMIT 1