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 Jan 2018

clicca per ascoltare — 26 Jan 2018

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

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

file	function	line
/var/www/clients/client1/web28/web/lib/zebra/Zebra_Database.php	query()	2773
/var/www/clients/client1/web28/web/config.php	set_charset()	32
/var/www/clients/client1/web28/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.076 ms (3.15%)
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/web28/web/inc/localFunctions.php	query()	43
/var/www/clients/client1/web28/web/inc/sections.inc.php	getSections()	4
/var/www/clients/client1/web28/web/index.php	require_once()	12

003

SELECT
DISTINCT categories_id
FROM
ttc_video
WHERE
published = 1

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

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

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

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	1187
/var/www/clients/client1/web28/web/inc/localFunctions.php	getNotEmptyCategories()	1214
/var/www/clients/client1/web28/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web28/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.054 ms (2.24%)
returned rows: 13
explain
backtrace
to the top
close all

id	title	sort	published
18	Lunedì ATuttoCalcio	0	1
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					13	100.00	Using filesort

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	1223
/var/www/clients/client1/web28/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web28/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.094 ms (3.89%)
returned rows: 11
explain
backtrace
to the top
close all

id	user	nome	cognome	stato
109	benedetta	Benedetta	Santarelli
8	editor	editor	editor	EDITOR
9	faro	Roberto	Fallocco	EDITOR
23	fmichele	Francesco	Michele
28	fscamurra	Francesco	Scamurra
42	laqtv	Luca	Bergamotto
7	mrwolf	Administrator	User	ADMIN
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					11	100.00	Using filesort

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

006

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

execution time: 0.057 ms (2.37%)
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/web28/web/inc/page.inc.php	query()	21
/var/www/clients/client1/web28/web/inc/page.inc.php	getPage()	214
/var/www/clients/client1/web28/web/index.php	require_once()	17

007

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

execution time: 0.049 ms (2.02%)
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/web28/web/inc/page.inc.php	query()	287
/var/www/clients/client1/web28/web/index.php	require_once()	17

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.370 ms (15.32%)
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.b.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	561
/var/www/clients/client1/web28/web/pages/index.php	loadBanner()	12
/var/www/clients/client1/web28/web/index.php	include()	28

009

execution time: 0.327 ms (13.53%)
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					90	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/web28/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web28/web/pages/index.php	loadBanner()	12
/var/www/clients/client1/web28/web/index.php	include()	28

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.230 ms (9.53%)
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.b.related_id	1	100.00	Using index condition; Using where

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

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.339 ms (14.04%)
returned rows: 3
explain
backtrace
to the top
close all

id	date	date_to	title	dida	link	file	published	is_default	position
121	2020-02-09 00:00:00	2020-07-31 21:00:00	Linea Arredo	Linea Arredo, progettazione, arredamento industriale e ristorazione	http://www.linearredosrl.it/	Vettoriale linea arredo-2.jpg	1	1	banner720x90
97	2019-09-06 08:00:00	2020-07-01 08:00:00	Jolly Graph		https://www.facebook.com/jollygraph/	jolly graph - Copia.jpg	1	1	banner720x90
101	2019-09-03 08:00:00	2020-07-01 08:00:00	Dott. Luigi Fantauzzi	Dott. Luigi Fantauzzi	http://www.implantologiadentalelaquila.it/	banner-fantauzzi.jpg	1	1	banner720x90

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					90	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/web28/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web28/web/snippets/header.php	loadBanner()	11
/var/www/clients/client1/web28/web/pages/index.php	include()	24
/var/www/clients/client1/web28/web/index.php	include()	28

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.069 ms (2.85%)
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.a.parent_id	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio.a.default_id	1	100.00	Using where

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

013

SELECT
*
FROM
ttc_news AS news
WHERE
news.published = 1 AND news.date <= '2020-05-31 19:52:57' AND news.id IN ('14360')

execution time: 0.162 ms (6.71%)
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/web28/web/inc/localFunctions.php	query()	913
/var/www/clients/client1/web28/web/pages/news.php	getNews()	7
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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.050 ms (2.07%)
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					13471	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	media	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio.news_media.media_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	964
/var/www/clients/client1/web28/web/pages/news.php	getNews()	7
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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 (18, 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.048 ms (1.98%)
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.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	625
/var/www/clients/client1/web28/web/pages/news.php	getRelatedVideos()	8
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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 (18, 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.045 ms (1.87%)
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.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	698
/var/www/clients/client1/web28/web/pages/news.php	getRelatedNews()	9
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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.115 ms (4.77%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
8	2019/2020	2019-07-01	2020-06-30	1

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

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

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.045 ms (1.86%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
8	2019/2020	2019-07-01	2020-06-30	1

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

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

019

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

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

id	title	division	sort	published	competitions_id	seasons_id	rounds_number	promosse	playoff	playout	retrocesse	notes	phone
1	Serie D	F	0	1	1	8	34	1	4	4	2		334.9841685
2	Eccellenza		1	1	2	8	34	1	4	4	1
3	Promozione	A	2	1	3	8	34	1	4	4	1
4	Promozione	B	3	1	4	8	34	1	4	4	1
5	Prima Categoria	A	4	1	5	8	26	1	4	4	1
8	Seconda Categoria	A	6	1	8	8	26	1	4	4	1
16	Seconda Categoria	D	7	1	16	8	26	1	4	4	1
9	Terza Categoria	A	8	1	9	8	26	1	4	0	0	La società ACQUILIS CALCIO si è definitivamente ritirata dal campionato alla vigilia della 12^ giornata di campionato.
10	Terza Categoria	B	9	1	10	8	22	1	4	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.ttc_competitions.id,const	1	100.00	Using index condition

file	function	line
/var/www/clients/client1/web28/web/inc/localFunctions.php	query()	1423
/var/www/clients/client1/web28/web/sidebars/main-sidebar.php	getCompetitions()	19
/var/www/clients/client1/web28/web/views/news-single.php	include()	73
/var/www/clients/client1/web28/web/pages/news.php	include()	45
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

020

SELECT
title
FROM
ttc_categories
WHERE
id = 12

execution time: 0.040 ms (1.66%)
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/web28/web/inc/localFunctions.php	query()	1898
/var/www/clients/client1/web28/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web28/web/views/news-single.php	include()	73
/var/www/clients/client1/web28/web/pages/news.php	include()	45
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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/web28/web/inc/localFunctions.php	query()	1907
/var/www/clients/client1/web28/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web28/web/views/news-single.php	include()	73
/var/www/clients/client1/web28/web/pages/news.php	include()	45
/var/www/clients/client1/web28/web/pages/index.php	include()	30
/var/www/clients/client1/web28/web/index.php	include()	28

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/web28/tmp',
'TMPDIR' => '/var/www/clients/client1/web28/tmp',
'TMP' => '/var/www/clients/client1/web28/tmp',
'HOSTNAME' => '',
'USER' => 'web28',
'HOME' => '/var/www/clients/client0/web28',
'FCGI_ROLE' => 'RESPONDER',
'QUERY_STRING' => 'section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'REQUEST_METHOD' => 'GET',
'CONTENT_TYPE' => '',
'CONTENT_LENGTH' => '',
'SCRIPT_NAME' => '/index.php',
'REQUEST_URI' => '/index.php?section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'DOCUMENT_URI' => '/index.php',
'DOCUMENT_ROOT' => '/var/www/atuttocalcio.tv/web',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_SCHEME' => 'http',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'SERVER_SOFTWARE' => 'nginx/1.14.2',
'REMOTE_ADDR' => '18.204.227.117',
'REMOTE_PORT' => '60516',
'SERVER_ADDR' => '51.75.175.32',
'SERVER_PORT' => '80',
'SERVER_NAME' => 'atuttocalcio.tv',
'REDIRECT_STATUS' => '200',
'SCRIPT_FILENAME' => '/var/www/atuttocalcio.tv/web/index.php',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
'HTTP_IF_MODIFIED_SINCE' => 'Thu, 02 Apr 2020 04:35:01 UTC',
'HTTP_ACCEPT_ENCODING' => 'br,gzip',
'HTTP_HOST' => 'atuttocalcio.tv',
'HTTP_CONNECTION' => 'Keep-Alive',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1590947577.814214,
'REQUEST_TIME' => 1590947577,
)

20! / 1