AtuttoCalcio- Radio L'Aquila 1 / News

AtuttoCalcio- Radio L'Aquila 1

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.

22/05/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

20 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1

La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.

20/05/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

15 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.

15/05/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

13 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1

La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.

13/05/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

8 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.

08/05/2017
scritto da faro.
AtuttoCalcio- Radio L'Aquila 1

6 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1

La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.

06/05/2017
scritto da faro.
AtuttoCalcio- Radio L'Aquila 1

2 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.

02/05/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

29 aprile, ATC presenta le gare del week-end su Radio L'Aquila 1

La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.

29/04/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

24 aprile, ATC commenta le gare domenicali su Radio L'Aquila 1

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

24/04/2017
scritto da rjfusco.
AtuttoCalcio- Radio L'Aquila 1

8 aprile, ATC presenta le gare del week-end su Radio L'Aquila 1

La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.

08/04/2017
scritto da rjfusco.

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

execution time: 0.040 ms (0.14%)
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 (0.14%)
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 (0.10%)
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					854	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 (0.11%)
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.040 ms (0.16%)
returned rows: 61
explain
backtrace
to the top
close all

id	user	nome	cognome	stato
50	aspinetocalcio@virgilio.it	Pineto	Pineto	ADMIN
93	aspinetocalcio@virgilio.it	Pineto	Pineto	ADMIN
66	s.anna.calcio1@gmail.com	Sant'Anna	Sant'Anna	ADMIN
59	aa	test squadra	test squadra	ADMIN
60	afas	altro test	altro test	ADMIN
54	asdalbaadriaticacalcio@gmail.com	Alba Adriatica	Alba Adriatica	ADMIN
53	asdalbaadriaticacalcio@gmail.com	Alba Adriatica	Alba Adriatica	ADMIN
67	asdcesaprobacalcio@alice.it	Cesaproba Calcio	Cesaproba Calcio	ADMIN
70	asdtagliacozzo@libero.it	Tagliacozzo	Tagliacozzo	ADMIN
79	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
78	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
77	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
75	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
80	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
81	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
84	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
83	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
82	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
58	azlacastellina@tiscali.it	Miglianico	Miglianico	ADMIN
57	azlacastellina@tiscali.it	Miglianico	Miglianico	ADMIN

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	ALL					61	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 (0.14%)
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
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 = 12 AND b.related_type = 'category'
ORDER BY
a.date DESC
LIMIT
0,1

execution time: 0.000 ms (0.66%)
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

008

execution time: 0.000 ms (0.71%)
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					83	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

009

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 = 12 AND b.related_type = 'category'
ORDER BY
a.date DESC
LIMIT
0,10

execution time: 0.000 ms (0.52%)
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

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())
ORDER BY
a.is_default DESC, a.date DESC
LIMIT
0,10

execution time: 0.000 ms (0.59%)
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	a	ALL					83	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

011

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 (0.11%)
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

012

SELECT
news.id
FROM
ttc_news AS news
WHERE
news.published = 1 AND news.date <= '2019-08-21 01:44:26' AND news.categories_id = 12 ;

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

id
12269
12305
12333
12347
12366
12404
12448
12479
12512
12536
12571
12615
12636
12677
12706
12742
12792
12829
12857
12891

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	759
/var/www/clients/client1/web1/web/pages/news.php	countNews()	35
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

013

SELECT
*
FROM
ttc_news AS news
WHERE
news.published = 1 AND news.date <= '2019-08-21 01:44:26' AND news.categories_id = 12
ORDER BY
news.date DESC, news.id DESC
LIMIT
0,10

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

id	users_id	date	categories_id	title	abstract	text	img	sticky	published
14360	10	2017-05-22 16:38:00	12	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.	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	1495463983-87-atc-rl1-ok.jpg	1	1
14339	10	2017-05-20 11:05:00	12	20 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1	La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.	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 rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1. Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso.	1495271183-83-atc-rl1-ok.jpg	1	1
14313	10	2017-05-15 17:46:00	12	15 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.	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	1494863272-25-atc-rl1-ok.jpg	1	1
14286	10	2017-05-13 13:11:00	12	13 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1	La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.	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 rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1. Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso.	1494673917-89-atc-rl1-ok.jpg	1	1
14266	9	2017-05-08 18:35:00	12	8 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.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, 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	1494261374-47-rl1-atc.jpg	1	1
14269	9	2017-05-06 17:01:00	12	6 maggio, ATC presenta le gare del week-end su Radio L'Aquila 1	La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, Promozione girone A, Prima girone A, Prima girone C, Seconda girone A e Terza girone A nella nostra rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1. Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso.	1494324113-38-rl1-atc.jpg	1	1
14219	10	2017-05-02 16:28:00	12	2 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.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, 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	1493735429-11-atc-rl1-ok.jpg	1	1
14182	10	2017-04-29 11:40:00	12	29 aprile, ATC presenta le gare del week-end su Radio L'Aquila 1	La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, Promozione girone A, Prima girone A, Prima girone C, Seconda girone A e Terza girone A nella nostra rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1. Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso.	1493458905-atc-rl1-ok.jpg	1	1
14150	10	2017-04-24 14:33:00	12	24 aprile, ATC commenta le gare domenicali su Radio L'Aquila 1	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, 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	1493037315-5-atc-rl1-ok.jpg	1	1
14054	10	2017-04-08 12:55:00	12	8 aprile, ATC presenta le gare del week-end su Radio L'Aquila 1	La redazione di Atuttocalcio.tv presenta le gare ed i pronostici del week-end, categoria per categoria.	La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Eccellenza, Promozione girone A, Prima girone A, Prima girone C, Seconda girone A e Terza girone A nella nostra rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1. Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso.	1491648999-62-atc-rl1-ok.jpg	1	1

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	913
/var/www/clients/client1/web1/web/pages/news.php	getNews()	42
/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.040 ms (0.14%)
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					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

015

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

id	title	media	type
12479	clicca per ascoltare	1495273370-82-sabato-20052017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

016

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

id	title	media	type
12478	clicca per ascoltare	1494864224-21-lunedai-15052017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

017

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

id	title	media	type
12464	clicca per ascoltare	1494674242-64-sabato-13052017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

018

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

id	title	media	type
12462	Lunedi 08.05.2017	1494261517-41-lunedai-08052017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

019

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

id	title	media	type
12463	Sabato 6 maggio 2017	1494324267-02-tutto-calcio-sabato-6-maggio-2017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

020

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

id	title	media	type
12452	clicca per ascoltare	1493739093-87-martedai-02052017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

021

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

id	title	media	type
12254	clicca per ascoltare	1493460005-74-sabato-29042017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

022

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

id	title	media	type
12245	clicca per ascoltare	1493048327-6-lunedai-24042017-1.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

023

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

id	title	media	type
11848	clicca per ascoltare	1491649459-67-sabato-08042017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13292	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()	42
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

024

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 (0.10%)
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/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-list.php	include()	40
/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

025

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 (0.09%)
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/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-list.php	include()	40
/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

026

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.030 ms (0.10%)
returned rows: 1
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	8	34	1	4	4	2				334.9841685

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-list.php	include()	40
/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

027

SELECT
title
FROM
ttc_categories
WHERE
id = 12

execution time: 0.030 ms (0.10%)
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-list.php	include()	40
/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-list.php	include()	40
/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', 'cat' => '12-atuttocalcio-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&cat=12-atuttocalcio-radio-l-aquila-1',
'QUERY_STRING' => 'section=news&cat=12-atuttocalcio-radio-l-aquila-1',
'REQUEST_METHOD' => 'GET',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'REMOTE_PORT' => '33224',
'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' => '18.206.15.215',
'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' => 'Tue, 25 Jun 2019 02:18:36 UTC',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
'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' => 1566344666.223124,
'REQUEST_TIME' => 1566344666,
)

27! / 1