Database Queries

SELECT * FROM `hdbk_competition` WHERE `alias`='football_brother'

SHOW FULL COLUMNS FROM `hdbk_competition`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'hdbk_competition' AND kcu.table_name = 'hdbk_competition'

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=19) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=19) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=114

SELECT * FROM `tag` WHERE (`module`='tournament') AND (`item_id`=114)

SELECT EXISTS(SELECT `post`.* FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`type`='news') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (`post_tag_assn`.`tag_id`=114))

SELECT EXISTS(SELECT `post`.* FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`type`='article') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (`post_tag_assn`.`tag_id`=114))

SELECT * FROM `tournament` WHERE `tournament_id`=114