Skip to content

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
LOL Query from centurion keywords
SELECT DISTINCT `mediacenter_media`.*
FROM `mediacenter_media`
WHERE ( `mediacenter_media`.`id` IN ((SELECT `mediacenter_media`.`id`
FROM `mediacenter_media`
INNER JOIN `media_file`
ON `media_file`.`id` =
`mediacenter_media`.`media_id`
LEFT JOIN `media_tag_file`
ON `media_tag_file`.`file_id` =
`media_file`.`id`
LEFT JOIN `media_tag`
ON media_tag_file.`tag_id` =
`media_tag`.`id`
LEFT JOIN `mediacenter_media` AS
`mediacenter_media_2`
ON
`mediacenter_media_2`.`media_id`
= `media_file`.`id`
LEFT JOIN `mediacenter_media` AS
`mediacenter_media_3`
ON
`mediacenter_media_3`.`media_id`
= `media_file`.`id`
LEFT JOIN `community_topic`
ON `community_topic`.`media_id` =
`media_file`.`id`
LEFT JOIN `news_news`
ON `news_news`.`cover_id` =
`media_file`.`id`
LEFT JOIN `bidule_company`
ON `bidule_company`.`logo_id` =
`media_file`.`id`
LEFT JOIN `bidule_game`
ON `bidule_game`.`logo_id` =
`media_file`.`id`
LEFT JOIN `bidule_rating`
ON `bidule_rating`.`image_id` =
`media_file`.`id`
LEFT JOIN `bidule_platform`
ON `bidule_platform`.`logo_id` =
`media_file`.`id`
LEFT JOIN `bidule_family`
ON `bidule_family`.`cover_id` =
`media_file`.`id`
LEFT JOIN `bidule_brand`
ON `bidule_brand`.`cover_id` =
`media_file`.`id`
LEFT JOIN `cms_flatpage`
ON `cms_flatpage`.`cover_id` =
`media_file`.`id`
LEFT JOIN `mediacenter_media` AS
`mediacenter_media_4`
ON
`mediacenter_media_4`.`media_id`
= `media_file`.`id`
LEFT JOIN `mediacenter_media` AS
`mediacenter_media_5`
ON
`mediacenter_media_5`.`media_id`
= `media_file`.`id`
WHERE ( `mediacenter_media`.`title` LIKE '%my%'
)
OR ( `media_file`.`name` LIKE '%my%' )
OR ( `media_file`.`filename` LIKE '%my%'
)
OR ( `media_tag`.`name` LIKE '%my%' )
OR ( `mediacenter_media_2`.`title` LIKE
'%my%' )
OR ( `mediacenter_media_3`.`slug` LIKE
'%my%' )
OR ( community_topic.`title` LIKE '%my%'
)
OR ( community_topic.`slug` LIKE '%my%'
)
OR ( news_news.`title` LIKE '%my%' )
OR ( news_news.`slug` LIKE '%my%' )
OR ( bidule_company.`name` LIKE '%my%' )
OR ( bidule_company.`slug` LIKE '%my%' )
OR ( bidule_game.`title` LIKE '%my%' )
OR ( bidule_game.`slug` LIKE '%my%' )
OR ( bidule_rating.`name` LIKE '%my%' )
OR ( bidule_rating.`slug` LIKE '%my%' )
OR ( bidule_platform.`name` LIKE '%my%' )
OR ( bidule_platform.`slug` LIKE '%my%' )
OR ( bidule_family.`name` LIKE '%my%' )
OR ( bidule_family.`slug` LIKE '%my%' )
OR ( bidule_brand.`name` LIKE '%my%' )
OR ( bidule_brand.`slug` LIKE '%my%' )
OR ( cms_flatpage.`title` LIKE '%my%' )
OR ( cms_flatpage.`slug` LIKE '%my%' )
OR (
`mediacenter_media`.`title` LIKE '%game%' )
OR ( `media_file`.`name` LIKE '%game%' )
OR (
`media_file`.`filename` LIKE '%game%'
)
OR ( `media_tag`.`name` LIKE '%game%' )
OR ( `mediacenter_media_4`.`title` LIKE
'%game%' )
OR ( `mediacenter_media_5`.`slug` LIKE
'%game%' )
OR (
community_topic.`title` LIKE '%game%'
)
OR (
community_topic.`slug` LIKE '%game%'
)
OR ( news_news.`title` LIKE '%game%' )
OR ( news_news.`slug` LIKE '%game%' )
OR ( bidule_company.`name` LIKE '%game%' )
OR ( bidule_company.`slug` LIKE '%game%' )
OR ( bidule_game.`title` LIKE '%game%' )
OR ( bidule_game.`slug` LIKE '%game%' )
OR ( bidule_rating.`name` LIKE '%game%' )
OR ( bidule_rating.`slug` LIKE '%game%' )
OR ( bidule_platform.`name` LIKE '%game%'
)
OR ( bidule_platform.`slug` LIKE '%game%'
)
OR ( bidule_family.`name` LIKE '%game%' )
OR ( bidule_family.`slug` LIKE '%game%' )
OR ( bidule_brand.`name` LIKE '%game%' )
OR ( bidule_brand.`slug` LIKE '%game%' )
OR ( cms_flatpage.`title` LIKE '%game%'
)
OR ( cms_flatpage.`slug` LIKE '%game%' )
)) )
AND ( `mediacenter_media`.`id` != '88888888' )
LIMIT 21
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.