Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

https://api.playscripts.com/play/filter?filters%5Btarget_group%5D%5B0%5D=professional&filters%5Bsubgenres%5D%5B0%5D=91&filters%5Bsubgenres%5D%5B1%5D=35&sort=popularity

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(6144) "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 `professional` =  1
AND `play`.`playid` IN (1578,2414,1298,1248,1394,1365,1321,1322,1332,1372,1366,1390,864,1367,1413,1384,1422,1398,1399,1388,1401,1415,1397,1448,1405,1436,1423,1419,1450,1512,1493,1403,1468,1430,1429,1447,1522,1402,718,719,1440,1472,1577,1536,1467,1574,1466,1552,1601,1657,1609,1610,1607,1608,1635,1654,1640,1636,1595,1614,1592,1562,1594,1475,1729,1750,1749,1751,1816,1794,1825,1873,1872,1728,1854,1727,1855,1724,1808,1647,1658,1744,1585,1726,1649,1648,1651,1901,1814,1908,1560,1926,1949,1805,1813,1907,2013,342,1928,2032,1952,1699,2044,2037,1912,1916,1903,2036,2084,1985,2059,2086,2089,2054,2060,1310,2107,2134,2103,2137,1987,1945,2066,2082,1700,2094,2012,2076,2126,2098,2104,2106,2184,2180,2181,2145,803,1256,1080,1064,1597,1258,271,833,1452,361,1201,655,41,1209,1264,1004,2213,1223,1224,1287,1285,1283,1286,1284,1282,280,1203,255,711,774,1215,1428,1199,670,1600,2238,2052,2155,2206,2230,2099,2171,2260,2245,2276,2294,2295,2300,2271,2264,2309,2312,2310,2299,2105,1024,2113,2338,2344,2339,2378,2376,2375,2350,2364,2386,2100,2410,2389,2423,2444,2434,2415,2419,2450,2417,2466,2461,2469,2482,2517,2511,2509,2546,2559,2558,2535,2561,2560,2524,2571,2590,2594,2608,2562,2598,2613,2585,2625,1507,2655,2677,2678,2618,2683,2680,2716,2718,2725,2714,2709,2701,2667,2717,2735,2740,2750,2749,1830,488,418,2685,1421,2659,2748,2731,2790,2813,2739,2660,2814,2873,2929,2921,2413,2780,2953,2884,2987,3005,2826,2988,3002,3021,3044,3053,3032,3028,3061,3082,3083,3084,3085,3115,3210,3304,3305,3359,3362,3361,3360,3363,3339,3454,3459,3501,3510,3513,3527,3529,3530,3532,3537,3553,3554,3557,3566,3568,3569,3576,3578,3581,3592,3593,3594,3601,3602,3604,3612,3615,3616,3617,3620,3634,3638,3646,3649,3651,3652,3653,3655,3656,3661,3666,3669,3671,3677,3681,3685,3699,3704,3705,3707,3713,3720,3721,3724,3726,3730,3732,3733,3739,3754,3759,3784,3789,3801,3804,3811,3822,3823,3829,3831,3833,3838,3853,3854,3856,3882,3893,3894,3902,3904,4724,4783,4790,4831,5221,5391,5562,4687,5668,5629,3436)
GROUP BY play.playid
ORDER BY play.playrank_pr desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 160"
}
array(2) {
  ["target_group"]=>
  array(1) {
    [0]=>
    string(12) "professional"
  }
  ["subgenres"]=>
  array(2) {
    [0]=>
    string(2) "91"
    [1]=>
    string(2) "35"
  }
}