Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

https://api.playscripts.com/play/filter?filters%5Bthemes%5D%5B0%5D=13&sort=popularity

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(5490) "SELECT play.playid, play.title, play.byjoin, play.authorlist, play.authorlist_etal, play.authorsingle, play.singleauthorid, play.titleextra, play.authextra, play.priceextra, play.minduration, play.maxduration, play.genreshown, play.minmale, play.maxmale, play.minfemale, play.maxfemale, play.mintotal, play.maxtotal, play.numpages, play.setreqs, play.datepub, play.photo, play.photosmall, play.photothumb, play.photolg, play.photosquare, play.pwidth, play.pheight, play.pheight_sm, play.pheight_thumb, play.synopsis, play.active, play.prepub, play.visible, play.musical, play.doublecast, play.genderswitch, play.length, play.male, play.female, play.either, play.caption, play.sample_file, play.royalty, play.boperc_play, play.price_book, play.name_book, play.price_promptbook, play.price_vscore, play.price_cscore, play.price_vscore, play.price_cdcast, play.price_cdaccomp, play.fword, play.featured_trade, play.rec, play.rec_high, play.rec_middle, play.rec_pro, play.rec_comm, play.rec_college, play.rec_youth, play.rec_xmas, play.rec_adapt, play.rec_oneacts, play.new, play.keywords, play.description, play.comedy, play.drama, play.high, play.middle, play.youth, play.christmas, play.anthology, play.is_anthology, play.anthology_special, play.nopub, play.trade, play.isbn, play.price_packageA, play.price_packageB, play.vocalparts, play.songs, play.search_triggers, play.price_escript, play.min_pdf, play.escript_active, play.pdf_path, play.epub_path, play.college, play.community, play.professional, play.not_yet_available_text, play.free_sample_text, play.banner_text, play.no_comingsoon_banner, play.vidlic_active, play.numvidlic_play, play.price_vidlic, play.name_vidlic, play.price_item, play.name_item, play.page_title, play.page_description, play.playcounter, play.specific_recommendations, play.wimpy, play.notes_orch, play.orch, IFNULL(play.name_packageA, "Production Package A") as name_packageA, IFNULL(play.name_packageB, "Production Package B") as name_packageB, play.description_packageA, play.description_packageB, play.notes_packageA, play.notes_packageB, play.min_book, play.min_vscore, play.name_vscore, play.min_cscore, play.name_cscore, play.prod_cdcast, play.name_cdcast, play.prod_cdaccomp, play.name_cdaccomp, play.extra, play.not_yet_available_text, play.not_yet_available_text_email, play.notes, play.perusal_cdaccomp, play.perusal_cdcast, play.max_perusals, play.numprod_play, play.numperf_play, play.numbook_play, play.is_broadway_licensing, play.broadway_licensing_url, play.logo_pack_purchase_url, play.hide_sample, play.hide_purchase_buttons, play.cast_custom_label, play.cast_custom_count, ((play.anthology > 0) OR (play.price_book > 0) OR (play.price_promptbook > 0) OR
 (play.escript_active = 1) OR (play.price_vscore > 0) OR (play.price_cscore > 0) OR
 (play.price_cdcast > 0) OR (play.price_cdaccomp > 0) OR (play.orch > 0) OR
 (play.price_vidlic)) AS has_materials, (play.musical OR play.sku_vscore OR play.sku_cscore OR play.sku_cdcast OR
 play.sku_cdcast OR play.sku_cdaccomp OR play.sku_orch) AS offer_package, (play.musical OR play.sku_vscore OR play.sku_cscore OR play.sku_cdcast OR
 play.sku_cdcast OR play.sku_cdaccomp OR play.sku_orch) AS offer_package_a, ((play.sku_orch > 0) OR 
 ((play.musical OR play.sku_vscore OR play.sku_cscore OR play.sku_cdcast OR
 play.sku_cdcast OR play.sku_cdaccomp OR play.sku_orch) AND play.escript_active)) AS offer_package_b, play.performance_space_id, play.product_type_id, single_author_record.authorid, single_author_record.lname as author_last_name, single_author_record.active as author_active, single_author_record.is_agent as author_is_agent, single_author_record.visible as author_visible
FROM (play)
JOIN playauthor ON play.playid = playauthor.playid
LEFT JOIN author as single_author_record ON playauthor.authorid = single_author_record.authorid
WHERE `play`.`active` =  1
AND `play`.`visible` =  1
AND `single_author_record`.`active` =  1
AND `single_author_record`.`is_agent` =  0
AND `single_author_record`.`visible` =  1
AND `play`.`playid` IN (36,40,7,120,115,100,179,146,93,114,199,215,230,232,265,280,299,388,368,353,446,429,453,452,1603,482,415,520,523,521,405,554,648,720,559,734,735,650,755,674,676,641,525,730,644,646,721,774,764,612,537,826,842,1024,529,849,847,771,1171,782,831,785,786,1005,1146,1154,1172,1167,1211,1213,1155,1241,1321,1335,1312,1337,1302,1343,1374,1382,1373,1397,1427,1448,1460,1459,1411,1406,1557,1573,1613,1673,1691,1706,1684,1641,1652,1747,1756,1760,1761,1762,1572,1698,1635,1636,1389,1740,1709,1711,1834,1745,1585,1634,1725,1869,1866,1930,1937,1913,1905,1928,1951,1929,2092,2117,1985,2060,2059,1310,2080,2116,1700,2017,2158,2150,2071,2148,2181,2231,2159,2257,2240,2258,2220,2232,2293,2309,2328,2325,2210,2348,2357,2358,2368,2378,2372,2379,2364,2341,2386,2223,2411,2448,2460,2477,2416,2480,2508,2571,2581,2599,2562,2573,2610,2591,2647,2655,2688,2686,2700,2696,2604,2734,2709,2783,2860,2794,2793,2838,2941,2942,2943,2953,2980,3023,3036,3031,3070,3122,3151,3260,3314,3342,3311,3456,3465,3466,3469,3473,3476,3477,3479,3488,3491,3496,3497,3519,3524,3525,3535,3542,3559,3586,3587,3589,3596,3598,3600,3606,3609,3610,3619,3632,3655,3656,3657,3672,3675,3678,3699,3710,3712,3716,3719,3721,3729,3757,3762,3763,3772,3780,3806,3807,3808,3811,3821,3840,3845,3847,3861,3866,3871,3888,3896,3898,3900,3925,4123,4705,4702,5056,2211,5616)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 260"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
}