Welcome, Guest
Please Login or Register.    Lost Password?
Re:Halls bars (1 viewing) (1) Guest
Student Bars and clubs
Go to bottom Favoured: 0
TOPIC: Re:Halls bars
#36
Halls bars 3 Months, 3 Weeks ago  
How good are the bars at halls? i'm going to be living in Whitworth Park this year and just wondered whether students usualy go to their halls bar much or whether theres much better times out in the town?!
SarahGirl (User)
null
Fresh Boarder
Posts: 3
graphgraph
User Offline
ICQ#: null null null null null null null Location: null
Logged Logged  
 
null
 
The administrator has disabled public write access.  
#37
Re:Halls bars 3 Months, 2 Weeks ago  
The bars are pretty good! Cheap drinks on your doorstep, and it's usually a good night and a good way to meet your new neighbours. I was at Whitworth Park last year, and you'll spend a lot of your first term in the Grovel but after Christmas things do slow down a lot, probably due to January exams. But yeah, you'll find out whether u like them or not soon enough! Enjoy.
fred (Admin)
null
Moderator
Posts: 35
graph
User Online Now
ICQ#: null null null null null null null Location: null
Logged Logged  
 
null
 
The administrator has disabled public write access.  
Go to top
Generated in 1.23527 Seconds
123 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT `id`,`link` FROM jos_menu WHERE ((`name` LIKE '%social scene%') AND (`published` > 0))
4 SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'social-scene/37-rehalls-bars.html' ORDER BY rank ASC LIMIT 1
5 UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_fireboard&Itemid=67&catid=4&func=view&id=37&lang=en' AND `oldurl` = 'social-scene/37-rehalls-bars.html'
6 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 67 ) ORDER BY menuid DESC LIMIT 1
7 DELETE FROM jos_session WHERE ( ( time < '1231330404' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1231330404' ) AND guest = 1 AND userid = 0 )
8 SELECT params FROM jos_mambots WHERE element = 'rokhead' AND folder = 'system'
9 SELECT params FROM jos_mambots WHERE element = 'rokbox' AND folder = 'system'
10 SELECT * FROM jos_menu WHERE id = 67
11 SELECT * FROM jos_fb_config
12 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_fireboard' AND published = 1
13 SELECT template FROM jos_templates_menu where client_id ='0'
14 DELETE FROM jos_fb_whoisonline WHERE time < '1231329504'
15 SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.103.63.61' AND userid='0'
16 SELECT subject FROM jos_fb_messages WHERE id = 37
17 UPDATE jos_fb_whoisonline SET time='1231331304', what='Re:Halls bars', do= '', task= '', link= '/index.php?option=com_fireboard&Itemid=67&catid=4&func=view&id=37&lang=en', func= 'view' WHERE userid=0 AND userip='38.103.63.61'
18 SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=4
19 SELECT moderator FROM jos_fb_users WHERE userid=0
20 SELECT id FROM jos_fb_categories WHERE pub_access=0 AND published=1
21 SELECT max(posts) from jos_fb_users
22 SELECT parent FROM jos_fb_categories WHERE id=4
23 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
24 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
25 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
26 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=listcat&lang=en'
27 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
28 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=view&id=37&lang=en&view=threaded'
29 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
30 SELECT id, name FROM jos_fb_categories WHERE id=4
31 SELECT id, subject FROM jos_fb_messages WHERE id=37
32 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=search&lang=en'
33 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
34 SELECT su.view, u.name, su.moderator,su.avatar FROM jos_fb_users as su LEFT JOIN jos_users as u on u.id=su.userid WHERE su.userid=0
35 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&do=show&func=myprofile&lang=en'
36 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
37 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&do=show&func=myprofile&lang=en'
38 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
39 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&auth=0&func=showauthor&lang=en&task=showmsg'
40 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
41 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
42 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
43 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_login&Itemid=0&lang=en'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=logout&lang=en'
45 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&Itemid=0&lang=en&task=register'
46 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&Itemid=0&lang=en&task=lostPassword'
47 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 ) ORDER BY ordering
48 SELECT `code` , `location` FROM `jos_fb_smileys`;
49 SELECT id,pub_access,pub_recurse,admin_access,admin_recurse FROM jos_fb_categories where id=4
50 SELECT * FROM jos_fb_messages AS a LEFT JOIN jos_fb_messages_text AS b ON a.id=b.mesid WHERE a.id=37 and a.hold=0
51 SELECT * FROM jos_fb_messages AS a LEFT JOIN jos_fb_messages_text AS b ON a.id=b.mesid WHERE a.id=37 and a.hold=0
52 UPDATE jos_fb_messages SET hits=hits+1 WHERE id=36 AND parent=0
53 SELECT ordering from jos_fb_users where userid=0
54 SELECT * FROM jos_fb_messages AS a LEFT JOIN jos_fb_messages_text AS b ON a.id=b.mesid WHERE (a.thread='36' OR a.id='36') AND a.hold=0 AND a.catid='4' ORDER BY a.time ASC
55 SELECT * from jos_fb_categories where id='4'
56 SELECT name,id from jos_fb_categories WHERE id='1'
57 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&lang=en'
58 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
59 select * from jos_fb_categories where id=4 and published=1
60 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=showcat&lang=en'
61 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
62 SELECT id, name FROM jos_fb_categories WHERE id=4
63 select * from jos_fb_categories where id=1 and published=1
64 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=1&func=showcat&lang=en'
65 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
66 SELECT id, name FROM jos_fb_categories WHERE id=1
67 select subject from jos_fb_messages where id = 37
68 SELECT w.userid, u.username , k.showOnline FROM jos_fb_whoisonline AS w LEFT JOIN jos_users AS u ON u.id=w.userid LEFT JOIN jos_fb_users AS k ON k.userid=w.userid WHERE w.link like '%/index.php?option=com_fireboard&Itemid=67&catid=4&func=view&id=37&lang=en%'
69 SELECT COUNT(*) FROM jos_fb_favorites where thread='36'
70 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&do=reply&func=post&lang=en'
71 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
72 SELECT id, name FROM jos_fb_categories WHERE id=4
73 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=fb_pdf&id=37&lang=en'
74 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
75 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
76 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
77 SELECT a.userid FROM jos_fb_users AS a LEFT JOIN jos_fb_moderation AS b ON b.userid=a.userid WHERE b.catid='4'
78 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
79 SELECT a.*,b.name,b.username,b.gid FROM jos_fb_users as a LEFT JOIN jos_users as b on b.id=a.userid where a.userid='72'
80 SELECT name FROM jos_core_acl_aro_groups WHERE group_id=18
81 SELECT * FROM jos_fb_ranks WHERE ((rank_min <= 3) AND (rank_special = 0)) ORDER BY rank_min DESC LIMIT 1
82 SELECT count(userid) FROM jos_session WHERE userid=72
83 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=72'
84 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
85 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=72'
86 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
87 SELECT email, name from jos_users WHERE `id`=0
88 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=72'
89 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
90 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=72'
91 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
92 select id, title from jos_fb_groups as g, jos_fb_users as u where u.group_id = g.id and u.userid= 72
93 SELECT a.*,b.name,b.username,b.gid FROM jos_fb_users as a LEFT JOIN jos_users as b on b.id=a.userid where a.userid='62'
94 SELECT name FROM jos_core_acl_aro_groups WHERE group_id=25
95 SELECT * FROM jos_fb_ranks WHERE rank_id = '8'
96 SELECT count(userid) FROM jos_session WHERE userid=62
97 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
98 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
99 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
100 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
101 SELECT email, name from jos_users WHERE `id`=0
102 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
103 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
104 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
105 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
106 select id, title from jos_fb_groups as g, jos_fb_users as u where u.group_id = g.id and u.userid= 62
107 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&lang=en'
108 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
109 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=1&func=listcat&lang=en'
110 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
111 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=showcat&lang=en'
112 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
113 SELECT id, name FROM jos_fb_categories WHERE id=4
114 SELECT c.* FROM jos_fb_categories c WHERE c.id IN (1,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) ORDER BY ordering, name
115 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=credits&lang=en'
116 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
117 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fb_rss&lang=en&no_html=1'
118 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
119 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
120 SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0' GROUP BY m.id ORDER BY m.parent, m.ordering
121 SELECT m.* FROM jos_menu AS m WHERE menutype='mainmenu' AND m.published='1'
122 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
123 SELECT m.* FROM jos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering