| original_reply | [{"entity": "Coyote Valley Casino","summary": "Gamblers looking for a thrilling gaming experience can try their luck at Coyote Valley Casino, which offers a wide range of slot machines, table games, and live poker. This casino is perfect for those seeking an exciting night out in Mendocino County."},{"entity": "Garcia River Casino","summary": "For a fun and entertaining gambling experience, Garcia River Casino is the place to be. With a variety of slot machines, table games, and a friendly atmosphere, this casino appeals to both casual players and avid gamblers."}] |
| Coyote Valley Casino query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Coyote%Valley%Casino%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Coyote Valley Casino') OR SOUNDEX(post_title) LIKE SOUNDEX('coyote valley casino') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Coyote%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Valley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Casino%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Coyote Valley Casino')OR SOUNDEX(post_title) LIKE SOUNDEX('coyote valley casino')OR (post_title LIKE '%Coyote%' OR post_title LIKE '%Valley%' OR post_title LIKE '%Casino%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Coyote Valley Casino | {"post":{"ID":"31821","post_title":"Coyote Valley Casino","match_count":"23"},"summary":"Gamblers looking for a thrilling gaming experience can try their luck at Coyote Valley Casino, which offers a wide range of slot machines, table games, and live poker. This casino is perfect for those seeking an exciting night out in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/coyote-valley-casino/"} |
| Garcia River Casino query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Garcia%River%Casino%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Garcia River Casino') OR SOUNDEX(post_title) LIKE SOUNDEX('garcia river casino') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Garcia%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Casino%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Garcia River Casino')OR SOUNDEX(post_title) LIKE SOUNDEX('garcia river casino')OR (post_title LIKE '%Garcia%' OR post_title LIKE '%River%' OR post_title LIKE '%Casino%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Garcia River Casino | {"post":{"ID":"31521","post_title":"Garcia River Casino","match_count":"23"},"summary":"For a fun and entertaining gambling experience, Garcia River Casino is the place to be. With a variety of slot machines, table games, and a friendly atmosphere, this casino appeals to both casual players and avid gamblers.","permalink":"https://www.visitmendocino.com/listing/garcia-river-casino/"} |
| paragraph | Gamblers looking for a thrilling gaming experience can try their luck at <a href="https://www.visitmendocino.com/listing/coyote-valley-casino/">Coyote Valley Casino</a>, which offers a wide range of slot machines, table games, and live poker. This casino is perfect for those seeking an exciting night out in Mendocino County.<br><br>For a fun and entertaining gambling experience, <a href="https://www.visitmendocino.com/listing/garcia-river-casino/">Garcia River Casino</a> is the place to be. With a variety of slot machines, table games, and a friendly atmosphere, this casino appeals to both casual players and avid gamblers.<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.