Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

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

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(6977) "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 (319,18,5,55,31,29,56,53,717,108,44,141,110,111,134,87,104,81,76,140,324,119,164,207,187,97,258,191,212,248,184,255,203,249,208,206,213,244,314,237,192,182,180,272,271,269,268,262,275,278,284,303,296,295,294,320,318,221,225,222,220,218,169,341,333,340,368,346,441,360,158,450,372,444,166,437,359,407,418,343,336,379,452,454,457,461,463,449,482,481,377,342,355,356,358,433,488,516,515,555,332,523,578,524,522,654,599,611,610,733,636,645,622,618,754,672,741,590,724,642,644,586,647,722,770,494,538,787,805,1072,827,774,614,504,537,1070,714,546,613,552,780,503,568,778,617,1079,681,571,826,769,814,840,834,833,801,828,848,1058,850,858,865,852,800,856,1014,1007,860,1026,1021,1019,662,656,853,1073,1074,1080,1076,1077,531,532,790,582,789,835,508,1061,1031,1100,838,1065,1119,1120,798,1101,708,1168,1003,1035,1048,1207,1190,1134,1206,1259,1260,1258,1230,1228,1224,1223,1184,1240,1243,1255,1256,1189,472,1303,1320,1322,1325,1332,1359,1427,1451,1409,1542,1554,1509,1574,1602,1609,1610,1607,1644,1577,1608,1547,1755,1787,1655,1794,1687,1562,1729,1694,1750,1679,1738,1739,1817,1708,1751,1749,1804,1807,1825,1767,1771,1823,1854,1855,1612,1647,1646,1763,1830,1726,1660,1677,1648,1649,1651,1634,1724,1866,1867,1506,1814,1537,1908,1546,1605,1939,1560,1919,1917,1556,1617,1805,1920,2038,1812,1978,1973,1971,2013,2032,1952,1951,1938,1961,1858,1984,1912,2018,1969,2033,1996,2034,2084,1985,2062,2059,2086,2089,2081,2092,1786,2083,2055,2061,2097,2133,1962,1809,2093,2107,2109,2051,2066,1987,2122,2087,2073,2046,2143,2098,2161,2172,2088,2198,2160,2180,2179,2181,2203,2149,2052,2205,2209,2238,2159,2155,2213,2202,2235,2230,2216,2171,2240,2099,2244,2248,2085,2258,2166,2169,2167,2264,2260,2220,2147,2232,2245,2267,2276,2293,2308,2152,2294,2295,2262,2280,2327,2329,2310,2185,2299,2301,2261,2321,2277,2316,2325,2347,2314,2348,2194,2192,2344,2357,2358,2369,2374,2236,2252,2386,2100,2410,2362,2223,2391,2423,2444,2422,2415,2395,2463,2451,2414,2466,2471,2474,2469,2484,2412,2481,2482,2470,2489,2517,2503,2493,2512,2511,2528,2549,2545,2541,2556,2542,2557,2540,2285,2538,2531,2346,2559,2587,2524,2571,2590,2597,2580,2608,2562,2583,2534,2594,2624,2110,2651,2638,2575,2646,2614,2635,2639,2627,2657,2618,2690,2691,2682,2698,2683,2662,2685,2687,2714,2716,2730,2732,2604,2636,2695,2684,2679,2764,2748,2779,2874,2890,2869,2915,3022,3060,3115,3211,3210,3252,3303,3454,3455,3458,3459,3460,3463,3468,3477,3480,3486,3488,3490,3503,3506,3510,3515,3530,3542,3557,3561,3566,3576,3581,3583,3589,3590,3591,3593,3600,3601,3602,3605,3609,3610,3615,3616,3620,3622,3624,3627,3630,3634,3635,3638,3639,3642,3647,3648,3650,3652,3655,3656,3661,3662,3665,3668,3670,3675,3677,3682,3684,3686,3689,3691,3692,3693,3694,3696,3698,3700,3706,3708,3709,3711,3713,3717,3724,3727,3728,3740,3753,3783,3785,3793,3798,3839,3882,3883,3892,4112,4702,4908,4671)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 580"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(2) "38"
  }
}