Home
Transport
Getting around
The First Group bus company 73375
40 queries executed
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='126' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1686358477)
4
SELECT * FROM mos_session WHERE session_id='e5e0e2f2ae127205776c19074f4628dc'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('b07303223d15cd032ae2661acfbf7c39')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '6309f8ebfefd0082db21482f2691cf89','1686359377','','0','1' )
7
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
9
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
10
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
11
SELECT count(*) FROM mos_stats_agents WHERE agent='ec2-34-229-131-158.compute-1.amazonaws.com' AND type='2'
12
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='ec2-34-229-131-158.compute-1.amazonaws.com' AND type='2'
13
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
15
SELECT access FROM mos_menu WHERE id='126'
16
SELECT * FROM mos_menu WHERE id='126'
17
SELECT * FROM mos_categories WHERE id='86'
18
SELECT * FROM mos_menu WHERE id='126'
19
SELECT c.*, COUNT( b.id ) AS numitems
 FROM mos_categories AS c
 LEFT JOIN mos_content AS b ON b.catid = c.id 
 AND b.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-10 01:09:37' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-10 01:09:37' )
 WHERE c.section = '4'
 AND c.access <= '0'
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
20
SELECT a.id
 FROM mos_content AS a
 WHERE a.sectionid = '4'
 AND a.catid = '86'
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-10 01:09:37' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-10 01:09:37' )
21
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid='86' 
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-10 01:09:37' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-10 01:09:37' )
 AND a.access<='0'
 AND '0'<='0'
 ORDER BY a.created DESC
 LIMIT 0, 50
22
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '126' OR mm.menuid = '0')
ORDER BY ordering
23
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
24
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
25
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
26
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
27
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
28
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
29
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
30
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
31
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
32
SELECT m.* FROM mos_menu AS m
WHERE menutype='Village Life' AND published='1' AND access <= '0'
ORDER BY parent,ordering
33
SELECT m.* FROM mos_menu AS m
WHERE menutype='cricket' AND published='1' AND access <= '0'
ORDER BY parent,ordering
34
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
35
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
36
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
37
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
38
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
39
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
40
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'