City

Luetuimmat


					SELECT SQL_CALC_FOUND_ROWS
						*
					FROM (
							(
								SELECT
									'ARTICLE' AS parent_type,
									`a`.`id_article` AS parent_id,
									a.id_user,
									a.id_article,
									NULL AS id_entry,
									NULL AS id_blog,
									a.area,
									a.type_review,
									a.title,
									a.ingress AS description,
									a.text,
									NULL AS music,
									a.id_default_image,
									a.published AS time,
									IF(priority <= 2, 'PANORAMA', IF(priority <= 5, 'LARGE', 'SMALL')) AS size,
									(
										SELECT
											SUM(hits)
										FROM
											`city`.`hits_daily`
										WHERE
											`parent_type` = 'ARTICLE'
											AND `parent_id` = `a`.`id_article`
											AND `date` >= DATE_SUB(CURDATE(), INTERVAL 3 DAY)
									) AS hits
								FROM
									`city`.`articles` AS a
								WHERE
									`a`.`visible` = true AND `a`.`published` < NOW()
							)

						UNION ALL

							(
								SELECT
									'BLOG' AS parent_type,
									`e`.`id_entry` AS parent_id,
									e.id_user,
									NULL AS id_article,
									e.id_entry,
									e.id_blog,
									s.area,
									NULL AS type_review,
									e.title,
									e.text AS description,
									e.text,
									e.music,
									NULL AS id_default_image,
									e.published AS time,
									NULL AS size,
									(
										SELECT
											SUM(hits)
										FROM
											`city`.`hits_daily`
										WHERE
											`parent_type` = 'BLOG'
											AND `parent_id` = `e`.`id_entry`
											AND `date` >= DATE_SUB(CURDATE(), INTERVAL 3 DAY)
									) AS hits
								FROM
									`city`.`blogs` AS b,
									`city`.`blog_entries` AS e,
									`city`.`blog_settings` AS s
								WHERE
									`e`.`status` = 'PUBLISHED'  AND `e`.`published` < NOW() AND
									`s`.`editorial` = 1
								AND
									`b`.`id_blog` = `s`.`id_blog`
								AND
									`e`.`id_blog` = `s`.`id_blog`
							)
						) AS articles

					ORDER BY
						`hits` DESC
					LIMIT 5

1.9988 s

SELECT FOUND_ROWS()

0.0004 s

50 jäätävintä iskulausetta
Kirkastettu voi tekee blinistä syntisen hyvän talviherkun – Blinikausi on nyt kuumimmillaan
Konepajalle uusi hotelli – The Folks Hotel Konepaja avaa 2020 kesällä
Suomipopin 99 suurinta
Helsingin uudet ravintolat 2018: Loppuvuosi on täynnä kiinnostavia ravintolauutuuksia

Kommentoiduimmat


					SELECT SQL_CALC_FOUND_ROWS
						*
					FROM (
							(
								SELECT
									'ARTICLE' AS parent_type,
									`a`.`id_article` AS parent_id,
									a.id_user,
									a.id_article,
									NULL AS id_entry,
									NULL AS id_blog,
									a.area,
									a.type_review,
									a.title,
									a.ingress AS description,
									a.text,
									NULL AS music,
									a.id_default_image,
									a.published AS time,
									IF(priority <= 2, 'PANORAMA', IF(priority <= 5, 'LARGE', 'SMALL')) AS size,
									(
										SELECT
											COUNT(*)
										FROM
											`city`.`comments`
										WHERE
											`parent_type` = 'ARTICLE'
											AND `parent_id` = `a`.`id_article`
											AND	`status` = 'PUBLISHED'
									) AS comments
								FROM
									`city`.`articles` AS a
								WHERE
									`a`.`published` > '2019-01-18 14:02:08'
									
									AND `a`.`visible` = true AND `a`.`published` < NOW()
							)

						UNION ALL

							(
								SELECT
									'BLOG' AS parent_type,
									`e`.`id_entry` AS parent_id,
									e.id_user,
									NULL AS id_article,
									e.id_entry,
									e.id_blog,
									s.area,
									NULL AS type_review,
									e.title,
									e.text AS description,
									e.text,
									e.music,
									NULL AS id_default_image,
									e.published AS time,
									NULL AS size,
									(
										SELECT
											COUNT(*)
										FROM
											`city`.`comments`
										WHERE
											`parent_type` = 'BLOG'
											AND `parent_id` = `e`.`id_entry`
											AND	`status` = 'PUBLISHED'
									) AS comments
								FROM
									`city`.`blogs` AS b,
									`city`.`blog_settings` AS s,
									`city`.`blog_entries` AS e
								WHERE
									`s`.`editorial` = 1
									
									AND `e`.`status` = 'PUBLISHED'  AND `e`.`published` < NOW()
								AND
									`e`.`published` > '2019-01-18 14:02:08'
								AND
									`s`.`id_blog` = `e`.`id_blog`
								AND
									`b`.`id_blog` = `e`.`id_blog`
							)
						) AS articles

					ORDER BY
						`comments` DESC
					LIMIT 5

0.0056 s

SELECT FOUND_ROWS()

0.0002 s

Casa Italia yhdistää italialaisen delin ja viinibaarin – Bulevardilta tuttu herkkukauppa on nyt myös Töölössä
Bali Brunch tuo Indonesian herkut myös Kamppiin
Hoitajamitoitus ei takaa vanhuspalveluiden laatua, päinvastoin
Bitesin messeviä burgereita saa vihdoin Kampista – Mukana myös SYÖ!-viikoilla
Rasvaisesta metallipajasta ravintolaskenen kestosuosikiksi – BasBasin menestyksen resepti on yksinkertainen: “Tässä ei ole keksitty mitään uudestaan”