| original_reply | [{"entity": "Mendocino Theatre Company","summary": "The Mendocino Theatre Company is the perfect place for theater lovers to enjoy a captivating performance. Experience the magic of live theater and be enchanted by productions such as Matilda THE MUSICAL."},{"entity": "Mendocino College Center Theatre","summary": "For those seeking a variety of theatrical performances, the Mendocino College Center Theatre is a great option. Catch Matilda THE MUSICAL and immerse yourself in the world of musical theater."},{"entity": "Willits Community Theatre","summary": "If you’re looking for a community theater experience, the Willits Community Theatre is the place to go. Enjoy the lively atmosphere and watch Matilda THE MUSICAL performed by local talents."}] |
| Mendocino Theatre Company query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Theatre%Company%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Theatre Company’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino atre company’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Theatre%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Company%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Theatre Company’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino atre company’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Theatre%’ OR post_title LIKE ‘%Company%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Theatre Company | {"post":{"ID":"31532","post_title":"Mendocino Theatre Company","match_count":"23"},"summary":"The Mendocino Theatre Company is the perfect place for theater lovers to enjoy a captivating performance. Experience the magic of live theater and be enchanted by productions such as Matilda THE MUSICAL.","permalink":"https://www.visitmendocino.com/listing/mendocino-theatre-company/"} |
| Mendocino College Center Theatre query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%College%Center%Theatre%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino College Center Theatre’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino college center atre’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%College%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Center%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Theatre%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino College Center Theatre’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino college center atre’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%College%’ OR post_title LIKE ‘%Center%’ OR post_title LIKE ‘%Theatre%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino College Center Theatre | {"post":"","summary":"For those seeking a variety of theatrical performances, the Mendocino College Center Theatre is a great option. Catch Matilda THE MUSICAL and immerse yourself in the world of musical theater.","permalink":""} |
| Willits Community Theatre query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Willits%Community%Theatre%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Willits Community Theatre’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘willits community atre’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Willits%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Community%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Theatre%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Willits Community Theatre’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘willits community atre’)OR (post_title LIKE ‘%Willits%’ OR post_title LIKE ‘%Community%’ OR post_title LIKE ‘%Theatre%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Willits Community Theatre | {"post":{"ID":"31679","post_title":"Willits Community Theatre","match_count":"23"},"summary":"If you’re looking for a community theater experience, the Willits Community Theatre is the place to go. Enjoy the lively atmosphere and watch Matilda THE MUSICAL performed by local talents.","permalink":"https://www.visitmendocino.com/listing/willits-community-theatre/"} |
| paragraph | The <a href="https://www.visitmendocino.com/listing/mendocino-theatre-company/">Mendocino Theatre Company</a> is the perfect place for theater lovers to enjoy a captivating performance. Experience the magic of live theater and be enchanted by productions such as Matilda THE MUSICAL.<br><br>For those seeking a variety of theatrical performances, the Mendocino College Center Theatre is a great option. Catch Matilda THE MUSICAL and immerse yourself in the world of musical theater.<br><br>If you’re looking for a community theater experience, the <a href="https://www.visitmendocino.com/listing/willits-community-theatre/">Willits Community Theatre</a> is the place to go. Enjoy the lively atmosphere and watch Matilda THE MUSICAL performed by local talents.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.