22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1 / AtuttoCalcio- Radio L'Aquila 1 / News

22/05/2017

scritto da rjfusco.

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Promozione girone A, Prima girone A, Prima girone C, Seconda girone A e Terza girone A nella nostra nuova rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1.

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

clicca per ascoltare — 26 gen 2018

clicca per ascoltare — 26 gen 2018

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

execution time: 0.030 ms (1.87%)
affected rows: 0
backtrace
to the top
close all

file	function	line
/var/www/clients/client1/web1/web/lib/zebra/Zebra_Database.php	query()	2773
/var/www/clients/client1/web1/web/config.php	set_charset()	32
/var/www/clients/client1/web1/web/index.php	require_once()	9

002

SELECT
*
FROM
ttc_menu
WHERE
published = 1 AND parent_id = 0
GROUP BY
page_name
ORDER BY
id, menu_name, page_order ;

execution time: 0.040 ms (2.50%)
returned rows: 12
explain
backtrace
to the top
close all

id	page_title	heading	menu_label	accesskey	css_selector	page_name	keywords	description	page_order	menu_name	published
1	Home	Home	Home	h	home	home	a tutto calcio, atuttocalcio, calcio, abruzzo, dilettanti, serie d, eccellenza, promozione, prima categoria, seconda categoria, terza categoria, statistiche, classifiche	A tutto calcio - Tutto il calcio a portata di click!	0	main	1
2	Serie d	Serie d	Serie d	d	serie-d	serie-d			1	main	1
3	Eccellenza	Eccellenza	Eccellenza	e	eccellenza	eccellenza			2	main	1
4	Promozione	Promozione	Promozione	p	promozione	promozione			3	main	1
5	Prima categoria	Prima categoria	Prima categoria	p	prima-categoria	prima-categoria			4	main	1
6	Seconda categoria	Seconda categoria	Seconda categoria	s	seconda-categoria	seconda-categoria			5	main	1
7	Terza categoria	Terza categoria	Terza categoria	t	terza-categoria	terza-categoria			6	main	1
8	Statistiche	Statistiche	Statistiche	g	statistiche	statistiche			7	main	1
9	Multimedia	Multimedia	Media	m	media	multimedia			8	main	1
11	Chi siamo	Chi siamo	Chi siamo	s	chi-siamo	chi-siamo			10	service	1
31	Contatti	Contatti	Contatti	c	contatti	contatti			11	service	1
32	Sondaggi	Sondaggi	Sondaggi	g	sondaggi	sondaggi			12	extra	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_menu	ALL					13	100.00	Using where; Using temporary; Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	43
/var/www/clients/client1/web1/web/inc/sections.inc.php	getSections()	4
/var/www/clients/client1/web1/web/index.php	require_once()	12

003

SELECT
DISTINCT categories_id
FROM
ttc_video
WHERE
published = 1

execution time: 0.030 ms (1.70%)
returned rows: 11
explain
backtrace
to the top
close all

categories_id
0
5
1
3
4
8
6
9
2
10
11

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_video	ALL					756	100.00	Using where; Using temporary

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1187
/var/www/clients/client1/web1/web/inc/localFunctions.php	getNotEmptyCategories()	1214
/var/www/clients/client1/web1/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web1/web/index.php	require_once()	12

004

SELECT
c.*
FROM
ttc_categories AS c
WHERE
1 = 1
ORDER BY
c.sort ASC ;

execution time: 0.030 ms (1.77%)
returned rows: 12
explain
backtrace
to the top
close all

id	title	sort	published
1	Serie D	1	1
2	Eccellenza	2	1
3	Promozione	3	1
4	Prima Categoria	4	1
5	Seconda Categoria	5	1
6	Terza Categoria	6	1
10	Altre categorie e Trofei	7	1
11	AreaMundial	8	1
12	AtuttoCalcio- Radio L'Aquila 1	9	0
13	5^Memorial M.Pavone-A.Mariani	10	0
9	La Lavagna del Tecnico	11	0
8	Seconda Divisione B	12	0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL					12	100.00	Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1223
/var/www/clients/client1/web1/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web1/web/index.php	require_once()	12

005

SELECT
u.id, u.user, u.nome, u.cognome, u.stato
FROM
ttc_users AS u
WHERE
1 = 1
ORDER BY
u.user ASC ;

execution time: 0.030 ms (1.87%)
returned rows: 10
explain
backtrace
to the top
close all

id	user	nome	cognome	stato
8	editor	editor	editor	EDITOR
9	faro	Roberto	Fallocco	EDITOR
23	fmichele	Francesco	Michele
28	fscamurra	Francesco	Scamurra
7	mrwolf	Administrator	User	ADMIN
42	Oscar	Stefano	Michele
13	pciammetti	Pasquale	Ciammetti	PROFILO3
43	ptrombetta	Pierluigi	Trombetta
35	Redazione	Redazione	Redazione
10	rjfusco			PROFILO2

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	ALL					10	100.00	Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1297
/var/www/clients/client1/web1/web/inc/sections.inc.php	getUsers()	13
/var/www/clients/client1/web1/web/index.php	require_once()	12

006

SELECT
*
FROM
ttc_menu
WHERE
page_name LIKE 'news'
LIMIT
1

execution time: 0.040 ms (2.34%)
returned rows: 1
explain
backtrace
to the top
close all

id	page_title	heading	menu_label	accesskey	css_selector	page_name	default_id	keywords	description	parent_id	page_order	menu_name	published
10	News	News	News	n	news	news	0			0	9	main	0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_menu	ALL					13	100.00	Using where

file	function	line
/var/www/clients/client1/web1/web/inc/page.inc.php	query()	21
/var/www/clients/client1/web1/web/inc/page.inc.php	getPage()	214
/var/www/clients/client1/web1/web/index.php	require_once()	18

007

SELECT
title, text, categories_id, img
FROM
ttc_news
WHERE
id = '14360'
LIMIT
1

execution time: 0.000 ms (6.17%)
returned rows: 1
explain
backtrace
to the top
close all

title

text

categories_id

img

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

1495463983-87-atc-rl1-ok.jpg

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_news	const	PRIMARY	PRIMARY	4	const	1	100.00

file	function	line
/var/www/clients/client1/web1/web/inc/page.inc.php	query()	287
/var/www/clients/client1/web1/web/index.php	require_once()	18

008

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'background' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW()) AND b.media_id = 14360 AND b.related_type = 'video'
ORDER BY
a.date DESC
LIMIT
0,1

execution time: 0.000 ms (11.50%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ref	unique_relation	unique_relation	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.b.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	561
/var/www/clients/client1/web1/web/pages/index.php	loadBanner()	34
/var/www/clients/client1/web1/web/index.php	include()	29

009

execution time: 0.000 ms (11.94%)
returned rows: 1
explain
backtrace
to the top
close all

id	date	date_to	title	dida	link	file	color	published	is_default	position
18	2014-07-19 00:16:00	0000-00-00 00:00:00	m- stadium mondiale			stadium - Copia.jpg		1	1	background

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					76	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	index		unique_relation	10		37	100.00	Using where; Using index; Using join buffer (flat, BNL join)

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web1/web/pages/index.php	loadBanner()	34
/var/www/clients/client1/web1/web/index.php	include()	29

010

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'banner720x90' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW()) AND b.media_id = 14360 AND b.related_type = 'video'
ORDER BY
a.date DESC
LIMIT
0,10

execution time: 0.000 ms (8.95%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ref	unique_relation	unique_relation	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.b.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	561
/var/www/clients/client1/web1/web/snippets/header.php	loadBanner()	11
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

011

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'banner720x90' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW())
ORDER BY
a.is_default DESC, a.date DESC
LIMIT
0,10

execution time: 0.000 ms (11.02%)
returned rows: 1
explain
backtrace
to the top
close all

id	date	date_to	title	dida	link	file	color	published	is_default	position
80	2017-10-06 13:00:00	2018-10-07 00:00:00	Campionato C5 - Area Sport -		http://www.areasportlaquila.it/campionato_c5.htm	Campionato C5.JPG		1	1	banner720x90

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					76	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	index		unique_relation	10		37	100.00	Using where; Using index; Using join buffer (flat, BNL join)

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web1/web/snippets/header.php	loadBanner()	11
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

012

SELECT
a.id, a.page_name, a.menu_label, a.accesskey, a.page_order, a.parent_id, a.default_id, b.page_name AS parent_name, c.page_name AS default_name
FROM
ttc_menu AS a
LEFT JOIN
ttc_menu AS b ON a.parent_id = b.id
LEFT JOIN
ttc_menu AS c ON a.default_id = c.id
WHERE
a.published = 1 AND a.menu_name = 'main'
ORDER BY
a.parent_id ASC, a.page_order ASC

execution time: 0.030 ms (1.92%)
returned rows: 9
explain
backtrace
to the top
close all

id	page_name	menu_label	accesskey	page_order
1	home	Home	h	0
2	serie-d	Serie d	d	1
3	eccellenza	Eccellenza	e	2
4	promozione	Promozione	p	3
5	prima-categoria	Prima categoria	p	4
6	seconda-categoria	Seconda categoria	s	5
7	terza-categoria	Terza categoria	t	6
8	statistiche	Statistiche	g	7
9	multimedia	Media	m	8

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					13	100.00	Using where; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.a.parent_id	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.a.default_id	1	100.00	Using where

file	function	line
/var/www/clients/client1/web1/web/inc/nav-main.inc.php	query()	24
/var/www/clients/client1/web1/web/snippets/header.php	include()	13
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

013

SELECT
*
FROM
ttc_news AS news
WHERE
news.published = 1 AND news.date <= '2018-08-16 16:25:00' AND news.id IN ('14360')

execution time: 0.000 ms (6.18%)
returned rows: 1
explain
backtrace
to the top
close all

users_id

date

categories_id

title

abstract

text

external

dida

img

codice

sticky

published

14360

2017-05-22 16:38:00

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria.

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

1495463983-87-atc-rl1-ok.jpg

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news	const	PRIMARY	PRIMARY	4	const	1	100.00

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	913
/var/www/clients/client1/web1/web/pages/news.php	getNews()	7
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

014

SELECT
media.id, media.title, media.media, media.type
FROM
ttc_news_media AS news_media
LEFT JOIN
ttc_media AS media ON media.id = news_media.media_id
WHERE
media.type IN ('image','file','audio','Immagini','allegati') AND media.published = 1 AND news_media.news_id = 14360
ORDER BY
media.sort ASC

execution time: 0.030 ms (1.82%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	media	type
12531	clicca per ascoltare	1495553089-95-lunedai-22-05-2017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13082	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	media	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.news_media.media_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	964
/var/www/clients/client1/web1/web/pages/news.php	getNews()	7
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

015

SELECT
video.id, video.title, video.img, video.categories_id, video.date, video.updated_at, video.published_at, video.abstract, video.file
FROM
ttc_video AS video, ttc_media_related AS media
WHERE
media.related_id = video.id AND video.published = 1 AND media.media_id = 14360 AND media_type LIKE 'news' AND categories_id IN (1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 9, 8, 0) AND related_type LIKE 'video'
ORDER BY
media.id ASC
LIMIT
0,10

execution time: 0.000 ms (9.54%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	media	ref	unique_relation	unique_relation	4	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	video	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	625
/var/www/clients/client1/web1/web/pages/news.php	getRelatedVideos()	8
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

016

SELECT
news.id, news.title, news.img, news.categories_id, news.date, news.abstract
FROM
ttc_news AS news, ttc_media_related AS media
WHERE
media.related_id = news.id AND news.published = 1 AND media.media_id = 14360 AND media_type LIKE 'news' AND news.categories_id IN (1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 9, 8, 0) AND related_type LIKE 'news'
ORDER BY
media.id ASC
LIMIT
0,10

execution time: 0.000 ms (8.37%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	media	ref	unique_relation	unique_relation	4	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	news	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	698
/var/www/clients/client1/web1/web/pages/news.php	getRelatedNews()	9
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

017

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT
*
FROM
ttc_seasons
WHERE
published = 1
ORDER BY
start_date DESC
LIMIT
0,1

execution time: 0.060 ms (3.20%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
6	2017/2018	2017-08-14	2018-07-31	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_seasons	ALL					6	100.00	Using where; Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1361
/var/www/clients/client1/web1/web/inc/localFunctions.php	getSeasons()	1373
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getLastSeason()	13
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

018

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT
*
FROM
ttc_seasons
WHERE
published = 1
ORDER BY
start_date DESC
LIMIT
0,1

execution time: 0.030 ms (1.65%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
6	2017/2018	2017-08-14	2018-07-31	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_seasons	ALL					6	100.00	Using where; Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1361
/var/www/clients/client1/web1/web/inc/localFunctions.php	getSeasons()	1373
/var/www/clients/client1/web1/web/inc/localFunctions.php	getLastSeason()	1411
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getCompetitions()	19
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

019

SELECT
*
FROM
ttc_competitions
LEFT JOIN
ttc_competitions_meta on id = competitions_id
WHERE
published = 1 AND seasons_id = 6
ORDER BY
sort ASC

execution time: 0.030 ms (1.97%)
returned rows: 10
explain
backtrace
to the top
close all

id	title	division	sort	published	competitions_id	seasons_id	rounds_number	promosse	playoff	playout	retrocesse	notes	playoff_notes	playout_notes	phone
1	Serie D	F	0	1	1	6	34	1	4	2	3		Vince il Campionato la Vis Pesaro, con 73 punti.	Retrocesse: Monticelli, Fabriano Cerreto, Nerostellati
2	Eccellenza		1	1	2	6	34	1	4	4	1
3	Promozione	A	2	1	3	6	34	1	1	4	1	Virtus Teramo promossa in Eccellenza. Pontevomano direttamente in finale Play off.		Retrocedono in Prima Categoria Alba Montaurei e Sant'Omero	3922488452
4	Promozione	B	3	1	4	6	34	1	4	4	1		Casalbordino - Ortona (1 - 0): 82' Luciano Galiè Val di Sangro - Casalbordino (3 - 2): 4' Cesario (C), 8' Di Leo (VDS), 22' D'Orazio (VDS), 76' Letto (C), 87' Bucceroni (VDS).	Castiglione Valfino - Sportland Celano (1 - 2): 10' Mancini (SC), 30' Mergiotti (CV), 44' Mancini (SC) Fater Angelini Abruzzo - Virtus Pratola Calcio (2 - 0): 5' De Simone, 85' Fusco
5	Prima Categoria	A	4	1	5	6	30	1	4	0	3	Vallelonga, Valle Aterno Fossa e G.S. Pizzoli retrocesse in Seconda Categoria.
21	Prima Categoria	C	5	1	21	6	30	1	3	2	2	Pescina Calcio 1950 e Roseto 1920 retrocedono in Seconda Categoria.	S.Anna qualificata direttamente alla finale di girone	Retrocede anche la Pol. Morronese.
8	Seconda Categoria	A	6	1	8	6	30	1	4	4	1		Ornano promosso in prima categoria. Tempo regolamentare terminato 1-1	Partita terminata 1-1 dopo i tempi supplementari. in virtù della miglior posizione in classifica il Pianola guadagna la salvezza. Retrocesso in terza categoria l’Atletico Amiternum.
16	Seconda Categoria	B	7	1	16	6	26	1	4	4	1
9	Terza Categoria	A	8	1	9	6	22	1	4	0	0
10	Terza Categoria	B	9	1	10	6	22	1	3	0	0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_competitions	ALL	PRIMARY				15	100.00	Using where; Using filesort
1	SIMPLE	ttc_competitions_meta	eq_ref	unique_competitions_id_seasons_id	unique_competitions_id_seasons_id	8	c1_atuttocalcio_db.ttc_competitions.id,const	1	100.00	Using index condition

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1423
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getCompetitions()	19
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

020

SELECT
title
FROM
ttc_categories
WHERE
id = 12

execution time: 0.020 ms (1.50%)
returned rows: 1
explain
backtrace
to the top
close all

title
AtuttoCalcio- Radio L'Aquila 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_categories	const	PRIMARY	PRIMARY	4	const	1	100.00

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1898
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

001

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Aquila 1%' ORDER BY title ASC LIMIT 1' at line 3

SELECT
id
FROM
ttc_competitions
WHERE
title LIKE '%AtuttoCalcio- Radio L'Aquila 1%'
ORDER BY
title ASC
LIMIT
1

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1907
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

001	The "memcache" extension is available on you server - consider using memcache for caching query results. See the documentation for more information. to the top close all

001	$_POST array ( )

001	$_GET array ( 'section' => 'news', 'id' => '14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1', )

001	$_SESSION array ( 'lang' => 'it', )

001	$_FILES array ( )

001

$_SERVER

array (
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',
'TEMP' => '/var/www/clients/client1/web1/tmp',
'TMPDIR' => '/var/www/clients/client1/web1/tmp',
'TMP' => '/var/www/clients/client1/web1/tmp',
'HOSTNAME' => '',
'USER' => 'web1',
'HOME' => '/var/www/clients/client1/web1',
'SCRIPT_NAME' => '/index.php',
'REQUEST_URI' => '/index.php?section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'QUERY_STRING' => 'section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'REQUEST_METHOD' => 'GET',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'REMOTE_PORT' => '32866',
'SCRIPT_FILENAME' => '/var/www/clients/client1/web1/web/index.php',
'SERVER_ADMIN' => 'webmaster@atuttocalcio.tv',
'CONTEXT_DOCUMENT_ROOT' => '/var/www/clients/client1/web1/web',
'CONTEXT_PREFIX' => '',
'REQUEST_SCHEME' => 'http',
'DOCUMENT_ROOT' => '/var/www/clients/client1/web1/web',
'REMOTE_ADDR' => '54.225.38.2',
'SERVER_PORT' => '80',
'SERVER_ADDR' => '51.255.216.2',
'SERVER_NAME' => 'atuttocalcio.tv',
'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)',
'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at atuttocalcio.tv Port 80</address>
',
'HTTP_ACCEPT_ENCODING' => 'gzip',
'HTTP_CONNECTION' => 'Keep-Alive',
'HTTP_HOST' => 'atuttocalcio.tv',
'HTTP_IF_MODIFIED_SINCE' => 'Sat, 23 Jun 2018 13:56:48 GMT',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'proxy-nokeepalive' => '1',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1534429500.28023,
'REQUEST_TIME' => 1534429500,
)

20! / 1