Upcoming Programs

12564
1480777200, 1480779000, NOW:1480764636
Saturday, December 3, 10:00 AM

Baby Sign Story Time: Jingle Babies

Saturday, December 3, 10:00 a.m. - 10:30 a.m.
Cold Spring Branch
Childrens Program 
23364
1480788000, 1480791600, NOW:1480764636
Saturday, December 3, 1:00 PM

Cocoa and Crafts

Saturday, December 3, 1:00 p.m. - 2:00 p.m.
Cold Spring Branch
Childrens Program 
26964
1480791600, 1480798800, NOW:1480764636
Saturday, December 3, 2:00 PM

Here Comes Santa Claus!

Saturday, December 3, 2:00 p.m. - 4:00 p.m.
Newport Branch
Childrens Program Teen Program Adult Program 
26964
1480791600, 1480798800, NOW:1480764636
Saturday, December 3, 2:00 PM

Holiday Music with Belltastic! and the HMS 8th Grade Strings Orchestra

Saturday, December 3, 2:00 p.m. - 4:00 p.m.
Carrico/Ft. Thomas Branch
Childrens Program 
185364
1480950000, 1480951800, NOW:1480764636
Monday, December 5, 10:00 AM

Baby Time

Monday, December 5, 10:00 a.m. - 10:30 a.m.
Cold Spring Branch
Childrens Program 
185364
1480950000, 1480952700, NOW:1480764636
Monday, December 5, 10:00 AM

Ready for K Through Play! Preschool Story Time.

Monday, December 5, 10:00 a.m. - 10:45 a.m.
Newport Branch
Childrens Program 
188964
1480953600, 1480955400, NOW:1480764636
Monday, December 5, 11:00 AM

Tot Time

Monday, December 5, 11:00 a.m. - 11:30 a.m.
Cold Spring Branch
Childrens Program 
192564
1480957200, 1480960800, NOW:1480764636
Monday, December 5, 12:00 PM
206964
1480971600, 1480977000, NOW:1480764636
Monday, December 5, 4:00 PM
206964
1480971600, 1480975200, NOW:1480764636
Monday, December 5, 4:00 PM
212364
1480977000, 1480984200, NOW:1480764636
Monday, December 5, 5:30 PM
215964
1480980600, 1480986000, NOW:1480764636
Monday, December 5, 6:30 PM
217764
1480982400, 1480985100, NOW:1480764636
Monday, December 5, 7:00 PM
271764
1481036400, 1481039100, NOW:1480764636
Tuesday, December 6, 10:00 AM
271764
1481036400, 1481038200, NOW:1480764636
Tuesday, December 6, 10:00 AM
275364
1481040000, 1481043600, NOW:1480764636
Tuesday, December 6, 11:00 AM
275364
1481040000, 1481041800, NOW:1480764636
Tuesday, December 6, 11:00 AM
293364
1481058000, 1481061600, NOW:1480764636
Tuesday, December 6, 4:00 PM
293364
1481058000, 1481059800, NOW:1480764636
Tuesday, December 6, 4:00 PM
302364
1481067000, 1481074200, NOW:1480764636
Tuesday, December 6, 6:30 PM
304164
1481068800, 1481072400, NOW:1480764636
Tuesday, December 6, 7:00 PM
304164
1481068800, 1481072400, NOW:1480764636
Tuesday, December 6, 7:00 PM
356364
1481121000, 1481124600, NOW:1480764636
Wednesday, December 7, 9:30 AM
358164
1481122800, 1481125500, NOW:1480764636
Wednesday, December 7, 10:00 AM
358164
1481122800, 1481124600, NOW:1480764636
Wednesday, December 7, 10:00 AM
361764
1481126400, 1481129100, NOW:1480764636
Wednesday, December 7, 11:00 AM
361764
1481126400, 1481128200, NOW:1480764636
Wednesday, December 7, 11:00 AM
376164
1481140800, 1481148000, NOW:1480764636
Wednesday, December 7, 3:00 PM
379764
1481144400, 1481147100, NOW:1480764636
Wednesday, December 7, 4:00 PM
379764
1481144400, 1481148000, NOW:1480764636
Wednesday, December 7, 4:00 PM
379764
1481144400, 1481148000, NOW:1480764636
Wednesday, December 7, 4:00 PM
388764
1481153400, 1481158800, NOW:1480764636
Wednesday, December 7, 6:30 PM
442764
1481207400, 1481210100, NOW:1480764636
Thursday, December 8, 9:30 AM
444564
1481209200, 1481211900, NOW:1480764636
Thursday, December 8, 10:00 AM
446364
1481211000, 1481213700, NOW:1480764636
Thursday, December 8, 10:30 AM
448164
1481212800, 1481214600, NOW:1480764636
Thursday, December 8, 11:00 AM
462564
1481227200, 1481232600, NOW:1480764636
Thursday, December 8, 3:00 PM
467964
1481232600, 1481236200, NOW:1480764636
Thursday, December 8, 4:30 PM
475164
1481239800, 1481247900, NOW:1480764636
Thursday, December 8, 6:30 PM
475164
1481239800, 1481245200, NOW:1480764636
Thursday, December 8, 6:30 PM
563364
1481328000, 1481338800, NOW:1480764636
Friday, December 9, 7:00 PM
617364
1481382000, 1481385600, NOW:1480764636
Saturday, December 10, 10:00 AM
620964
1481385600, 1481389200, NOW:1480764636
Saturday, December 10, 11:00 AM
635364
1481400000, 1481407200, NOW:1480764636
Saturday, December 10, 3:00 PM
635364
1481400000, 1481403600, NOW:1480764636
Saturday, December 10, 3:00 PM
790164
1481554800, 1481556600, NOW:1480764636
Monday, December 12, 10:00 AM
790164
1481554800, 1481557500, NOW:1480764636
Monday, December 12, 10:00 AM
793764
1481558400, 1481560200, NOW:1480764636
Monday, December 12, 11:00 AM
811764
1481576400, 1481580000, NOW:1480764636
Monday, December 12, 4:00 PM
815364
1481580000, 1481587200, NOW:1480764636
Monday, December 12, 5:00 PM
820764
1481585400, 1481590800, NOW:1480764636
Monday, December 12, 6:30 PM
822564
1481587200, 1481589900, NOW:1480764636
Monday, December 12, 7:00 PM
876564
1481641200, 1481643900, NOW:1480764636
Tuesday, December 13, 10:00 AM
876564
1481641200, 1481643000, NOW:1480764636
Tuesday, December 13, 10:00 AM
880164
1481644800, 1481648400, NOW:1480764636
Tuesday, December 13, 11:00 AM
880164
1481644800, 1481646600, NOW:1480764636
Tuesday, December 13, 11:00 AM
898164
1481662800, 1481666400, NOW:1480764636
Tuesday, December 13, 4:00 PM
898164
1481662800, 1481664600, NOW:1480764636
Tuesday, December 13, 4:00 PM
908964
1481673600, 1481677200, NOW:1480764636
Tuesday, December 13, 7:00 PM
961164
1481725800, 1481729400, NOW:1480764636
Wednesday, December 14, 9:30 AM
962964
1481727600, 1481730300, NOW:1480764636
Wednesday, December 14, 10:00 AM
962964
1481727600, 1481729400, NOW:1480764636
Wednesday, December 14, 10:00 AM
966564
1481731200, 1481733900, NOW:1480764636
Wednesday, December 14, 11:00 AM
966564
1481731200, 1481733000, NOW:1480764636
Wednesday, December 14, 11:00 AM
977364
1481742000, 1481745600, NOW:1480764636
Wednesday, December 14, 2:00 PM
980964
1481745600, 1481752800, NOW:1480764636
Wednesday, December 14, 3:00 PM
984564
1481749200, 1481752800, NOW:1480764636
Wednesday, December 14, 4:00 PM
984564
1481749200, 1481752800, NOW:1480764636
Wednesday, December 14, 4:00 PM
993564
1481758200, 1481766300, NOW:1480764636
Wednesday, December 14, 6:30 PM
1047564
1481812200, 1481814900, NOW:1480764636
Thursday, December 15, 9:30 AM
1049364
1481814000, 1481816700, NOW:1480764636
Thursday, December 15, 10:00 AM
1051164
1481815800, 1481818500, NOW:1480764636
Thursday, December 15, 10:30 AM
1052964
1481817600, 1481819400, NOW:1480764636
Thursday, December 15, 11:00 AM
1067364
1481832000, 1481839200, NOW:1480764636
Thursday, December 15, 3:00 PM
1072764
1481837400, 1481841000, NOW:1480764636
Thursday, December 15, 4:30 PM
1079964
1481844600, 1481852700, NOW:1480764636
Thursday, December 15, 6:30 PM
1135764
1481900400, 1481904000, NOW:1480764636
Friday, December 16, 10:00 AM
1222164
1481986800, 1481994000, NOW:1480764636
Saturday, December 17, 10:00 AM
1222164
1481986800, 1481989500, NOW:1480764636
Saturday, December 17, 10:00 AM
1222164
1481986800, 1481994000, NOW:1480764636
Saturday, December 17, 10:00 AM
1240164
1482004800, 1482008400, NOW:1480764636
Saturday, December 17, 3:00 PM
1319364
1482084000, 1482098400, NOW:1480764636
Sunday, December 18, 1:00 PM
1394964
1482159600, 1482161400, NOW:1480764636
Monday, December 19, 10:00 AM
1398564
1482163200, 1482165000, NOW:1480764636
Monday, December 19, 11:00 AM
1416564
1482181200, 1482197400, NOW:1480764636
Monday, December 19, 4:00 PM
1425564
1482190200, 1482166800, NOW:1480764636
Monday, December 19, 6:30 PM
1594764
1482359400, 1482339600, NOW:1480764636
Wednesday, December 21, 5:30 PM
1600164
1482364800, 1482368400, NOW:1480764636
Wednesday, December 21, 7:00 PM
1686564
1482451200, 1482456600, NOW:1480764636
Thursday, December 22, 7:00 PM
1769364
1482534000, 1482552000, NOW:1480764636
Friday, December 23, 6:00 PM
1823364
1482588000, 1482598800, NOW:1480764636
Saturday, December 24, 9:00 AM
1909764
1482674400, 1482685200, NOW:1480764636
Sunday, December 25, 9:00 AM
2118564
1482883200, 1482886800, NOW:1480764636
Tuesday, December 27, 7:00 PM
2276964
1483041600, 1483048800, NOW:1480764636
Thursday, December 29, 3:00 PM
2435364
1483200000, 1483205400, NOW:1480764636
Saturday, December 31, 11:00 AM
2437164
1483201800, 1483204500, NOW:1480764636
Saturday, December 31, 11:30 AM
2456964
1483221600, 1483203600, NOW:1480764636
Saturday, December 31, 5:00 PM
2514564
1483279200, 1483322400, NOW:1480764636
Sunday, January 1, 9:00 AM
2611764
1483376400, 1483380000, NOW:1480764636
Monday, January 2, 12:00 PM
2629764
1483394400, 1483399800, NOW:1480764636
Monday, January 2, 5:00 PM
2635164
1483399800, 1483405200, NOW:1480764636
Monday, January 2, 6:30 PM
2636964
1483401600, 1483407000, NOW:1480764636
Monday, January 2, 7:00 PM
2694564
1483459200, 1483462800, NOW:1480764636
Tuesday, January 3, 11:00 AM
2723364
1483488000, 1483491600, NOW:1480764636
Tuesday, January 3, 7:00 PM
2798964
1483563600, 1483567200, NOW:1480764636
Wednesday, January 4, 4:00 PM
2806164
1483570800, 1483578000, NOW:1480764636
Wednesday, January 4, 6:00 PM
2950164
1483714800, 1483718400, NOW:1480764636
Friday, January 6, 10:00 AM
2975364
1483740000, 1483743600, NOW:1480764636
Friday, January 6, 5:00 PM
2978964
1483743600, 1483758000, NOW:1480764636
Friday, January 6, 6:00 PM
3054564
1483819200, 1483826400, NOW:1480764636
Saturday, January 7, 3:00 PM
3209364
1483974000, 1483975800, NOW:1480764636
Monday, January 9, 10:00 AM
3209364
1483974000, 1483976700, NOW:1480764636
Monday, January 9, 10:00 AM
3212964
1483977600, 1483979400, NOW:1480764636
Monday, January 9, 11:00 AM
3230964
1483995600, 1483999200, NOW:1480764636
Monday, January 9, 4:00 PM
3234564
1483999200, 1484006400, NOW:1480764636
Monday, January 9, 5:00 PM
3241764
1484006400, 1484010000, NOW:1480764636
Monday, January 9, 7:00 PM
3241764
1484006400, 1484009100, NOW:1480764636
Monday, January 9, 7:00 PM
3295764
1484060400, 1484062200, NOW:1480764636
Tuesday, January 10, 10:00 AM
3295764
1484060400, 1484063100, NOW:1480764636
Tuesday, January 10, 10:00 AM
3299364
1484064000, 1484067600, NOW:1480764636
Tuesday, January 10, 11:00 AM
3299364
1484064000, 1484065800, NOW:1480764636
Tuesday, January 10, 11:00 AM
3317364
1484082000, 1484085600, NOW:1480764636
Tuesday, January 10, 4:00 PM
3317364
1484082000, 1484083800, NOW:1480764636
Tuesday, January 10, 4:00 PM
3328164
1484092800, 1484096400, NOW:1480764636
Tuesday, January 10, 7:00 PM
3380364
1484145000, 1484147700, NOW:1480764636
Wednesday, January 11, 9:30 AM
3382164
1484146800, 1484148600, NOW:1480764636
Wednesday, January 11, 10:00 AM
3382164
1484146800, 1484149500, NOW:1480764636
Wednesday, January 11, 10:00 AM
3385764
1484150400, 1484153100, NOW:1480764636
Wednesday, January 11, 11:00 AM
3396564
1484161200, 1484164800, NOW:1480764636
Wednesday, January 11, 2:00 PM
3403764
1484168400, 1484172000, NOW:1480764636
Wednesday, January 11, 4:00 PM
3403764
1484168400, 1484172000, NOW:1480764636
Wednesday, January 11, 4:00 PM
3410964
1484175600, 1484182800, NOW:1480764636
Wednesday, January 11, 6:00 PM
3466764
1484231400, 1484233200, NOW:1480764636
Thursday, January 12, 9:30 AM
3466764
1484231400, 1484234100, NOW:1480764636
Thursday, January 12, 9:30 AM
3468564
1484233200, 1484235900, NOW:1480764636
Thursday, January 12, 10:00 AM
3470364
1484235000, 1484237700, NOW:1480764636
Thursday, January 12, 10:30 AM
3472164
1484236800, 1484238600, NOW:1480764636
Thursday, January 12, 11:00 AM
3486564
1484251200, 1484258400, NOW:1480764636
Thursday, January 12, 3:00 PM
3491964
1484256600, 1484260200, NOW:1480764636
Thursday, January 12, 4:30 PM
3497364
1484262000, 1484269200, NOW:1480764636
Thursday, January 12, 6:00 PM
3554964
1484319600, 1484326800, NOW:1480764636
Friday, January 13, 10:00 AM
3644964
1484409600, 1484370000, NOW:1480764636
Saturday, January 14, 11:00 AM
3655764
1484420400, 1484424000, NOW:1480764636
Saturday, January 14, 2:00 PM
3659364
1484424000, 1484427600, NOW:1480764636
Saturday, January 14, 3:00 PM
3738564
1484503200, 1484517600, NOW:1480764636
Sunday, January 15, 1:00 PM
3810564
1484575200, 1484586000, NOW:1480764636
Monday, January 16, 9:00 AM
3814164
1484578800, 1484580600, NOW:1480764636
Monday, January 16, 10:00 AM
3814164
1484578800, 1484581500, NOW:1480764636
Monday, January 16, 10:00 AM
3817764
1484582400, 1484584200, NOW:1480764636
Monday, January 16, 11:00 AM
3835764
1484600400, 1484604000, NOW:1480764636
Monday, January 16, 4:00 PM
3839364
1484604000, 1484609400, NOW:1480764636
Monday, January 16, 5:00 PM
3844764
1484609400, 1484617500, NOW:1480764636
Monday, January 16, 6:30 PM
3846564
1484611200, 1484614800, NOW:1480764636
Monday, January 16, 7:00 PM
3846564
1484611200, 1484613900, NOW:1480764636
Monday, January 16, 7:00 PM
3900564
1484665200, 1484667000, NOW:1480764636
Tuesday, January 17, 10:00 AM
3900564
1484665200, 1484667900, NOW:1480764636
Tuesday, January 17, 10:00 AM
3904164
1484668800, 1484670600, NOW:1480764636
Tuesday, January 17, 11:00 AM
3922164
1484686800, 1484690400, NOW:1480764636
Tuesday, January 17, 4:00 PM
3922164
1484686800, 1484688600, NOW:1480764636
Tuesday, January 17, 4:00 PM
3932964
1484697600, 1484701200, NOW:1480764636
Tuesday, January 17, 7:00 PM
3985164
1484749800, 1484752500, NOW:1480764636
Wednesday, January 18, 9:30 AM
3986964
1484751600, 1484753400, NOW:1480764636
Wednesday, January 18, 10:00 AM
3986964
1484751600, 1484754300, NOW:1480764636
Wednesday, January 18, 10:00 AM
3990564
1484755200, 1484757000, NOW:1480764636
Wednesday, January 18, 11:00 AM
3990564
1484755200, 1484757900, NOW:1480764636
Wednesday, January 18, 11:00 AM
4008564
1484773200, 1484776800, NOW:1480764636
Wednesday, January 18, 4:00 PM
4013964
1484778600, 1484758800, NOW:1480764636
Wednesday, January 18, 5:30 PM
4015764
1484780400, 1484784000, NOW:1480764636
Wednesday, January 18, 6:00 PM
4071564
1484836200, 1484838000, NOW:1480764636
Thursday, January 19, 9:30 AM
4071564
1484836200, 1484838900, NOW:1480764636
Thursday, January 19, 9:30 AM
4073364
1484838000, 1484840700, NOW:1480764636
Thursday, January 19, 10:00 AM
4075164
1484839800, 1484842500, NOW:1480764636
Thursday, January 19, 10:30 AM
4076964
1484841600, 1484843400, NOW:1480764636
Thursday, January 19, 11:00 AM
4091364
1484856000, 1484863200, NOW:1480764636
Thursday, January 19, 3:00 PM
4096764
1484861400, 1484865000, NOW:1480764636
Thursday, January 19, 4:30 PM
4103964
1484868600, 1484876700, NOW:1480764636
Thursday, January 19, 6:30 PM
4184964
1484949600, 1484955900, NOW:1480764636
Friday, January 20, 5:00 PM
4192164
1484956800, 1484962200, NOW:1480764636
Friday, January 20, 7:00 PM
4192164
1484956800, 1484967600, NOW:1480764636
Friday, January 20, 7:00 PM
4247964
1485012600, 1485015300, NOW:1480764636
Saturday, January 21, 10:30 AM
4256964
1485021600, 1485025200, NOW:1480764636
Saturday, January 21, 1:00 PM
4260564
1485025200, 1485032400, NOW:1480764636
Saturday, January 21, 2:00 PM
4267764
1485032400, 1485036000, NOW:1480764636
Saturday, January 21, 4:00 PM
4418964
1485183600, 1485185400, NOW:1480764636
Monday, January 23, 10:00 AM
4418964
1485183600, 1485186300, NOW:1480764636
Monday, January 23, 10:00 AM
4422564
1485187200, 1485189000, NOW:1480764636
Monday, January 23, 11:00 AM
4440564
1485205200, 1485208800, NOW:1480764636
Monday, January 23, 4:00 PM
4451364
1485216000, 1485219600, NOW:1480764636
Monday, January 23, 7:00 PM
4451364
1485216000, 1485218700, NOW:1480764636
Monday, January 23, 7:00 PM
4505364
1485270000, 1485271800, NOW:1480764636
Tuesday, January 24, 10:00 AM
4505364
1485270000, 1485272700, NOW:1480764636
Tuesday, January 24, 10:00 AM
4508964
1485273600, 1485275400, NOW:1480764636
Tuesday, January 24, 11:00 AM
4526964
1485291600, 1485295200, NOW:1480764636
Tuesday, January 24, 4:00 PM
4526964
1485291600, 1485293400, NOW:1480764636
Tuesday, January 24, 4:00 PM
4537764
1485302400, 1485306000, NOW:1480764636
Tuesday, January 24, 7:00 PM
4537764
1485302400, 1485306000, NOW:1480764636
Tuesday, January 24, 7:00 PM
4589964
1485354600, 1485357300, NOW:1480764636
Wednesday, January 25, 9:30 AM
4591764
1485356400, 1485358200, NOW:1480764636
Wednesday, January 25, 10:00 AM
4591764
1485356400, 1485359100, NOW:1480764636
Wednesday, January 25, 10:00 AM
4595364
1485360000, 1485361800, NOW:1480764636
Wednesday, January 25, 11:00 AM
4595364
1485360000, 1485362700, NOW:1480764636
Wednesday, January 25, 11:00 AM
4613364
1485378000, 1485381600, NOW:1480764636
Wednesday, January 25, 4:00 PM
4613364
1485378000, 1485381600, NOW:1480764636
Wednesday, January 25, 4:00 PM
4620564
1485385200, 1485392400, NOW:1480764636
Wednesday, January 25, 6:00 PM
4676364
1485441000, 1485442800, NOW:1480764636
Thursday, January 26, 9:30 AM
4676364
1485441000, 1485443700, NOW:1480764636
Thursday, January 26, 9:30 AM
4678164
1485442800, 1485445500, NOW:1480764636
Thursday, January 26, 10:00 AM
4679964
1485444600, 1485447300, NOW:1480764636
Thursday, January 26, 10:30 AM
4681764
1485446400, 1485448200, NOW:1480764636
Thursday, January 26, 11:00 AM
4701564
1485466200, 1485469800, NOW:1480764636
Thursday, January 26, 4:30 PM
4708764
1485473400, 1485477000, NOW:1480764636
Thursday, January 26, 6:30 PM
4710564
1485475200, 1485480600, NOW:1480764636
Thursday, January 26, 7:00 PM
4766364
1485531000, 1485534600, NOW:1480764636
Friday, January 27, 10:30 AM
4793364
1485558000, 1485572400, NOW:1480764636
Friday, January 27, 6:00 PM
4854564
1485619200, 1485621000, NOW:1480764636
Saturday, January 28, 11:00 AM
4854564
1485619200, 1485622800, NOW:1480764636
Saturday, January 28, 11:00 AM
4868964
1485633600, 1485636300, NOW:1480764636
Saturday, January 28, 3:00 PM
5023764
1485788400, 1485790200, NOW:1480764636
Monday, January 30, 10:00 AM
5023764
1485788400, 1485791100, NOW:1480764636
Monday, January 30, 10:00 AM
5027364
1485792000, 1485793800, NOW:1480764636
Monday, January 30, 11:00 AM
5045364
1485810000, 1485813600, NOW:1480764636
Monday, January 30, 4:00 PM
5048964
1485813600, 1485819000, NOW:1480764636
Monday, January 30, 5:00 PM
5054364
1485819000, 1485822600, NOW:1480764636
Monday, January 30, 6:30 PM
5054364
1485819000, 1485827100, NOW:1480764636
Monday, January 30, 6:30 PM
5056164
1485820800, 1485823500, NOW:1480764636
Monday, January 30, 7:00 PM
5110164
1485874800, 1485876600, NOW:1480764636
Tuesday, January 31, 10:00 AM
5110164
1485874800, 1485877500, NOW:1480764636
Tuesday, January 31, 10:00 AM
5113764
1485878400, 1485880200, NOW:1480764636
Tuesday, January 31, 11:00 AM
5131764
1485896400, 1485900000, NOW:1480764636
Tuesday, January 31, 4:00 PM
5131764
1485896400, 1485898200, NOW:1480764636
Tuesday, January 31, 4:00 PM
5140764
1485905400, 1485912600, NOW:1480764636
Tuesday, January 31, 6:30 PM
5142564
1485907200, 1485910800, NOW:1480764636
Tuesday, January 31, 7:00 PM
5194764
1485959400, 1485962100, NOW:1480764636
Wednesday, February 1, 9:30 AM
5200164
1485964800, 1485967500, NOW:1480764636
Wednesday, February 1, 11:00 AM
5218164
1485982800, 1485986400, NOW:1480764636
Wednesday, February 1, 4:00 PM
5225364
1485990000, 1485997200, NOW:1480764636
Wednesday, February 1, 6: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