| original_reply | [{"entity": "Piaci Pub & Pizzeria","summary": "Vegans in Mendocino can enjoy delicious vegan pizzas at Piaci Pub & Pizzeria, which offers a variety of vegan toppings and a thin-crust option."}, {"entity": "Saucy","summary": "In Ukiah, vegans can indulge in mouthwatering vegan pizzas at Saucy, known for their flavorful vegan cheese and assortment of plant-based toppings."}] |
| Piaci Pub & Pizzeria query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Piaci%Pub%&%Pizzeria%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Piaci Pub & Pizzeria') OR SOUNDEX(post_title) LIKE SOUNDEX('piaci pub & pizzeria') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Piaci%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pub%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pizzeria%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Piaci Pub & Pizzeria')OR SOUNDEX(post_title) LIKE SOUNDEX('piaci pub & pizzeria')OR (post_title LIKE '%Piaci%' OR post_title LIKE '%Pub%' OR post_title LIKE '%Pizzeria%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Piaci Pub & Pizzeria | {"post":{"ID":"31879","post_title":"Piaci Pub & Pizzeria","match_count":"23"},"summary":"Vegans in Mendocino can enjoy delicious vegan pizzas at Piaci Pub & Pizzeria, which offers a variety of vegan toppings and a thin-crust option.","permalink":"https://www.visitmendocino.com/listing/piaci-pub-pizzeria/"} |
| Saucy query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Saucy%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Saucy') OR SOUNDEX(post_title) LIKE SOUNDEX('saucy') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Saucy%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Saucy')OR SOUNDEX(post_title) LIKE SOUNDEX('saucy')OR (post_title LIKE '%Saucy%'))HAVING match_count >= 1ORDER BY match_count DESC; |
| Saucy | {"post":"","summary":"In Ukiah, vegans can indulge in mouthwatering vegan pizzas at Saucy, known for their flavorful vegan cheese and assortment of plant-based toppings.","permalink":""} |
| paragraph | Vegans in Mendocino can enjoy delicious vegan pizzas at <a href="https://www.visitmendocino.com/listing/piaci-pub-pizzeria/">Piaci Pub & Pizzeria</a>, which offers a variety of vegan toppings and a thin-crust option.<br><br>In Ukiah, vegans can indulge in mouthwatering vegan pizzas at Saucy, known for their flavorful vegan cheese and assortment of plant-based toppings.<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.