Companies in Rosetown, Canada

List of companies in Rosetown, Saskatchewan: find addresses, phone numbers, email, social networks, photos, customer reviews and more.

Last reviews about companies in Rosetown, Canada

Weather in Rosetown (Saskatchewan)

2024-04-18

2024-04-18 22:00
 
Temperature -3
Pressure hPa 1029 hPa
Humidity % 81 %
Wind speed m/s 8 m/s

2024-04-19

2024-04-19 01:00 04:00 07:00 10:00 13:00 16:00 19:00 22:00
 
Temperature -3 -4 -5 -4 -2 0 0 -3
Pressure hPa 1030 hPa 1032 hPa 1034 hPa 1036 hPa 1035 hPa 1035 hPa 1034 hPa 1035 hPa
Humidity % 85 % 84 % 85 % 77 % 69 % 59 % 59 % 72 %
Wind speed m/s 7 m/s 7 m/s 6 m/s 6 m/s 5 m/s 5 m/s 4 m/s 3 m/s

2024-04-20

2024-04-20 01:00 04:00 07:00 10:00 13:00 16:00 19:00 22:00
 
Temperature -3 -3 -3 1 5 7 7 2
Pressure hPa 1034 hPa 1034 hPa 1033 hPa 1031 hPa 1030 hPa 1027 hPa 1024 hPa 1023 hPa
Humidity % 66 % 65 % 68 % 51 % 38 % 36 % 37 % 73 %
Wind speed m/s 2 m/s 3 m/s 3 m/s 4 m/s 4 m/s 4 m/s 3 m/s 4 m/s

Popular companies in Rosetown

0SELECT * FROM `locality` WHERE url = 'rosetown-sk' LIMIT 1
0SELECT * FROM `region` WHERE id = 179 LIMIT 1
4SELECT * FROM `item` WHERE `locality_id` = 18813 ORDER BY count_views LIMIT 12
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18813') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('212598','212546','225493','212667','212591','212384','225391','212372','212574','212407','212416','212426')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('212598','212546','225493','212667','212591','212384','225391','212372','212574','212407','212416','212426')
0SELECT * FROM `category` WHERE id IN ('96','100','124','97','98','99','148','151','156','107','114','144','103','128','134') LIMIT 15
7SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 18813 AND `date` < '2024-04-19 05:24:36' ORDER BY `date` DESC LIMIT 3
1SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18813') LIMIT 1
0SELECT * FROM `item` WHERE id IN ('212372','212416','225391') LIMIT 3
5SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 18813 GROUP BY locality_id, category_id
1SELECT * FROM `category` WHERE `id` IN ('96','97','98','99','100','101','102','103','104','106','107','108','110','111','112','114','115','118','119','120','121','123','124','125','126','127','128','129','130','131','132','133','134','135','136','138','139','141','142','143','144','148','150','151','155','156','159','161','162','163','164','165','166','167','168') ORDER BY name
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-19" 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 ('168','178','176') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('14327','18246','17811','16908') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('460703','460704','460705','460706')
1SELECT * 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