Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

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

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(7336) "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 (1257,140,4704,5101,223,222,159,220,511,225,838,617,221,218,227,1823,1498,3206,2910,1096,2511,2937,2794,2795,1462,266,154,1124,722,1855,3058,2926,2927,139,3247,3304,2165,321,588,589,391,587,586,1021,1020,359,1018,1019,2560,2516,267,387,152,68,608,605,604,603,607,609,606,293,4064,4066,3131,3124,590,602,53,54,3043,55,2380,2333,118,2334,2098,2105,2100,2106,2104,2113,3060,1514,2735,1258,2134,2854,272,345,342,320,343,4671,360,361,2416,2601,2600,2500,2602,2807,164,2856,2187,2844,1297,3032,2667,1511,2659,1003,2412,1114,2260,1230,1228,1223,1224,2966,430,1763,1214,678,420,686,699,673,424,276,277,278,275,2523,2383,2696,2695,1983,1972,1971,1979,394,1973,1978,1977,389,1982,1980,1981,1974,1975,1976,2481,2709,2701,3151,3117,3048,3003,257,256,111,110,109,36,3143,3027,3052,2988,2987,2838,2466,2414,2244,2688,3056,3260,3299,3148,2941,2942,2358,2357,619,1089,621,622,3342,3436,3422,1085,1086,2943,3343,2769,2471,1087,1084,1088,620,3246,2577,1090,3171,3341,3340,2744,3031,2508,3186,2747,3250,2484,3245,3238,3057,2848,2796,2627,1233,1204,1217,1112,1078,2780,2813,3125,3381,2374,2209,2038,1190,1184,1070,3065,3063,3386,3359,3360,3361,3362,3363,3189,3053,3061,3082,3084,3085,3083,3005,3044,2739,2740,2598,2517,3012,2989,2960,3059,2863,2539,299,247,248,93,112,99,2335,3252,3069,3099,2699,2612,2582,2538,2373,3334,2677,2624,2568,2117,726,707,2792,261,157,115,3257,2637,2638,70,2964,3267,3014,2980,2666,183,3311,11,5105,5084,5056,4078,4985,4948,4118,4125,4783,4123,3314,3313,3306,3243,3211,3209,3166,3165,3122,3095,3091,3036,3035,3026,3025,3024,3023,3002,2975,2921,2920,2914,2913,2886,2884,2874,2873,2822,2820,2806,2801,2798,2797,2793,2767,2766,2764,2750,2799,2746,2745,2743,2732,2716,2714,2687,2686,2685,2662,2639,2636,2635,2633,2628,2625,2620,2615,2597,2587,2586,2583,2567,2566,2599,2529,2504,2487,2486,2479,2478,2474,2472,2468,2461,2457,2451,2448,2447,2410,2390,2384,2375,2368,2360,2359,2347,2332,2328,2304,2303,2300,2295,2294,2293,2278,2276,2257,2233,2231,2202,2184,2151,2148,2124,2094,2093,2092,2091,2090,2089,2081,2080,2076,2065,2064,2063,2062,2061,2055,2053,2052,2099,2047,2044,2043,2042,2032,2030,2023,2016,2011,1994,1966,1950,1937,1923,1911,1909,1906,1873,1872,1869,1831,1830,1825,1824,1820,1815,1778,1740,1739,1738,1735,1726,1725,1724,1712,1711,1696,1695,1615,1602,1597,1577,1567,1599,1522,1520,1519,1518,1517,1512,2998,2995,2990,1485,1484,1478,1460,1459,1444,1443,1441,1436,1428,1427,1426,1425,1417,1416,1414,1412,1411,1410,1404,1400,1383,1382,1379,1378,1377,1375,1374,1358,1356,1352,1337,1335,1332,1330,1315,1287,1286,1285,1284,1283,1282,1262,1256,1299,1248,1247,1242,1239,1231,1229,1226,1225,1215,1209,1207,1205,1203,1201,1198,1183,1172,1171,1170,1169,1168,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1146,1143,1129,1125,1123,1120,1116,1080,1064,1033,1027,1017,1016,1012,1011,1001,858,856,855,854,853,852,851,850,848,847,833,827,826,817,816,815,806,803,797,796,774,740,737,727,721,720,713,668,653,652,651,650,647,646,645,644,643,642,641,640,639,638,618,612,593,583,578,577,560,559,556,555,554,540,539,523,521,520,519,517,516,515,447,446,445,429,428,427,426,425,418,406,405,388,369,368,362,344,322,271,263,262,258,255,212,210,202,113,63,2,192)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 640"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(3) "134"
  }
}