More Filters

Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

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

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(6142) "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 (18,41,30,16,201,15,231,91,19,60,62,141,89,61,135,87,123,76,140,159,119,316,147,162,163,114,121,116,97,258,150,211,203,226,246,205,235,271,239,262,276,275,277,278,280,270,302,301,273,169,341,321,339,340,252,413,441,426,158,372,381,166,437,376,334,375,371,336,161,452,463,1578,1599,242,488,515,390,391,534,655,728,733,692,697,698,686,553,675,683,753,731,719,661,593,722,509,773,632,803,777,764,614,507,537,1070,714,772,681,552,684,678,574,778,658,763,571,837,769,833,792,800,830,1014,1079,782,1062,1026,1005,831,1019,656,1077,1082,1072,841,785,789,835,799,786,505,1100,1035,1046,1047,1037,1050,1174,1228,1149,1184,1217,1204,1256,1276,1214,1300,1297,1298,1313,1321,1326,1334,1401,1399,1388,1436,1461,1423,1514,1351,1517,1574,1586,1592,1609,1676,1610,1681,1682,1692,1607,1608,1741,1547,1553,1787,1583,1446,1584,1579,1640,1475,1750,1749,1801,1751,1828,1795,1807,1822,1767,1873,1872,1728,1796,1677,1721,1772,1612,1647,1791,1585,1763,1701,1911,1869,1648,1634,1908,1949,1924,1920,1930,2038,1906,2013,1938,1970,2032,2044,1951,1809,2037,1912,2018,2036,1985,2059,2016,2086,2062,2097,2060,2133,1310,2131,2109,1987,1700,2094,1731,2158,2098,2161,2119,2104,2106,2198,2180,2111,2179,1960,2205,2209,2159,2213,2206,2154,2155,2235,2230,2216,2171,2244,2248,2166,2169,2167,2278,2245,2276,2152,2294,2295,2247,2310,2185,2299,2261,2321,2214,2314,1941,2357,2358,2374,2373,2386,2379,2100,2410,2183,2422,2415,2419,2450,2417,2454,2424,2414,2466,2468,2461,2469,2416,2512,2511,2515,2503,2508,2528,2546,2551,2540,2561,2580,2581,2606,2578,2586,2574,2583,2531,2110,2638,2646,2647,2635,2637,2677,2124,2682,2662,2716,2695,2701,2709,2740,2887,2890,2869,3005,2988,3002,3021,3044,3039,3022,3040,3115,3458,3494,3501,3530,3539,3562,3568,3569,3572,3576,3578,3583,3593,3601,3602,3609,3610,3611,3615,3616,3617,3620,3621,3630,3632,3634,3635,3636,3639,3642,3649,3659,3662,3665,3667,3676,3689,3690,3692,3694,3700,3705,3708,3717,3720,3721,3733,3783,3791,3793,3823,3831,3833,3838,3839,3849,3850,3853,4118)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 380"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(2) "11"
  }
}