Dynasty Twin Cinemas

Establishment, home goods store, electronics store and movie theater at 112 Burrows Avenue West, Melfort, SK S0E 1A0, Canada. Here you will find detailed information about Dynasty Twin Cinemas: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Home goods store   Electronics store   Movie theater  

Address:
112 Burrows Avenue West
Melfort
Saskatchewan S0E 1A0
Canada
Get directions

Phone:
+1 306-752-5499

Website:
dynastytheatres.ca

Reviews of Dynasty Twin Cinemas

Sorry, but now we haven't any revews about Dynasty Twin Cinemas.

Add review

About dynastytheatres.ca

Dynasty Theatres

1SELECT * FROM `item` WHERE url = 'dynasty-twin-cinemas-2' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18731') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('237931')
0SELECT * FROM `category` WHERE id IN ('96','128','152','153') LIMIT 4
0SELECT * FROM `locality` WHERE url = 'melfort-sk' LIMIT 1
0SELECT * FROM `region` WHERE id = 179 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 237931 AND `date` < '2024-04-28 06:43:19' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('237931')
0SELECT * FROM `item` WHERE id IN ('427280','426956','426831','426901','426895','426933') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18731') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('426831','426895','426901','426933','426956','427280')
0SELECT * FROM `category` WHERE id IN ('96','99','158','148','104') LIMIT 5
0SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-28" 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 ('169','178') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('14757','17962','15021','17957') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('358664','358665','358666','358667')
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