Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

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

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(5938) "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 (43,8,67,66,151,119,187,199,248,227,247,314,249,206,245,250,266,264,237,269,268,329,368,428,442,394,432,440,482,521,560,567,578,583,566,720,703,645,651,652,638,639,643,737,496,787,612,723,832,844,846,845,1070,801,828,851,1002,852,853,854,855,1027,860,842,1028,1025,1022,1065,1061,1056,1117,1125,1172,1116,1114,1211,1151,1170,1112,1253,1252,1256,1120,1171,554,1250,1322,1314,1333,1335,1343,1316,1375,1380,1377,1382,1373,1386,1427,1400,1416,1417,1484,2163,1485,1411,1463,1526,1577,1557,1565,1620,1561,1641,1652,1720,1778,1824,1694,1795,1739,1815,1816,1709,1753,1793,1803,1877,1776,1853,1856,1745,1725,1923,1866,1874,1937,2040,1928,2034,2074,1963,2042,2043,2076,2092,1786,2080,2035,2153,2088,2176,2231,2052,2204,2209,2165,2237,2220,2293,2324,2328,2275,2303,2323,2301,2347,2352,2195,2343,2350,2360,2372,2373,2393,2362,2387,2390,2391,2411,2395,2448,2457,2463,2451,2447,2471,2460,2459,2474,2477,2480,2484,2412,2470,2488,2486,2501,2510,2538,2509,2568,2567,2539,2534,2587,2588,2597,2624,2622,2620,2639,2649,2698,2692,2713,2687,2699,2700,2718,2724,2730,2738,2746,2766,2731,2796,2811,2812,2808,2801,2809,2797,2807,2798,2810,2820,2767,2822,2844,2791,2799,2848,2865,2789,2913,2919,2941,2962,2942,2413,2953,2963,3055,3057,3059,3048,3024,3069,3070,3196,3238,3260,3296,3313,3453,3460,3479,3481,3482,3487,3492,3496,3499,3505,3514,3515,3516,3524,3525,3530,3531,3535,3540,3542,3556,3562,3563,3564,3570,3573,3577,3581,3586,3589,3596,3600,3606,3611,3613,3614,3618,3619,3622,3624,3627,3628,3633,3643,3645,3647,3668,3670,3683,3684,3693,3695,3709,3711,3714,3718,3719,3723,3725,3727,3731,3737,3742,3743,3758,3760,3765,3766,3768,3769,3774,3776,3782,3796,3799,3806,3807,3811,3814,3815,3841,3860,3861,3879,3884,3888,3890,3897,3925,4702,5115,5221,5056,5575,5562,5642,5572,5504,5656)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 280"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(2) "28"
  }
}