|
Helping Newham residents secure rewarding careers as Police Community Support Officers
A version of our MPS Pre-Employment Course exclusively able to residents of the London Borough of Newham and delivered at a Newham Communtiy Centre.
To find out more, call the MPS Recruitment Team on 020 7263 1144 quoting MPS Newham, or email [email protected].
|
|
|
|
(C) 2008 Kennedy Scott
44 queries executed1
SELECT folder, element, published, params
FROM mos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering
2
SELECT `id`,`link` FROM mos_menu WHERE ((`name` LIKE '%ks provisions%') AND (`published` > 0))
3
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl = 'ks-provisions/mps-newham.html' LIMIT 1
4
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&task;=view&id;=115&Itemid;=73'
5
SELECT template
FROM mos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 73 )
ORDER BY menuid DESC
LIMIT 0, 1
6
DELETE FROM mos_session
WHERE (
( time < '1205518125' )
AND guest = 0
AND gid > 0
) OR (
( time < '1205518125' )
AND guest = 1
AND userid = 0
)
7
SELECT *
FROM mos_session
WHERE session_id = '63485c0961409e51c9313fb51649b26b'
8
UPDATE mos_session SET `time`='1205519025',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='63485c0961409e51c9313fb51649b26b'
9
SELECT *
FROM mos_menu
WHERE id = 73
10
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
s.id AS sec_id, cc.id as cat_id
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope = 'content'
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.id = 115 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-03-14 19:23' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-03-14 19:23' )
AND a.access <= 0
11
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 102
AND a.state = 1
AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-03-14 19:23' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-03-14 19:23' )
ORDER BY a.ordering
12
UPDATE mos_content
SET hits = ( hits + 1 )
WHERE id = '115'
13
SELECT folder, element, published, params
FROM mos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering
14
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=60&Itemid;=73'
15
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=60&Itemid;=73'
16
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=69&Itemid;=73'
17
SELECT a.*
FROM mos_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'
18
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m
INNER JOIN mos_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 OR mm.menuid = '73' )
ORDER BY ordering
19
SELECT id, name, link, parent, type, menutype, access
FROM mos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering
20
SELECT title, catid, id
FROM mos_content
WHERE id = 115
AND access <= 0
21
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogcategory&id;=102&Itemid;=73'
22
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=20&Itemid;=49'
23
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
FROM mos_content AS a
INNER JOIN mos_categories AS cc ON cc.id = a.catid
INNER JOIN mos_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-03-14 19:23' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-03-14 19:23' )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
24
SELECT m.*
FROM mos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering
25
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid;=112'
26
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=20&Itemid;=49'
27
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogcategory&id;=102&Itemid;=73'
28
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=4&Itemid;=58'
29
SELECT COUNT( id )
FROM mos_menu
WHERE type = 'content_typed'
AND published = 1
30
SELECT id
FROM mos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task;=view&id;=87'
31
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=87&Itemid;=85'
32
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=21&Itemid;=48'
33
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=13&Itemid;=42'
34
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=24&Itemid;=55'
35
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=115&Itemid;=73'
36
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=login'
37
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=lostPassword'
38
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=registers'
39
SELECT m.*
FROM mos_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering
40
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogsection&id;=9&Itemid;=100'
41
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=22&Itemid;=50'
42
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogcategory&id;=103&Itemid;=74'
43
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=4&Itemid;=67'
44
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=category§ionid;=10&id;=123&Itemid;=108'