original_reply |
[{"entity": "Check for missing fields","summary": "Make sure you have filled out all the required fields on the event form and try saving it again."},{"entity": "Check for invalid characters","summary": "Ensure that you have not entered any special characters or symbols in the event form. Stick to alphanumeric characters only and try saving again."},{"entity": "Check for exceeded character limits","summary": "Verify that you have not exceeded the character limits for any of the fields on the event form. Shorten the content if necessary and try saving again."},{"entity": "Check for conflicting event details","summary": "Double-check if you have already created an event with the same name, date, or time. Modify the details to avoid conflicts and try saving again."},{"entity": "Contact customer support","summary": "If the problem persists, contact our customer support team for assistance with the event form issue."}] |
Check for missing fields query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Check%for%missing%fields%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Check for missing fields’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for missing fields’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Check%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%missing%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%fields%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Check for missing fields’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for missing fields’)OR (post_title LIKE ‘%Check%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%missing%’ OR post_title LIKE ‘%fields%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Check for missing fields |
{"post":"","summary":"Make sure you have filled out all the required fields on the event form and try saving it again.","permalink":""} |
Check for invalid characters query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Check%for%invalid%characters%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Check for invalid characters’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for invalid characters’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Check%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%invalid%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%characters%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Check for invalid characters’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for invalid characters’)OR (post_title LIKE ‘%Check%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%invalid%’ OR post_title LIKE ‘%characters%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Check for invalid characters |
{"post":"","summary":"Ensure that you have not entered any special characters or symbols in the event form. Stick to alphanumeric characters only and try saving again.","permalink":""} |
Check for exceeded character limits query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Check%for%exceeded%character%limits%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Check for exceeded character limits’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for exceeded character limits’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Check%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%exceeded%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%character%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%limits%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Check for exceeded character limits’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for exceeded character limits’)OR (post_title LIKE ‘%Check%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%exceeded%’ OR post_title LIKE ‘%character%’ OR post_title LIKE ‘%limits%’))HAVING match_count >= 5ORDER BY match_count DESC; |
Check for exceeded character limits |
{"post":"","summary":"Verify that you have not exceeded the character limits for any of the fields on the event form. Shorten the content if necessary and try saving again.","permalink":""} |
Check for conflicting event details query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Check%for%conflicting%event%details%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Check for conflicting event details’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for conflicting event details’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Check%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%conflicting%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%event%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%details%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Check for conflicting event details’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘check for conflicting event details’)OR (post_title LIKE ‘%Check%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%conflicting%’ OR post_title LIKE ‘%event%’ OR post_title LIKE ‘%details%’))HAVING match_count >= 5ORDER BY match_count DESC; |
Check for conflicting event details |
{"post":"","summary":"Double-check if you have already created an event with the same name, date, or time. Modify the details to avoid conflicts and try saving again.","permalink":""} |
Contact customer support query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Contact%customer%support%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Contact customer support’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘contact customer support’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Contact%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%customer%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%support%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Contact customer support’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘contact customer support’)OR (post_title LIKE ‘%Contact%’ OR post_title LIKE ‘%customer%’ OR post_title LIKE ‘%support%’))HAVING match_count >= 3ORDER BY match_count DESC; |
Contact customer support |
{"post":"","summary":"If the problem persists, contact our customer support team for assistance with the event form issue.","permalink":""} |
paragraph |
Make sure you have filled out all the required fields on the event form and try saving it again.<br><br>Ensure that you have not entered any special characters or symbols in the event form. Stick to alphanumeric characters only and try saving again.<br><br>Verify that you have not exceeded the character limits for any of the fields on the event form. Shorten the content if necessary and try saving again.<br><br>Double-check if you have already created an event with the same name, date, or time. Modify the details to avoid conflicts and try saving again.<br><br>If the problem persists, contact our customer support team for assistance with the event form issue.<br><br> |