| original_reply | [{"entity": "Dick's Place","summary": "For a laid back bar atmosphere and a hearty serving of fish and chips, Dick's Place in Mendocino is a popular choice among locals and tourists alike."},{"entity": "Sea Pal Cove","summary": "Located in Fort Bragg, Sea Pal Cove offers generous portions of their locally famous fish and chips, ideal for seafood lovers."},{"entity": "Princess Seafood Market and Deli","summary": "For fresh off the boat seafood, Princess Seafood Market and Deli in Noyo Harbor serves excellent fish and chips."},{"entity": "Noyo Fish Company","summary": "Noyo Fish Company near the Noyo Harbor offers a fantastic waterfront dining experience with delicious fish and chips."}] |
| Dick's Place query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Dick\'s%Place%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Dick\'s Place') OR SOUNDEX(post_title) LIKE SOUNDEX('dick\'s place') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Dick\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Place%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Dick\'s Place')OR SOUNDEX(post_title) LIKE SOUNDEX('dick\'s place')OR (post_title LIKE '%Dick\'s%' OR post_title LIKE '%Place%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Dick's Place | {"post":{"ID":"31701","post_title":"Dick's Place","match_count":"22"},"summary":"For a laid back bar atmosphere and a hearty serving of fish and chips, Dick's Place in Mendocino is a popular choice among locals and tourists alike.","permalink":"https://www.visitmendocino.com/listing/dicks-place/"} |
| Sea Pal Cove query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Sea%Pal%Cove%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Sea Pal Cove') OR SOUNDEX(post_title) LIKE SOUNDEX('sea pal cove') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Sea%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cove%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Sea Pal Cove')OR SOUNDEX(post_title) LIKE SOUNDEX('sea pal cove')OR (post_title LIKE '%Sea%' OR post_title LIKE '%Pal%' OR post_title LIKE '%Cove%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Sea Pal Cove | {"post":{"ID":"32077","post_title":"Sea Pal Cove","match_count":"23"},"summary":"Located in Fort Bragg, Sea Pal Cove offers generous portions of their locally famous fish and chips, ideal for seafood lovers.","permalink":"https://www.visitmendocino.com/listing/sea-pal-cove/"} |
| Princess Seafood Market and Deli query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Princess%Seafood%Market%and%Deli%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Princess Seafood Market and Deli') OR SOUNDEX(post_title) LIKE SOUNDEX('princess seafood market and deli') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Princess%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Seafood%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Market%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Deli%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Princess Seafood Market and Deli')OR SOUNDEX(post_title) LIKE SOUNDEX('princess seafood market and deli')OR (post_title LIKE '%Princess%' OR post_title LIKE '%Seafood%' OR post_title LIKE '%Market%' OR post_title LIKE '%Deli%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Princess Seafood Market and Deli | {"post":{"ID":"32064","post_title":"Princess Seafood Market & Deli","match_count":"4"},"summary":"For fresh off the boat seafood, Princess Seafood Market and Deli in Noyo Harbor serves excellent fish and chips.","permalink":"https://www.visitmendocino.com/listing/princess-seafood-market-deli/"} |
| Noyo Fish Company query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Noyo%Fish%Company%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Noyo Fish Company') OR SOUNDEX(post_title) LIKE SOUNDEX('noyo fish company') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Noyo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Fish%' 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('Noyo Fish Company')OR SOUNDEX(post_title) LIKE SOUNDEX('noyo fish company')OR (post_title LIKE '%Noyo%' OR post_title LIKE '%Fish%' OR post_title LIKE '%Company%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Noyo Fish Company | {"post":{"ID":"32100","post_title":"Noyo Fish Company","match_count":"23"},"summary":"Noyo Fish Company near the Noyo Harbor offers a fantastic waterfront dining experience with delicious fish and chips.","permalink":"https://www.visitmendocino.com/listing/noyo-fish-company/"} |
| paragraph | For a laid back bar atmosphere and a hearty serving of fish and chips, <a href="https://www.visitmendocino.com/listing/dicks-place/">Dick's Place</a> in Mendocino is a popular choice among locals and tourists alike.<br><br>Located in Fort Bragg, <a href="https://www.visitmendocino.com/listing/sea-pal-cove/">Sea Pal Cove</a> offers generous portions of their locally famous fish and chips, ideal for seafood lovers.<br><br>For fresh off the boat seafood, <a href="https://www.visitmendocino.com/listing/princess-seafood-market-deli/">Princess Seafood Market and Deli</a> in Noyo Harbor serves excellent fish and chips.<br><br><a href="https://www.visitmendocino.com/listing/noyo-fish-company/">Noyo Fish Company</a> near the Noyo Harbor offers a fantastic waterfront dining experience with delicious fish and chips.<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.