Wrestler Brief Bio
Name: Scott Cardinal
Gender: Male
Known Aliases:
Scott Cardinal,
Height: 6 foot 4 - 193.0 cm
Weight: 260 lbs. - 117.9 kg
CHAMPIONSHIP TIMELINE
SELECT `t1`.`title_name_id`,
`t1`.`date_won`,
`t1`.`date_lost`,
`t1`.`event_listing_id`,
DATEDIFF(
IF(
ISNULL(`t1`.`date_lost`),
NOW(),
`t1`.`date_lost`
),
`t1`.`date_won`
) as `reign_days`,
`t2`.`name` AS `title_name`,
`t2`.`title_id`,
`t3`.`event_tagline` AS `tagline`,
`t6`.`name` AS `city_name`,
`t6`.`state_prov_abbr` AS `state_prov`,
`t6`.`country`,
`t7`.`name` AS `event_name`,
`t8`.`wrestler_id` AS `w_id1`,
`t9`.`wrestler_id` AS `w_id2`,
`t10`.`wrestler_id` AS `w_id3`,
`t11`.`acro`
FROM `title_history` AS `t1`
LEFT JOIN `title_names` AS `t2` USING (`title_name_id`)
LEFT JOIN `org_names` AS `t11` ON `t2`.`org_name_id` = `t11`.`org_name_id`
LEFT JOIN `event_listings` AS `t3` USING (`event_listing_id`)
LEFT JOIN `arena_names` AS `t4` USING (`arena_name_id`)
LEFT JOIN `arenas` AS `t5` ON `t4`.`arena_id` = `t5`.`arena_id`
LEFT JOIN `cities` AS `t6` ON `t5`.`city_id` = `t6`.`city_id`
LEFT JOIN `event_names` AS `t7` ON `t3`.`event_name_id` = `t7`.`event_name_id`
LEFT JOIN `alias` AS `t8` ON `t1`.`alias_id` = `t8`.`alias_id`
LEFT JOIN `alias` AS `t9` ON `t1`.`alias_id2` = `t9`.`alias_id`
LEFT JOIN `alias` AS `t10` ON `t1`.`alias_id3` = `t10`.`alias_id`WHERE (`t8`.`wrestler_id` = '2255' OR `t9`.`wrestler_id` = '2255' OR `t10`.`wrestler_id` = '2255')
AND `title_id` != 199ORDER BY `t1`.`date_won` ASC