>> EASTERNPOKERTOUR.COM
(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 8647
(mysqli): SELECT b.*, COUNT(c.id) as comment_cnt FROM blog b LEFT JOIN comment c ON (b.id = c._id AND c.type = 'blog') WHERE b.id = 1318 AND b.player_id = 8647 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 8647 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 8647
La Cucuracha's BLOG
Hand Washing in the Time of Corona
03-09-2020 04:19:50 PM
Grinding the pub scene we are constantly passing the chips and the cards back and forth so washing our hands thoroughly is the sanitary and right thing to do anytime but it's particularly important now with the rise of the Corona virus. CDC recommends rubbing your hands together using warm water and soap for 20 seconds and then rinsing. Here's a helpful hint for those who don't want to count it out, just sing the chorus to Kenny Rogers' iconic "the Gambler" to yourself while washing and you'll hit that 20 second mark!
(mysqli): SELECT opt.player_id, pp.thumb_name as thumb, CONCAT(p.first,' ',p.last) as name FROM player_opt opt LEFT JOIN player_photo pp ON opt.player_id = pp.player_id INNER JOIN player p ON p.id = opt.player_id WHERE opt.featured = 1 AND pp.dflt = 1
FEATURED
PLAYERS
