Upcoming Programs

120869
1511622000, 1511625600, NOW:1511501131
Saturday, November 25, 10:00 AM

Baby Play Date

Saturday, November 25, 10:00 a.m. - 11:00 a.m.
Carrico/Ft. Thomas Branch
Childrens Program 
126269
1511627400, 1511630100, NOW:1511501131
Saturday, November 25, 11:30 AM

Sensory Science Story Time

Saturday, November 25, 11:30 a.m. - 12:15 p.m.
Newport Branch
Childrens Program Teen Program Adult Program 
291869
1511793000, 1511794800, NOW:1511501131
Monday, November 27, 9:30 AM

Tot Time

Monday, November 27, 9:30 a.m. - 10:00 a.m.
Cold Spring Branch
Childrens Program 
299069
1511800200, 1511802000, NOW:1511501131
Monday, November 27, 11:30 AM

Tot Time

Monday, November 27, 11:30 a.m. - 12:00 p.m.
Cold Spring Branch
Childrens Program 
315269
1511816400, 1511820000, NOW:1511501131
Monday, November 27, 4:00 PM

Adventure Club: Brain Games

Monday, November 27, 4:00 p.m. - 5:00 p.m.
Carrico/Ft. Thomas Branch
Childrens Program 
318869
1511820000, 1511825400, NOW:1511501131
Monday, November 27, 5:00 PM

Teen Hangout

Monday, November 27, 5:00 p.m. - 6:30 p.m.
Cold Spring Branch
Teen Program 
322469
1511823600, 1511827200, NOW:1511501131
Monday, November 27, 6:00 PM

Pokemon Club

Monday, November 27, 6:00 p.m. - 7:00 p.m.
Cold Spring Branch
Teen Program 
324269
1511825400, 1511830800, NOW:1511501131
Monday, November 27, 6:30 PM
326069
1511827200, 1511829900, NOW:1511501131
Monday, November 27, 7:00 PM
380069
1511881200, 1511884800, NOW:1511501131
Tuesday, November 28, 10:00 AM
380069
1511881200, 1511883900, NOW:1511501131
Tuesday, November 28, 10:00 AM
383669
1511884800, 1511888400, NOW:1511501131
Tuesday, November 28, 11:00 AM
383669
1511884800, 1511887500, NOW:1511501131
Tuesday, November 28, 11:00 AM
401669
1511902800, 1511906400, NOW:1511501131
Tuesday, November 28, 4:00 PM
401669
1511902800, 1511904600, NOW:1511501131
Tuesday, November 28, 4:00 PM
412469
1511913600, 1511917200, NOW:1511501131
Tuesday, November 28, 7:00 PM
464669
1511965800, 1511968500, NOW:1511501131
Wednesday, November 29, 9:30 AM
466469
1511967600, 1511971200, NOW:1511501131
Wednesday, November 29, 10:00 AM
466469
1511967600, 1511969400, NOW:1511501131
Wednesday, November 29, 10:00 AM
470069
1511971200, 1511973900, NOW:1511501131
Wednesday, November 29, 11:00 AM
470069
1511971200, 1511973000, NOW:1511501131
Wednesday, November 29, 11:00 AM
475469
1511976600, 1511979300, NOW:1511501131
Wednesday, November 29, 12:30 PM
484469
1511985600, 1511992800, NOW:1511501131
Wednesday, November 29, 3:00 PM
488069
1511989200, 1511992800, NOW:1511501131
Wednesday, November 29, 4:00 PM
495269
1511996400, 1512000000, NOW:1511501131
Wednesday, November 29, 6:00 PM
551069
1512052200, 1512054900, NOW:1511501131
Thursday, November 30, 9:30 AM
552869
1512054000, 1512057600, NOW:1511501131
Thursday, November 30, 10:00 AM
552869
1512054000, 1512055800, NOW:1511501131
Thursday, November 30, 10:00 AM
554669
1512055800, 1512058500, NOW:1511501131
Thursday, November 30, 10:30 AM
558269
1512059400, 1512061200, NOW:1511501131
Thursday, November 30, 11:30 AM
561869
1512063000, 1512066600, NOW:1511501131
Thursday, November 30, 12:30 PM
570869
1512072000, 1512079200, NOW:1511501131
Thursday, November 30, 3:00 PM
574469
1512075600, 1512079200, NOW:1511501131
Thursday, November 30, 4:00 PM
585269
1512086400, 1512091800, NOW:1511501131
Thursday, November 30, 7:00 PM
668069
1512169200, 1512176400, NOW:1511501131
Friday, December 1, 6:00 PM
668069
1512169200, 1512183600, NOW:1511501131
Friday, December 1, 6:00 PM
729269
1512230400, 1512237600, NOW:1511501131
Saturday, December 2, 11:00 AM
729269
1512230400, 1512237600, NOW:1511501131
Saturday, December 2, 11:00 AM
729269
1512230400, 1512241200, NOW:1511501131
Saturday, December 2, 11:00 AM
729269
1512230400, 1512234000, NOW:1511501131
Saturday, December 2, 11:00 AM
732869
1512234000, 1512244800, NOW:1511501131
Saturday, December 2, 12:00 PM
896669
1512397800, 1512399600, NOW:1511501131
Monday, December 4, 9:30 AM
898469
1512399600, 1512403200, NOW:1511501131
Monday, December 4, 10:00 AM
903869
1512405000, 1512406800, NOW:1511501131
Monday, December 4, 11:30 AM
905669
1512406800, 1512410400, NOW:1511501131
Monday, December 4, 12:00 PM
920069
1512421200, 1512424800, NOW:1511501131
Monday, December 4, 4:00 PM
923669
1512424800, 1512432000, NOW:1511501131
Monday, December 4, 5:00 PM
930869
1512432000, 1512437400, NOW:1511501131
Monday, December 4, 7:00 PM
930869
1512432000, 1512434700, NOW:1511501131
Monday, December 4, 7:00 PM
984869
1512486000, 1512488700, NOW:1511501131
Tuesday, December 5, 10:00 AM
984869
1512486000, 1512489600, NOW:1511501131
Tuesday, December 5, 10:00 AM
988469
1512489600, 1512492300, NOW:1511501131
Tuesday, December 5, 11:00 AM
1006469
1512507600, 1512509400, NOW:1511501131
Tuesday, December 5, 4:00 PM
1006469
1512507600, 1512511200, NOW:1511501131
Tuesday, December 5, 4:00 PM
1013669
1512514800, 1512522000, NOW:1511501131
Tuesday, December 5, 6:00 PM
1017269
1512518400, 1512522000, NOW:1511501131
Tuesday, December 5, 7:00 PM
1069469
1512570600, 1512573300, NOW:1511501131
Wednesday, December 6, 9:30 AM
1071269
1512572400, 1512572400, NOW:1511501131
Wednesday, December 6, 10:00 AM
1071269
1512572400, 1512574200, NOW:1511501131
Wednesday, December 6, 10:00 AM
1074869
1512576000, 1512578700, NOW:1511501131
Wednesday, December 6, 11:00 AM
1074869
1512576000, 1512574200, NOW:1511501131
Wednesday, December 6, 11:00 AM
1080269
1512581400, 1512584100, NOW:1511501131
Wednesday, December 6, 12:30 PM
1085669
1512586800, 1512590400, NOW:1511501131
Wednesday, December 6, 2:00 PM
1092869
1512594000, 1512597600, NOW:1511501131
Wednesday, December 6, 4:00 PM
1092869
1512594000, 1512597600, NOW:1511501131
Wednesday, December 6, 4:00 PM
1155869
1512657000, 1512659700, NOW:1511501131
Thursday, December 7, 9:30 AM
1157669
1512658800, 1512662400, NOW:1511501131
Thursday, December 7, 10:00 AM
1157669
1512658800, 1512660600, NOW:1511501131
Thursday, December 7, 10:00 AM
1159469
1512660600, 1512663300, NOW:1511501131
Thursday, December 7, 10:30 AM
1163069
1512664200, 1512666000, NOW:1511501131
Thursday, December 7, 11:30 AM
1175669
1512676800, 1512684000, NOW:1511501131
Thursday, December 7, 3:00 PM
1179269
1512680400, 1512684000, NOW:1511501131
Thursday, December 7, 4:00 PM
1188269
1512689400, 1512696600, NOW:1511501131
Thursday, December 7, 6:30 PM
1188269
1512689400, 1512693000, NOW:1511501131
Thursday, December 7, 6:30 PM
1191869
1512693000, 1512696600, NOW:1511501131
Thursday, December 7, 7:30 PM
1254869
1512756000, 1512759600, NOW:1511501131
Friday, December 8, 1:00 PM
1262069
1512763200, 1512770400, NOW:1511501131
Friday, December 8, 3:00 PM
1272869
1512774000, 1512752400, NOW:1511501131
Friday, December 8, 6:00 PM
1330469
1512831600, 1512834300, NOW:1511501131
Saturday, December 9, 10:00 AM
1334069
1512835200, 1512837000, NOW:1511501131
Saturday, December 9, 11:00 AM
1335869
1512837000, 1512839700, NOW:1511501131
Saturday, December 9, 11:30 AM
1344869
1512846000, 1512806400, NOW:1511501131
Saturday, December 9, 2:00 PM
1501469
1513002600, 1513004400, NOW:1511501131
Monday, December 11, 9:30 AM
1503269
1513004400, 1513008000, NOW:1511501131
Monday, December 11, 10:00 AM
1508669
1513009800, 1513011600, NOW:1511501131
Monday, December 11, 11:30 AM
1524869
1513026000, 1513029600, NOW:1511501131
Monday, December 11, 4:00 PM
1528469
1513029600, 1513036800, NOW:1511501131
Monday, December 11, 5:00 PM
1532969
1513034100, 1513036800, NOW:1511501131
Monday, December 11, 6:15 PM
1533869
1513035000, 1513040400, NOW:1511501131
Monday, December 11, 6:30 PM
1535669
1513036800, 1513039500, NOW:1511501131
Monday, December 11, 7:00 PM
1589669
1513090800, 1513094400, NOW:1511501131
Tuesday, December 12, 10:00 AM
1589669
1513090800, 1513093500, NOW:1511501131
Tuesday, December 12, 10:00 AM
1593269
1513094400, 1513098000, NOW:1511501131
Tuesday, December 12, 11:00 AM
1593269
1513094400, 1513097100, NOW:1511501131
Tuesday, December 12, 11:00 AM
1611269
1513112400, 1513114200, NOW:1511501131
Tuesday, December 12, 4:00 PM
1674269
1513175400, 1513178100, NOW:1511501131
Wednesday, December 13, 9:30 AM
1676069
1513177200, 1513179000, NOW:1511501131
Wednesday, December 13, 10:00 AM
1679669
1513180800, 1513183500, NOW:1511501131
Wednesday, December 13, 11:00 AM
1679669
1513180800, 1513179000, NOW:1511501131
Wednesday, December 13, 11:00 AM
1685069
1513186200, 1513188900, NOW:1511501131
Wednesday, December 13, 12:30 PM
1690469
1513191600, 1513195200, NOW:1511501131
Wednesday, December 13, 2:00 PM
1697669
1513198800, 1513202400, NOW:1511501131
Wednesday, December 13, 4:00 PM
1703069
1513204200, 1513213200, NOW:1511501131
Wednesday, December 13, 5:30 PM
1706669
1513207800, 1513213200, NOW:1511501131
Wednesday, December 13, 6:30 PM
1758869
1513260000, 1513303200, NOW:1511501131
Thursday, December 14, 9:00 AM
1760669
1513261800, 1513264500, NOW:1511501131
Thursday, December 14, 9:30 AM
1762469
1513263600, 1513265400, NOW:1511501131
Thursday, December 14, 10:00 AM
1764269
1513265400, 1513268100, NOW:1511501131
Thursday, December 14, 10:30 AM
1767869
1513269000, 1513270800, NOW:1511501131
Thursday, December 14, 11:30 AM
1782269
1513283400, 1513290600, NOW:1511501131
Thursday, December 14, 3:30 PM
1782269
1513283400, 1513290600, NOW:1511501131
Thursday, December 14, 3:30 PM
1784069
1513285200, 1513288800, NOW:1511501131
Thursday, December 14, 4:00 PM
1784069
1513285200, 1513288800, NOW:1511501131
Thursday, December 14, 4:00 PM
1793069
1513294200, 1513297800, NOW:1511501131
Thursday, December 14, 6:30 PM
1845269
1513346400, 1513382400, NOW:1511501131
Friday, December 15, 9:00 AM
1850669
1513351800, 1513355400, NOW:1511501131
Friday, December 15, 10:30 AM
1931669
1513432800, 1513461600, NOW:1511501131
Saturday, December 16, 9:00 AM
1938869
1513440000, 1513447200, NOW:1511501131
Saturday, December 16, 11:00 AM
1938869
1513440000, 1513441800, NOW:1511501131
Saturday, December 16, 11:00 AM
1946069
1513447200, 1513454400, NOW:1511501131
Saturday, December 16, 1:00 PM
1949669
1513450800, 1513454400, NOW:1511501131
Saturday, December 16, 2:00 PM
2028869
1513530000, 1513548000, NOW:1511501131
Sunday, December 17, 12:00 PM
2032469
1513533600, 1513548000, NOW:1511501131
Sunday, December 17, 1:00 PM
2104469
1513605600, 1513648800, NOW:1511501131
Monday, December 18, 9:00 AM
2133269
1513634400, 1513648800, NOW:1511501131
Monday, December 18, 5:00 PM
2138669
1513639800, 1513645200, NOW:1511501131
Monday, December 18, 6:30 PM
2190869
1513692000, 1513735200, NOW:1511501131
Tuesday, December 19, 9:00 AM
2198069
1513699200, 1513702800, NOW:1511501131
Tuesday, December 19, 11:00 AM
2225069
1513726200, 1513731600, NOW:1511501131
Tuesday, December 19, 6:30 PM
2226869
1513728000, 1513731600, NOW:1511501131
Tuesday, December 19, 7:00 PM
2277269
1513778400, 1513821600, NOW:1511501131
Wednesday, December 20, 9:00 AM
2307869
1513809000, 1513789200, NOW:1511501131
Wednesday, December 20, 5:30 PM
2363669
1513864800, 1513908000, NOW:1511501131
Thursday, December 21, 9:00 AM
2399669
1513900800, 1513906200, NOW:1511501131
Thursday, December 21, 7:00 PM
2450069
1513951200, 1513987200, NOW:1511501131
Friday, December 22, 9:00 AM
2486069
1513987200, 1513998000, NOW:1511501131
Friday, December 22, 7:00 PM
2536469
1514037600, 1514066400, NOW:1511501131
Saturday, December 23, 9:00 AM
2622869
1514124000, 1514134800, NOW:1511501131
Sunday, December 24, 9:00 AM
2709269
1514210400, 1514221200, NOW:1511501131
Monday, December 25, 9:00 AM
2795669
1514296800, 1514340000, NOW:1511501131
Tuesday, December 26, 9:00 AM
2882069
1514383200, 1514426400, NOW:1511501131
Wednesday, December 27, 9:00 AM
2968469
1514469600, 1514512800, NOW:1511501131
Thursday, December 28, 9:00 AM
3004469
1514505600, 1514511000, NOW:1511501131
Thursday, December 28, 7:00 PM
3054869
1514556000, 1514592000, NOW:1511501131
Friday, December 29, 9:00 AM
3141269
1514642400, 1514671200, NOW:1511501131
Saturday, December 30, 9:00 AM
3148469
1514649600, 1514654100, NOW:1511501131
Saturday, December 30, 11:00 AM
3153869
1514655000, 1514658600, NOW:1511501131
Saturday, December 30, 12:30 PM
3238469
1514739600, 1514757600, NOW:1511501131
Sunday, December 31, 12:00 PM
3400469
1514901600, 1514944800, NOW:1511501131
Tuesday, January 2, 9:00 AM
3407669
1514908800, 1514912400, NOW:1511501131
Tuesday, January 2, 11:00 AM
3425669
1514926800, 1514930400, NOW:1511501131
Tuesday, January 2, 4:00 PM
3436469
1514937600, 1514941200, NOW:1511501131
Tuesday, January 2, 7:00 PM
3486869
1514988000, 1515031200, NOW:1511501131
Wednesday, January 3, 9:00 AM
3512069
1515013200, 1515016800, NOW:1511501131
Wednesday, January 3, 4:00 PM
3573269
1515074400, 1515117600, NOW:1511501131
Thursday, January 4, 9:00 AM
3594869
1515096000, 1515103200, NOW:1511501131
Thursday, January 4, 3:00 PM
3607469
1515108600, 1515115800, NOW:1511501131
Thursday, January 4, 6:30 PM
3659669
1515160800, 1515196800, NOW:1511501131
Friday, January 5, 9:00 AM
3692069
1515193200, 1515207600, NOW:1511501131
Friday, January 5, 6:00 PM
3746069
1515247200, 1515276000, NOW:1511501131
Saturday, January 6, 9:00 AM
3843269
1515344400, 1515362400, NOW:1511501131
Sunday, January 7, 12:00 PM
3918869
1515420000, 1515463200, NOW:1511501131
Monday, January 8, 9:00 AM
3929669
1515430800, 1515434400, NOW:1511501131
Monday, January 8, 12:00 PM
3947669
1515448800, 1515456000, NOW:1511501131
Monday, January 8, 5:00 PM
3951269
1515452400, 1515459600, NOW:1511501131
Monday, January 8, 6:00 PM
4005269
1515506400, 1515549600, NOW:1511501131
Tuesday, January 9, 9:00 AM
4008869
1515510000, 1515513600, NOW:1511501131
Tuesday, January 9, 10:00 AM
4012469
1515513600, 1515517200, NOW:1511501131
Tuesday, January 9, 11:00 AM
4030469
1515531600, 1515535200, NOW:1511501131
Tuesday, January 9, 4:00 PM
4091669
1515592800, 1515636000, NOW:1511501131
Wednesday, January 10, 9:00 AM
4109669
1515610800, 1515614400, NOW:1511501131
Wednesday, January 10, 2:00 PM
4113269
1515614400, 1515621600, NOW:1511501131
Wednesday, January 10, 3:00 PM
4125869
1515627000, 1515629700, NOW:1511501131
Wednesday, January 10, 6:30 PM
4178069
1515679200, 1515722400, NOW:1511501131
Thursday, January 11, 9:00 AM
4201469
1515702600, 1515709800, NOW:1511501131
Thursday, January 11, 3:30 PM
4203269
1515704400, 1515708000, NOW:1511501131
Thursday, January 11, 4:00 PM
4212269
1515713400, 1515718800, NOW:1511501131
Thursday, January 11, 6:30 PM
4264469
1515765600, 1515794400, NOW:1511501131
Friday, January 12, 9:00 AM
4278869
1515780000, 1515783600, NOW:1511501131
Friday, January 12, 1:00 PM
4293269
1515794400, 1515776400, NOW:1511501131
Friday, January 12, 5:00 PM
4300469
1515801600, 1515807000, NOW:1511501131
Friday, January 12, 7:00 PM
4350869
1515852000, 1515880800, NOW:1511501131
Saturday, January 13, 9:00 AM
4448069
1515949200, 1515967200, NOW:1511501131
Sunday, January 14, 12:00 PM
4523669
1516024800, 1516068000, NOW:1511501131
Monday, January 15, 9:00 AM
4525469
1516026600, 1516028400, NOW:1511501131
Monday, January 15, 9:30 AM
4527269
1516028400, 1516032000, NOW:1511501131
Monday, January 15, 10:00 AM
4532669
1516033800, 1516035600, NOW:1511501131
Monday, January 15, 11:30 AM
4548869
1516050000, 1516053600, NOW:1511501131
Monday, January 15, 4:00 PM
4552469
1516053600, 1516060800, NOW:1511501131
Monday, January 15, 5:00 PM
4557869
1516059000, 1516064400, NOW:1511501131
Monday, January 15, 6:30 PM
4559669
1516060800, 1516067100, NOW:1511501131
Monday, January 15, 7:00 PM
4559669
1516060800, 1516063500, NOW:1511501131
Monday, January 15, 7:00 PM
4610069
1516111200, 1516154400, NOW:1511501131
Tuesday, January 16, 9:00 AM
4613669
1516114800, 1516118400, NOW:1511501131
Tuesday, January 16, 10:00 AM
4613669
1516114800, 1516117500, NOW:1511501131
Tuesday, January 16, 10:00 AM
4613669
1516114800, 1516117500, NOW:1511501131
Tuesday, January 16, 10:00 AM
4635269
1516136400, 1516140000, NOW:1511501131
Tuesday, January 16, 4:00 PM
4635269
1516136400, 1516140000, NOW:1511501131
Tuesday, January 16, 4:00 PM
4696469
1516197600, 1516240800, NOW:1511501131
Wednesday, January 17, 9:00 AM
4698269
1516199400, 1516202100, NOW:1511501131
Wednesday, January 17, 9:30 AM
4700069
1516201200, 1516204800, NOW:1511501131
Wednesday, January 17, 10:00 AM
4700069
1516201200, 1516203000, NOW:1511501131
Wednesday, January 17, 10:00 AM
4703669
1516204800, 1516206600, NOW:1511501131
Wednesday, January 17, 11:00 AM
4703669
1516204800, 1516207500, NOW:1511501131
Wednesday, January 17, 11:00 AM
4718069
1516219200, 1516226400, NOW:1511501131
Wednesday, January 17, 3:00 PM
4721669
1516222800, 1516226400, NOW:1511501131
Wednesday, January 17, 4:00 PM
4732469
1516233600, 1516237200, NOW:1511501131
Wednesday, January 17, 7:00 PM
4782869
1516284000, 1516327200, NOW:1511501131
Thursday, January 18, 9:00 AM
4784669
1516285800, 1516288500, NOW:1511501131
Thursday, January 18, 9:30 AM
4784669
1516285800, 1516287600, NOW:1511501131
Thursday, January 18, 9:30 AM
4786469
1516287600, 1516291200, NOW:1511501131
Thursday, January 18, 10:00 AM
4788269
1516289400, 1516292100, NOW:1511501131
Thursday, January 18, 10:30 AM
4788269
1516289400, 1516292100, NOW:1511501131
Thursday, January 18, 10:30 AM
4806269
1516307400, 1516314600, NOW:1511501131
Thursday, January 18, 3:30 PM
4808069
1516309200, 1516312800, NOW:1511501131
Thursday, January 18, 4:00 PM
4817069
1516318200, 1516325400, NOW:1511501131
Thursday, January 18, 6:30 PM
4817069
1516318200, 1516323600, NOW:1511501131
Thursday, January 18, 6:30 PM
4869269
1516370400, 1516406400, NOW:1511501131
Friday, January 19, 9:00 AM
4905269
1516406400, 1516413600, NOW:1511501131
Friday, January 19, 7:00 PM
4955669
1516456800, 1516485600, NOW:1511501131
Saturday, January 20, 9:00 AM
4959269
1516460400, 1516463100, NOW:1511501131
Saturday, January 20, 10:00 AM
4964669
1516465800, 1516468500, NOW:1511501131
Saturday, January 20, 11:30 AM
4970069
1516471200, 1516474800, NOW:1511501131
Saturday, January 20, 1:00 PM
4973669
1516474800, 1516478400, NOW:1511501131
Saturday, January 20, 2:00 PM
5052869
1516554000, 1516572000, NOW:1511501131
Sunday, January 21, 12:00 PM
5056469
1516557600, 1516572000, NOW:1511501131
Sunday, January 21, 1:00 PM
5130269
1516631400, 1516633200, NOW:1511501131
Monday, January 22, 9:30 AM
5132069
1516633200, 1516636800, NOW:1511501131
Monday, January 22, 10:00 AM
5137469
1516638600, 1516640400, NOW:1511501131
Monday, January 22, 11:30 AM
5153669
1516654800, 1516658400, NOW:1511501131
Monday, January 22, 4:00 PM
5162669
1516663800, 1516669200, NOW:1511501131
Monday, January 22, 6:30 PM
5164469
1516665600, 1516668300, NOW:1511501131
Monday, January 22, 7:00 PM
5218469
1516719600, 1516722300, NOW:1511501131
Tuesday, January 23, 10:00 AM
5222069
1516723200, 1516725900, NOW:1511501131
Tuesday, January 23, 11:00 AM
5240069
1516741200, 1516744800, NOW:1511501131
Tuesday, January 23, 4:00 PM
5240069
1516741200, 1516744800, NOW:1511501131
Tuesday, January 23, 4:00 PM
5250869
1516752000, 1516755600, NOW:1511501131
Tuesday, January 23, 7:00 PM
5258069
1516759200, 1516759200, NOW:1511501131
Tuesday, January 23, 9:00 PM

View All Programs

select *, date_format(date, '%M %e'), date_format(date, '%W'), events.id as eventid , unix_timestamp( concat(date, ' ', if(ampm = 'AM', if(hour = 12, 0, hour), if(hour = 12, hour, hour + 12)), ':', minutes) ) as utime, unix_timestamp( concat(date, ' ', if(ampmend = 'AM', if(hourend = 12, 0, hourend), if(hourend = 12, hourend, hourend + 12)), ':', minutesend) ) as utimeend from events,locations where events.location = locations.id and category != '7' and category != '8' and category != '11' and events.location != '' and active = 'Y' and deleted = 'N' and to_days(date) >= to_days(now()) and to_days(date) <= (to_days(now()) + 60) order by utime

New at CCPL