Story / Theme

Casting

to
to
to

Play Duration

to

Musicals

Search Request Failed

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

array(2) {
  ["error"]=>
  string(25) "No results could be found"
  ["query"]=>
  string(6237) "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 (17,50,25,44,30,56,99,102,135,178,148,119,202,226,265,270,283,349,380,252,398,426,381,444,460,480,363,366,523,577,599,657,728,734,687,688,693,696,686,745,731,661,540,593,722,495,497,603,602,574,723,844,846,779,862,840,834,861,851,848,1002,852,853,854,800,855,830,568,600,1012,573,1030,656,1025,1070,1076,793,794,795,790,836,508,1096,1114,1003,1186,1170,1151,1144,1259,1240,1256,1270,1275,1278,1279,1280,1214,1281,1341,1257,1300,1293,1307,1314,1326,1375,1382,1485,1517,1462,1520,1564,1601,1606,1620,1675,1706,1707,1686,1714,1652,1741,1747,1748,1754,1759,1762,1783,1720,1583,1531,1584,1579,1640,1778,1477,1694,1795,1476,1738,1432,1816,1709,1753,1800,1824,1793,1767,1770,1823,1872,1877,1811,1821,1803,1776,1853,1677,1768,1773,1725,1856,2163,1585,1763,1710,1911,1869,1900,1909,1866,1728,1926,2015,2038,1937,1913,1905,1975,1977,1971,2013,1938,2032,1951,1809,1865,1984,2037,2036,1996,2063,1968,2062,2016,2043,2081,2092,1786,2061,2132,1995,2109,2103,2153,1700,1731,1931,2151,2143,2126,2088,2198,2231,2204,1656,2075,2154,2165,2173,2258,2237,2287,2278,2293,2308,2262,2300,2309,2323,2317,2277,2321,2316,2320,2178,2314,1997,1955,2348,2357,2358,2376,2350,2360,2371,2373,2341,2242,2410,2393,2359,2391,2434,2419,2424,2463,2414,2466,2472,2468,2474,2416,2484,2481,2470,2488,2478,2504,2501,2517,2515,2529,2503,2512,2509,2511,2538,2554,2541,2540,2567,2534,2577,2587,2285,2558,2606,2580,2539,2597,2574,2583,2531,2565,2622,2620,2596,2635,2639,2677,2666,2682,2698,2662,2688,2692,2687,2695,2718,2693,2730,2604,2734,2696,2746,2731,2856,2795,2791,2854,2865,2848,2920,2963,3069,3038,3027,3040,3166,3196,3209,3257,3461,3477,3494,3503,3505,3507,3530,3539,3552,3554,3555,3556,3561,3562,3563,3568,3571,3572,3576,3583,3584,3589,3596,3600,3609,3610,3611,3615,3616,3620,3621,3623,3624,3625,3627,3630,3631,3634,3635,3636,3638,3640,3642,3645,3647,3651,3658,3662,3665,3668,3670,3675,3676,3683,3692,3693,3700,3703,3705,3708,3709,3711,3712,3714,3715,3716,3717,3727,3729,3737,3760,3764,3776,3778,3779,3782,3800,3815,3844,3848,3850,3860,3874,3879,3881,3887,4703,4723,5573,5504,5666,5697,4118)
GROUP BY play.playid
ORDER BY play.playrank desc, play.playcounter/DATEDIFF(CURRENT_DATE, play.datepub) DESC, play.playid DESC
LIMIT 20 OFFSET 400"
}
array(1) {
  ["themes"]=>
  array(1) {
    [0]=>
    string(2) "21"
  }
}