| | | |
2014 Photos |
Events Senior Prizegiving 20 September 2014
(36 Photos)
|
Juniors Highlights from the last weekend 30 August 2014
(31 Photos)
|
Juniors First Kicks 19 July 2014
(1 Photos)
|
Juniors 13th Grade Settlers v Island Bay 19 July 2014
(13 Photos)
|
Juniors 8th Grade Junior Football - 19 July 2014
(13 Photos)
|
Juniors Wynton Rufer Tournament (7th & 8th Grades) - 18 May 2014
(17 Photos)
|
Juniors Wynton Rufer Tournament (9th & 10th Grades) - 11 May 2014
(21 Photos)
|
Juniors Kapiti Junior Tournament (11th Grade) - 18 April 2014
(9 Photos)
|
Juniors Wellington Phoenix Junior Parade 12 April 2014
(4 Photos)
|
Central League Petone FC v Napier City Rovers 9 August 2014
(37 Photos)
|
Central League Petone FC v Upper Hutt 2 August 2014
(14 Photos)
|
Central League Petone FC v Miramar Rangers 27 July 2014
(26 Photos)
|
Central League Petone FC v Miramar Rangers 19 July 2014
(37 Photos)
|
Central League Petone FC v Palmerston Nth Marist 12 July 2014
(32 Photos)
|
Central League Petone FC v Wairarapa United 5 July 2014
(53 Photos)
|
Central League Petone FC v Tawa 22 June 2014
(71 Photos)
|
Central League Petone FC v Lower Hutt City 7 June 2014
(31 Photos)
|
Central League Petone FC v Napier City Rovers 31 May 2014
(38 Photos)
|
Central League Petone FC v Upper Hutt City 24 May 2014
(44 Photos)
|
Central League Petone FC v Western Suburbs 17 May 2014
(30 Photos)
|
Central League Petone FC v Palmerston Nth Marist 26 April 2014
(55 Photos)
|
Central League Petone FC v Wairarapa Utd 18 April 2014
(59 Photos)
|
Central League Petone FC v Olympic 12 April 2014
(61 Photos)
|
Central League Petone FC v Tawa 5 April 2014
(44 Photos)
|
Capital Premier Petone FC v Wellington United 8 August 2014
(19 Photos)
|
Capital Premier Petone FC v Olympic 21 July 2014
(22 Photos)
|
Capital Premier Petone FC v Waterside Karori 5 July 2014
(48 Photos)
|
Capital Premier Petone FC v Miramar Rangers 28 June 2014
(38 Photos)
|
Capital Premier Petone FC v Lower Hutt City 7 June 2014
(32 Photos)
|
Capital Premier Petone FC v Seatoun 24 May 2014
(31 Photos)
|
Capital Premier Petone FC v Island Bay Utd 3 May 2014
(61 Photos)
|
Capital Premier Petone FC v Stop Out 26 April 2014
(55 Photos)
|
Capital Premier Petone FC v Miramar Rangers 12 April 2014
(49 Photos)
|
Women's 1 Petone Pure v Tawa 3 August 2014
(36 Photos)
|
Women's 1 Petone Pure v North Wellington 6 July 2014
(11 Photos)
|
Women's 1 Petone Pure v Marist 25 May 2014
(31 Photos)
|
Women's 1 Petone Pure v Upper Hutt City 18 May 2014
(31 Photos)
|
Hilton Petone Div1 Olympic A v Island Bay Utd A 9 March 2014
(18 Photos)
|
Women's 1 Petone Pure v Western Suburbs 4 May 2014
(35 Photos)
|
Women's 1 Petone Pure v Brooklyn Northern Utd 21 April 2014
(22 Photos)
|
Women's 1 Petone Pure v Porirua City 6 April 2014
(49 Photos)
|
Women's 3 Petone Paulers v Brooklyn Northern Utd 18 May 2014
(20 Photos)
|
Chatham Cup Petone FC v Western Suburbs 10 May 2014
(35 Photos)
|
Capital 3 Petone Armanis v North Wellington 3 May 2014
(18 Photos)
|
Under 17s Petone A v Upper Hutt City 21 April 2014
(24 Photos)
|
Hilton Petone Div1 Final Stop Out v Olympic 30 March 2014
(46 Photos)
|
Hilton Petone Div2 Final Petone B v Lower Hutt B 31 March 2014
(39 Photos)
|
Hilton Petone Div1 Petone v Olympic 25 March 2014
(29 Photos)
|
Hilton Petone Div2 SF Petone B v Tawa B 23 March 2014
(25 Photos)
|
Hilton Petone Div2 QF Petone B v Olympic B 17 March 2014
(29 Photos)
|
Hilton Petone Div1 Petone v Seatoun 16 March 2014
(29 Photos)
|
Hilton Petone Div2 Petone B v North Wellington 10 March 2013
(30 Photos)
|
Hilton Petone Div2 Island Bay Utd B v Marist B 9 March 2014
(13 Photos)
|
Hilton Petone Div1 Waterside Karori v Marist A 9 March 2014
(18 Photos)
|
Hilton Petone Div1 Miramar v Stop Out A 9 March 2014
(20 Photos)
|
Hilton Petone Div2 Petone v Naenae 3 March 2014
(27 Photos)
|
Hilton Petone Div1 Petone v Island Bay 2 March 2014
(33 Photos)
|
Hilton Petone Div2 Petone v Stokes Valley 24 February 2014
(16 Photos)
|
Hilton Petone Div1 Petone v University 23 February 2014
(19 Photos)
|
Preseason Petone Pure v Wairarapa 30 March 2014
(17 Photos)
|
Preseason Petone Pure v Naenae 30 March 2014
(20 Photos)
|
Preseason Petone Pure v Western Suburbs 29 March 2014
(17 Photos)
|
Preseason Petone Pure v North Wellington 29 March 2014
(21 Photos)
|
Preseason Petone Pure v Stop Out 29 March 2014
(23 Photos)
|
Preseason Petone Pure v Upper Hutt 23 March 2014
(25 Photos)
|
Clubrooms Clubroom Painting 3 March 2013
(4 Photos)
|
| | | |
2013 Photos |
Petone FC U19s v Cashmere Technical 27 October 2013
(28 Photos)
|
Petone FC U19s v Albany United 27 October 2013
(25 Photos)
|
Petone FC U19s v Miramar Rangers 26 October 2013
(40 Photos)
|
Events Senior Prizegiving 31 August 2013
(54 Photos)
|
Central League Petone FC v Olympic 31 August 2013
(21 Photos)
|
Central League Petone FC v Western Suburbs 10 August 2013
(29 Photos)
|
Central League Petone FC v Wellington United 27 July 2013
(19 Photos)
|
Central League Petone FC v Tawa 13 July 2013
(26 Photos)
|
Central League Petone FC v Napier City Rovers 7 July 2013
(22 Photos)
|
Central League Petone FC v Miramar Rangers 22 June 2013
(18 Photos)
|
Central League Petone FC v Wairarapa United 8 June 2013
(16 Photos)
|
Central League Petone FC v Lower Hutt City 25 May 2013
(13 Photos)
|
Central League Petone FC v Upper Hutt City 4 May 2013
(18 Photos)
|
Capital Premier Petone FC v Olympic 24 August 2013
(10 Photos)
|
Capital Premier Petone FC v Wainuiomata 10 August 2013
(21 Photos)
|
Capital Premier Petone FC v Island Bay United 27 July 2013
(8 Photos)
|
Capital Premier Petone FC v Marist 22 June 2013
(13 Photos)
|
Capital Premier Petone FC v Waterside Karori 8 June 2013
(14 Photos)
|
Capital Premier Petone FC v Stop Out 25 May 2013
(13 Photos)
|
| | | |
Petone Memorial Artificial Photos |
Week 20 20 March 2013
(1 Photos)
|
Week 19 13 March 2013
(1 Photos)
|
Week 18 6 March 2013
(1 Photos)
|
Week 17 25 February 2013
(1 Photos)
|
Week 16 17 February 2013
(1 Photos)
|
Week 15 8 February 2013
(1 Photos)
|
Week 14 1 February 2013
(1 Photos)
|
Week 13 25 January 2013
(1 Photos)
|
Week 12 18 January 2013
(1 Photos)
|
Week 11 11 January 2013
(1 Photos)
|
Week 10 4 January 2013
(1 Photos)
|
Week 9 27 December 2012
(1 Photos)
|
Week 8 20 December 2012
(1 Photos)
|
Week 7 13 December 2012
(1 Photos)
|
Week 6 6 December 2012
(1 Photos)
|
Week 5 29 November 2012
(1 Photos)
|
Week 4 22 November 2012
(1 Photos)
|
Week 3 15 November 2012
(4 Photos)
|
Week 2 8 November 2012
(5 Photos)
|
Week 1 1 November 2012
(10 Photos)
|
| | | |
2012 Photos |
Horsie Night 9 June 2012
(7 Photos)
|
Capital Premier Petone FC v Stop Out 4 August 2012
(12 Photos)
|
Capital Premier Petone FC v Upper Hutt City 28 July 2012
(8 Photos)
|
Capital Premier Petone FC v Wellington United 9 June 2012
(12 Photos)
|
Capital Premier Petone FC v Marist 2 June 2012
(11 Photos)
|
Capital Premier Petone FC v Waterside Karori 21 April 2012
(5 Photos)
|
Capital Premier Petone FC v Wellington Olympic 15 April 2012
(20 Photos)
|
Central League Petone FC v Tawa 28 July 2012
(6 Photos)
|
Central League Petone FC v Wairarapa United 14 July 2012
(19 Photos)
|
Central League Petone FC v Napier City Rovers 30 June 2012
(18 Photos)
|
Central League Petone FC v Wellington Olympic 9 June 2012
(16 Photos)
|
Hilton Petone Div1 Final Olympic A v Tawa A 1 April 2012
(36 Photos)
|
Central League Petone FC v Wellington United 2 June 2012
(9 Photos)
|
Central League Petone FC v Lower Hutt City 26 May 2012
(13 Photos)
|
Central League Petone FC v Wellington Olympic 25 April 2012
(25 Photos)
|
Central League Petone FC v Miramar Rangers 21 April 2012
(34 Photos)
|
Capital 9 Dreamers v Waterside Karori 9 June 2012
(10 Photos)
|
Capital 9 Chuggers v Dreamers 12 May 2012
(14 Photos)
|
Chatham Cup Petone FC v Lower Hutt City 12 May 2012
(23 Photos)
|
Hilton Petone Div2 Final Nth Wgtn A v Petone B 1 April 2012
(61 Photos)
|
Hilton Petone Div1 Petone A v Stop Out A 26 February 2012
(26 Photos)
|
Hilton Petone Div2 Petone B v Stop Out B 26 February 2012
(22 Photos)
|
Hilton Petone Div2 Naenae v Tawa College 26 February 2012
(11 Photos)
|
Hilton Petone Div1 Petone A v Island Bay 19 February 2012
(27 Photos)
|
| | | |
2011 Photos |
Events Honours Board Night 2011
(58 Photos)
|
Central League Petone FC v Wairarapa United 3 September 2011
(38 Photos)
|
Central League Petone FC v Lower Hutt City 13 August 2011
(24 Photos)
|
Central League Petone FC v Napier City Rovers 7 August 2011
(14 Photos)
|
Central League Petone FC v Miramar Rangers 16 July 2011
(24 Photos)
|
Central League Petone FC v Wellington Olympic 11 June 2011
(33 Photos)
|
Central League Petone FC v Palmerston Nth Marist 4 June 2011
(26 Photos)
|
Central League Petone FC v Lower Hutt City 27 May 2011
(27 Photos)
|
Second Team v Island Bay United 2 July 2011
(16 Photos)
|
Armanis v Kapiti Coast United 2 July 2011
(20 Photos)
|
Capital 10 Stonecutters v Brooklyn Northern 2 July 2011
(24 Photos)
|
...
|
2 July 2014 |
|
Comms Team |
| Website Updates |
|
After a fair bit of trial and error we have found and fixed the issue with the photo gallery. It may take a few minutes to clear out the cobwebs for anyone that has tried to view the photos recently but if you reload the page it should be good to go....
|
4 March 2014 |
|
Jeff Bell |
| Club News |
|
Like every off-season there is still plenty of work being done behind the scenes to get the club ready for the winter months. There are sponsorship deals finalised, registration details sorted, coaches appointed, short and long term plans made, gear purchased, and many more things. All of this so we can play football as part of a good healthy club....
|
9 December 2013 |
|
Jeff Bell |
| Website Updates |
|
As we are sure you have noticed, last week we rolled out our brand new website design. Our goal is to make the Petone FC website cleaner and easier to use with more emphasis on the information you come here to see.
By starting from scratch with our design we have been able to iron out some of the bugs and quirks from our previous iterations ho...
Joomla! Debug Console
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
2.16 MB (2,263,552 Bytes)
40 Queries Logged
SELECT `data`
FROM `pfc2_session`
WHERE `session_id` = 'gc402kqqu3ogvl5c781cp8alk7'
DELETE
FROM `pfc2_session`
WHERE `time` < '1656627405'
SELECT `session_id`
FROM `pfc2_session`
WHERE `session_id` = 'gc402kqqu3ogvl5c781cp8alk7'
LIMIT 0, 1
INSERT INTO `pfc2_session`
(`session_id`, `client_id`, `time`)
VALUES
('gc402kqqu3ogvl5c781cp8alk7', 0, '1656628305')
SELECT extension_id AS id, element AS "option", params, enabled
FROM pfc2_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM pfc2_usergroups AS a
LEFT JOIN pfc2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `pfc2_viewlevels`
SELECT folder AS type, element AS name, params
FROM pfc2_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM pfc2_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
select id, title, alias
from pfc2_jumi
where published = 1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM pfc2_menu AS m
LEFT JOIN pfc2_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
INSERT INTO `pfc2_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
VALUES ('0','34.239.147.7','gc402kqqu3ogvl5c781cp8alk7','/search?term=gallery','')
SELECT extension_id AS id, element AS "option", params, enabled
FROM pfc2_extensions
WHERE `type` = 'component'
AND `element` = 'com_pfcsearch'
SELECT *
FROM pfc2_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM pfc2_template_styles as s
LEFT JOIN pfc2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT title, location, startdate, starttime, enddate, endtime, description, cost, image
FROM pfc2_event
WHERE title LIKE '%gallery%'
AND concat(enddate,' ',endtime) > '2022-07-01 10:31:45'
ORDER BY enddate, endtime
SELECT sq_logo, sponsor_name, street_address1, suburb1, city1, phone_number1, website, blurb
FROM pfc2_sponsor
WHERE (sponsor_name LIKE '%gallery%' OR blurb LIKE '%gallery%')
AND active = 'Y'
ORDER BY sponsor_name
SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav,
CASE
WHEN a.title = 'gallery' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 5
WHEN a.title LIKE '%gallery%' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 2
ELSE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*')
END AS score
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
WHERE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE)
AND a.state=1
AND c.published = 1
ORDER BY score DESC
LIMIT 0,10
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM pfc2_categories as c
LEFT JOIN pfc2_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM pfc2_categories AS cat JOIN pfc2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=87
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM pfc2_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM pfc2_categories as c
LEFT JOIN pfc2_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM pfc2_categories AS cat JOIN pfc2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=95
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM pfc2_categories as c
LEFT JOIN pfc2_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM pfc2_categories AS cat JOIN pfc2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=9
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
WHERE (a.title LIKE '%gallery%' OR a.introtext LIKE '%gallery%')
AND a.state=1
AND c.published = 1
ORDER BY created DESC
LIMIT 0,10
SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav,
CASE
WHEN a.title = 'gallery' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 5
WHEN a.title LIKE '%gallery%' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 2
ELSE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE)
END AS score
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
WHERE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE)
AND a.state=1
AND c.published = 1
ORDER BY score DESC
LIMIT 100
SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
WHERE (a.introtext LIKE '%gallery%' OR a.title LIKE '%gallery%')
AND a.state=1
AND c.published = 1
ORDER BY created DESC
LIMIT 100
SELECT sq_logo, sponsor_name, street_address1, suburb1, city1, phone_number1, website, blurb
FROM pfc2_sponsor
WHERE active = 'Y'
ORDER BY sponsor_name
SELECT title, location, startdate, starttime, enddate, endtime, description, cost, image
FROM pfc2_event
WHERE concat(enddate,' ',endtime) > '2022-07-01 10:31:45'
ORDER BY enddate, endtime
LIMIT 5
SELECT team, image, surname, firstname, dateofbirth, position, t.team_id, p.position_id, squadnumber, debut
FROM pfc2_headshot h
JOIN pfc2_headshot_position p
ON h.position_id = p.position_id
JOIN pfc2_headshot_teams t
ON h.team_id = t.team_id
WHERE active = 'Y'
and CONCAT(firstname, ' ', surname) LIKE '%gallery%'
ORDER BY position_id, surname, squadnumber
SELECT phrase
FROM pfc2_pfcsearchterm
WHERE active = 'Y'
ORDER BY phrase
SELECT alias
FROM pfc2_content
WHERE id=147
SELECT alias
FROM pfc2_content
WHERE id=148
SELECT alias
FROM pfc2_content
WHERE id=315
SELECT alias
FROM pfc2_content
WHERE id=253
SELECT alias
FROM pfc2_content
WHERE id=226
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pfc2_modules AS m
LEFT JOIN pfc2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pfc2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-06-30 22:31:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-06-30 22:31:45')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 525 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT phrase
FROM pfc2_pfcsearchterm
WHERE active = 'Y'
ORDER BY phrase
SELECT title, title2, location, startdate, starttime, enddate, endtime, description, cost
from pfc2_event
WHERE concat(enddate, ' ',endtime) > '2022-07-01 10:31:45'
ORDER BY startdate, starttime, enddate, endtime
LIMIT 5
SELECT image, website, sponsor_name
from pfc2_sponsor
ORDER BY RAND()
SELECT image, website, agency
from pfc2_funding
WHERE active = 'Y'
UPDATE `pfc2_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1656628305;s:18:\"session.timer.last\";i:1656628305;s:17:\"session.timer.now\";i:1656628305;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1656628308'
WHERE `session_id` = 'gc402kqqu3ogvl5c781cp8alk7'
28 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT alias
FROM pfc2_content
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM pfc2_extensions
3 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM pfc2_categories as c
LEFT JOIN pfc2_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM pfc2_categories AS cat JOIN pfc2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
2 × SELECT title, location, startdate, starttime, enddate, endtime, description, cost, image
FROM pfc2_event
2 × SELECT sq_logo, sponsor_name, street_address1, suburb1, city1, phone_number1, website, blurb
FROM pfc2_sponsor
1 × SELECT `session_id`
FROM `pfc2_session`
1 × SELECT phrase
FROM pfc2_pfcsearchterm
1 × SELECT team, image, surname, firstname, dateofbirth, position, t.team_id, p.position_id, squadnumber, debut
FROM pfc2_headshot h
JOIN pfc2_headshot_position p
ON h.position_id = p.position_id
JOIN pfc2_headshot_teams t
ON h.team_id = t.team_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pfc2_modules AS m
LEFT JOIN pfc2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pfc2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT phrase
FROM pfc2_pfcsearchterm
1 × SELECT image, website, agency
from pfc2_funding
1 × SELECT image, website, sponsor_name
from pfc2_sponsor
1 × SELECT title, title2, location, startdate, starttime, enddate, endtime, description, cost
from pfc2_event
1 × SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav,
CASE
WHEN a.title = 'gallery' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 5
WHEN a.title LIKE '%gallery%' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 2
ELSE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE)
END AS score
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
1 × SELECT b.id
FROM pfc2_usergroups AS a
LEFT JOIN pfc2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM pfc2_template_styles as s
LEFT JOIN pfc2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM pfc2_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM pfc2_menu AS m
LEFT JOIN pfc2_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM pfc2_extensions
1 × SELECT `data`
FROM `pfc2_session`
1 × SELECT id, rules
FROM `pfc2_viewlevels
1 × SELECT a.introtext, a.title AS title, a.metadesc, a.metakey, a.created AS created, u.name as created_by,
a.created_by_alias as created_by_alias, c.title as category, a.id as slug, c.id as catslug, 2 as browsernav,
CASE
WHEN a.title = 'gallery' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 5
WHEN a.title LIKE '%gallery%' THEN MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*' IN BOOLEAN MODE) + 2
ELSE MATCH(a.title,a.introtext,a.metakey) AGAINST('*gallery*')
END AS score
FROM pfc2_content AS a
INNER JOIN pfc2_categories AS c
ON c.id=a.catid
INNER JOIN pfc2_users AS u
ON u.id = a.created_by
1 × select id, title, alias
from pfc2_jumi
OTHER Tables:
1 × UPDATE `pfc2_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1656628305;s:18:\"session.timer.last\";i:1656628305;s:17:\"session.timer.now\";i:1656628305;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1656628308'
1 × INSERT INTO `pfc2_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
VALUES ('0','34.239.147.7','gc402kqqu3ogvl5c781cp8alk7','/search?term=gallery',''
1 × INSERT INTO `pfc2_session` (`session_id`, `client_id`, `time`)
VALUES ('gc402kqqu3ogvl5c781cp8alk7', 0, '1656628305'
1 × DELETE
FROM `pfc2_session`