Book your next shots today

MarcCartwright

  • Battles: 2514
  • Wins: 1403
  • Losses: 1243
vs.

DanaPatrick

  • Battles: 2513
  • Wins: 1433
  • Losses: 1215
(default) 15 queries took 34 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `contenders`991
2DESCRIBE `contender_items`661
3DESCRIBE `battles`881
4DESCRIBE `tags`661
5DESCRIBE `contenders_tags`331
6SELECT `Contender`.`id` FROM `contenders` AS `Contender` WHERE `Contender`.`status` = 1 ORDER BY `Contender`.`battles` ASC 20200
7SELECT `Contender`.`id`, `Contender`.`name`, `Contender`.`slug`, `Contender`.`battles`, `Contender`.`won`, `Contender`.`lost`, `Contender`.`created`, `Contender`.`modified`, `Contender`.`status` FROM `contenders` AS `Contender` WHERE `Contender`.`id` = 61 LIMIT 1111
8SELECT `ContenderItem`.`id`, `ContenderItem`.`contender_id`, `ContenderItem`.`url`, `ContenderItem`.`created`, `ContenderItem`.`modified`, `ContenderItem`.`status` FROM `contender_items` AS `ContenderItem` WHERE `ContenderItem`.`contender_id` = (61) 10100
9SELECT `Battle`.`id`, `Battle`.`contender_id`, `Battle`.`item_id`, `Battle`.`against`, `Battle`.`won`, `Battle`.`created`, `Battle`.`modified`, `Battle`.`status` FROM `battles` AS `Battle` WHERE `Battle`.`contender_id` = (61) ORDER BY created DESC LIMIT 55528
10SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`status`, `ContendersTag`.`id`, `ContendersTag`.`contender_id`, `ContendersTag`.`tag_id` FROM `tags` AS `Tag` JOIN `contenders_tags` AS `ContendersTag` ON (`ContendersTag`.`contender_id` = 61 AND `ContendersTag`.`tag_id` = `Tag`.`id`) 110
11SELECT `Contender`.`id`, `Contender`.`name`, `Contender`.`slug`, `Contender`.`battles`, `Contender`.`won`, `Contender`.`lost`, `Contender`.`created`, `Contender`.`modified`, `Contender`.`status` FROM `contenders` AS `Contender` WHERE `Contender`.`id` = 51 LIMIT 1110
12SELECT `ContenderItem`.`id`, `ContenderItem`.`contender_id`, `ContenderItem`.`url`, `ContenderItem`.`created`, `ContenderItem`.`modified`, `ContenderItem`.`status` FROM `contender_items` AS `ContenderItem` WHERE `ContenderItem`.`contender_id` = (51) 10100
13SELECT `Battle`.`id`, `Battle`.`contender_id`, `Battle`.`item_id`, `Battle`.`against`, `Battle`.`won`, `Battle`.`created`, `Battle`.`modified`, `Battle`.`status` FROM `battles` AS `Battle` WHERE `Battle`.`contender_id` = (51) ORDER BY created DESC LIMIT 5550
14SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`status`, `ContendersTag`.`id`, `ContendersTag`.`contender_id`, `ContendersTag`.`tag_id` FROM `tags` AS `Tag` JOIN `contenders_tags` AS `ContendersTag` ON (`ContendersTag`.`contender_id` = 51 AND `ContendersTag`.`tag_id` = `Tag`.`id`) 110
15SELECT *,(won/battles)*100 AS won_pc FROM contenders WHERE status=1 ORDER BY won_pc DESC,name LIMIT 10020200