| original_reply | [{"entity": "Roses Pawn Shop","summary": "Music enthusiasts looking for a unique blend of bluegrass, folk, and rock will enjoy the lively performances at Roses Pawn Shop."}] |
| Roses Pawn Shop query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Roses%Pawn%Shop%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Roses Pawn Shop') OR SOUNDEX(post_title) LIKE SOUNDEX('roses pawn shop') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Roses%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pawn%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Shop%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Roses Pawn Shop')OR SOUNDEX(post_title) LIKE SOUNDEX('roses pawn shop')OR (post_title LIKE '%Roses%' OR post_title LIKE '%Pawn%' OR post_title LIKE '%Shop%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Roses Pawn Shop | {"post":"","summary":"Music enthusiasts looking for a unique blend of bluegrass, folk, and rock will enjoy the lively performances at Roses Pawn Shop.","permalink":""} |
| paragraph | Music enthusiasts looking for a unique blend of bluegrass, folk, and rock will enjoy the lively performances at Roses Pawn Shop.<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.