{"SELECT `s`.`id`, `s`.`name`, `s`.`slug`, `s`.`preview`, `s`.`address`, `l`.`title` `location_name`, `location_latlong`, `begin_date`, `end_date`, `begin_booking`, `begin_booking_time`, `end_booking`, `end_booking_time` FROM `koishow_show` s \n\tLEFT JOIN `location` `l` ON `l`.`id` = `s`.`location_id` \n\tWHERE `s`.`published` = 1 AND `s`.`active` = 1  ORDER BY `s`.`begin_date` DESC LIMIT 0,20":["1763115334",[{"id":"41","name":"Magelang+Koi+Festival+2025","slug":"magelang-koi-festival-2025","preview":"e0b6fbd99e290bcf.jpeg","address":"Gor+Gemilang+Magelang%2C+Komplek+Kantor+DPRD+Kab+Magelang","location_name":"Magelang","location_latlong":"-7.5136132%2C110.2143303","begin_date":"2025-11-07","end_date":"2025-11-09","begin_booking":"2025-10-08","begin_booking_time":"06%3A00%3A00","end_booking":"2025-11-08","end_booking_time":"12%3A00%3A00"},{"id":"39","name":"2nd+SKANEKA+Koi+Festival+2025","slug":"2nd-skaneka-koi-festival-2025","preview":"6d410a1f61bd5138.png","address":"Lapangan+Basket+SMKN+1+Kademangan+Blitar+","location_name":"Kademangan","location_latlong":"-8.14256543301961%2C112.13957816362381","begin_date":"2025-09-17","end_date":"2025-09-17","begin_booking":"2025-08-17","begin_booking_time":"06%3A25%3A00","end_booking":"2025-09-17","end_booking_time":"11%3A00%3A00"},{"id":"38","name":"1st+Purwokerto+Oneday+Koi+Show","slug":"1st-purwokerto-oneday-koi-show","preview":"63475551310e2e87.jpg","address":"Convention+Hall+Menara+Teratai+Purwokerto","location_name":"Purwokerto+Timur","location_latlong":"-7.431517539754876%2C109.23254370689392","begin_date":"2025-01-03","end_date":"2025-01-04","begin_booking":"2024-12-16","begin_booking_time":"05%3A00%3A00","end_booking":"2025-01-04","end_booking_time":"14%3A00%3A00"},{"id":"37","name":"2nd+Malang+Koi+Festival","slug":"2nd-malang-koi-festival","preview":"440ee6cb657b3ce8.jpeg","address":"Bonderland+Waterpark%2C+Pakisaji+","location_name":"Pakisaji","location_latlong":"-8.049152238943027%2C112.60833525028528","begin_date":"2024-12-01","end_date":"2024-12-01","begin_booking":"2024-11-23","begin_booking_time":"06%3A00%3A00","end_booking":"2024-12-01","end_booking_time":"12%3A30%3A00"},{"id":"35","name":"1st+Muria+Kudus+One+Day+Koi+Show+2024","slug":"1st-muria-kudus-one-day-koi-show-2024","preview":"8702ff59049c5f5b.jpg","address":"Gedung+Kampus+IAIN+Kudus","location_name":"Kudus","location_latlong":"-6.801514244702644%2C110.87904319167137","begin_date":"2024-09-27","end_date":"2024-09-28","begin_booking":"2024-09-15","begin_booking_time":"07%3A00%3A00","end_booking":"2024-09-28","end_booking_time":"14%3A00%3A00"},{"id":"36","name":"1st+One+Day+Education+Koi+Show","slug":"1st-one-day-education-koi-show","preview":"38e4f9c1cec5e150.jpg","address":"Lapangan+Basket+SMKN+1+Kademangan+Blitar","location_name":"Kademangan","location_latlong":"-8.142530915822661%2C112.13946282863617","begin_date":"2024-09-25","end_date":"2024-09-25","begin_booking":"2024-09-22","begin_booking_time":"07%3A00%3A00","end_booking":"2024-09-25","end_booking_time":"13%3A00%3A00"},{"id":"34","name":"Temanggung+One+Day+Koi+Show+2024","slug":"temanggung-one-day-koi-show-2024","preview":"157dfc377651a6fd.jpeg","address":"Gedung+Ki+Ageng+Makukuhan","location_name":"Temanggung","location_latlong":"-7.27905975130826%2C110.15970021486282","begin_date":"2024-09-14","end_date":"2024-09-14","begin_booking":"2024-09-10","begin_booking_time":"07%3A00%3A00","end_booking":"2024-09-14","end_booking_time":"23%3A00%3A00"},{"id":"33","name":"2nd+Kebumen+One+Day+Koi+Show+2024","slug":"2nd-kebumen-one-day-koi-show-2024","preview":"00dccfecd9cb9048.jpeg","address":"Hotel+Mexolie+Kebumen+-+Jawa+Tengah","location_name":"Kebumen","location_latlong":"-7.681168349892826%2C109.66259837150574","begin_date":"2024-08-31","end_date":"2024-08-31","begin_booking":"2024-08-27","begin_booking_time":"07%3A00%3A00","end_booking":"2024-08-31","end_booking_time":"10%3A40%3A00"},{"id":"31","name":"Magelang+One+Day+Koi+Show","slug":"magelang-one-day-koi-show","preview":"be8ba0944b94565d.jpeg","address":"GOR+Gemilang+Magelang","location_name":"Magelang","location_latlong":"-7.5912073361362475%2C110.21875977516174","begin_date":"2024-05-17","end_date":"2024-05-19","begin_booking":"2024-04-30","begin_booking_time":"07%3A16%3A00","end_booking":"2024-05-18","end_booking_time":"15%3A00%3A00"},{"id":"30","name":"5th+BaKC+Koi+Show+2024","slug":"5th-bakc-koi-show-2024","preview":"925e98973499568c.jpeg","address":"Gedung+Bina+Satria+-+Banjar+Baru","location_name":"Banjarbaru","location_latlong":"-3.4405082311977395%2C114.83132779598236","begin_date":"2024-04-21","end_date":"2024-04-28","begin_booking":"2024-04-01","begin_booking_time":"12%3A00%3A00","end_booking":"2024-04-27","end_booking_time":"19%3A33%3A00"},{"id":"29","name":"Gebyar+Koi+Show+Banjarmasin+2024","slug":"gebyar-koi-show-banjarmasin-2024","preview":"3d059e0c94223f2b.jpeg","address":"Gedung+Sultan+Suriansyah","location_name":"Banjarmasin","location_latlong":"-3.298923637988725%2C114.59044933319092","begin_date":"2024-01-26","end_date":"2024-01-28","begin_booking":"2024-01-19","begin_booking_time":"00%3A00%3A00","end_booking":"2024-01-27","end_booking_time":"09%3A30%3A00"},{"id":"27","name":"1st+Kebumen+One+Day+Show","slug":"1st-kebumen-one-day-show","preview":"513365fddd6d92b6.png","address":"Universitas+Muhammadiyah+Gombong","location_name":"Gombong","location_latlong":"-7.609533%2C+109.501698","begin_date":"2024-01-05","end_date":"2024-01-06","begin_booking":"2023-12-27","begin_booking_time":"12%3A00%3A00","end_booking":"2024-01-06","end_booking_time":"13%3A05%3A00"},{"id":"25","name":"1st+Walikota+Cup+Bontang+Koi+Show","slug":"1st-walikota-cup-bontang-koi-show","preview":"afb5f3b0150b678c.jpeg","address":"Gedung+Koprasi+PKT+Bontang","location_name":"Bontang","location_latlong":"0.14249086593078467%2C117.46272638440132","begin_date":"2023-12-02","end_date":"2023-12-03","begin_booking":"2023-11-12","begin_booking_time":"07%3A00%3A00","end_booking":"2023-12-02","end_booking_time":"11%3A15%3A00"},{"id":"24","name":"2nd+All+Indonesia+Junior+Koi+Show","slug":"2nd-all-indonesia-junior-koi-show","preview":"8d6857560e3d19d8.jpg","address":"Jakarta+International+Expo","location_name":"Sawah+Besar","location_latlong":"-6.147723145773718%2C106.84611797332764","begin_date":"2023-10-25","end_date":"2023-10-29","begin_booking":"2023-10-24","begin_booking_time":"06%3A25%3A00","end_booking":"2023-10-28","end_booking_time":"12%3A00%3A00"},{"id":"21","name":"9th+All+Breeder+Koi+Indonesia+Koi+Show+","slug":"9th-all-breeder-koi-indonesia-koi-show","preview":"6bcd85794e5e0ed0.jpeg","address":"Bonderland+Waterpark%2C+Pakisaji+","location_name":"Pakisaji","location_latlong":"-8.04975391222051%2C112.60817885398865","begin_date":"2023-09-22","end_date":"2023-09-24","begin_booking":"2023-09-18","begin_booking_time":"01%3A18%3A00","end_booking":"2023-09-23","end_booking_time":"17%3A55%3A00"},{"id":"20","name":"Semarang+One+Day+Koi+Show+2023","slug":"semarang-one-day-koi-show-2023","preview":"00ebccc3aa3557d1.png","address":"Gedung+GRIS+Semarang","location_name":"Semarang","location_latlong":"-7.011234726912048%2C110.47159552574158","begin_date":"2023-09-02","end_date":"2023-09-02","begin_booking":"2023-08-27","begin_booking_time":"06%3A04%3A00","end_booking":"2023-09-02","end_booking_time":"13%3A00%3A00"},{"id":"19","name":"1st+Kabupaten+Banjar+Young+Koi+Show","slug":"1st-kabupaten-banjar-young-koi-show","preview":"edac90d7df2310cb.06","address":"Gedung+Serbaguna+Indrasari","location_name":"Martapura+Kota","location_latlong":"-3.4456908195432905%2C114.84694344305366","begin_date":"2023-08-12","end_date":"2023-08-12","begin_booking":"2023-07-01","begin_booking_time":"00%3A00%3A00","end_booking":"2023-08-12","end_booking_time":"13%3A25%3A00"},{"id":"18","name":"1st+All+Manado+Koi+Show+2023","slug":"1st-all-manado-koi-show-2023","preview":"309939f091af1adc.jpg","address":"Multi+Mart+Mega+Mas","location_name":"Manado","location_latlong":"1.4863939475219416%2C124.83572602272034","begin_date":"2023-07-01","end_date":"2023-07-01","begin_booking":"2023-06-24","begin_booking_time":"08%3A00%3A00","end_booking":"2023-07-01","end_booking_time":"19%3A00%3A00"},{"id":"17","name":"5th+LOKAL+KEDIRI+KOI+SHOW+2023","slug":"5th-lokal-kediri-koi-show-2023","preview":"80138ef612794031.jpg","address":"DEPO+IKAN+HIAS+PRANGGANG+PLOSOKKATEN+KEDIRI","location_name":"Plosoklaten","location_latlong":"-7.8486963702263015%2C112.1611350774765","begin_date":"2023-05-21","end_date":"2023-05-21","begin_booking":"2023-05-13","begin_booking_time":"08%3A00%3A00","end_booking":"2023-05-21","end_booking_time":"10%3A00%3A00"},{"id":"16","name":"TABANAN+EDUCATION+KOI+FESTIVAL+","slug":"tabanan-education-koi-festival","preview":"f2155d4d691bf102.png","address":"GEDUNG+KESENIAN+I+KETUT+MARIA","location_name":"Tabanan","location_latlong":"-8.537554740856818%2C115.12581557035446","begin_date":"2023-04-09","end_date":"2023-04-09","begin_booking":"2023-04-03","begin_booking_time":"06%3A00%3A00","end_booking":"2023-04-09","end_booking_time":"08%3A00%3A00"}]]}