| original_reply | [{"entity": "Mendocino Vintage Marketplace","summary": "Vintage enthusiasts looking to sell their items will find a great opportunity at Mendocino Vintage Marketplace to rent a booth and showcase their unique vintage finds."}, {"entity": "Fort Bragg Antiques & Collectibles Mall","summary": "Those interested in selling vintage items can rent a booth at Fort Bragg Antiques & Collectibles Mall, offering a diverse market for collectors and antique lovers."}] |
| Mendocino Vintage Marketplace query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Vintage%Marketplace%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Vintage Marketplace’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino vintage marketplace’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Vintage%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Marketplace%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Vintage Marketplace’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino vintage marketplace’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Vintage%’ OR post_title LIKE ‘%Marketplace%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Vintage Marketplace | {"post":"","summary":"Vintage enthusiasts looking to sell their items will find a great opportunity at Mendocino Vintage Marketplace to rent a booth and showcase their unique vintage finds.","permalink":""} |
| Fort Bragg Antiques & Collectibles Mall query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Fort%Bragg%Antiques%&%Collectibles%Mall%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg Antiques & Collectibles Mall’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg antiques & collectibles mall’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fort%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bragg%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Antiques%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Collectibles%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mall%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg Antiques & Collectibles Mall’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg antiques & collectibles mall’)OR (post_title LIKE ‘%Fort%’ OR post_title LIKE ‘%Bragg%’ OR post_title LIKE ‘%Antiques%’ OR post_title LIKE ‘%Collectibles%’ OR post_title LIKE ‘%Mall%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Fort Bragg Antiques & Collectibles Mall | {"post":"","summary":"Those interested in selling vintage items can rent a booth at Fort Bragg Antiques & Collectibles Mall, offering a diverse market for collectors and antique lovers.","permalink":""} |
| paragraph | Vintage enthusiasts looking to sell their items will find a great opportunity at Mendocino Vintage Marketplace to rent a booth and showcase their unique vintage finds.<br><br>Those interested in selling vintage items can rent a booth at Fort Bragg Antiques & Collectibles Mall, offering a diverse market for collectors and antique lovers.<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.