Probably tidier to use `$wpdb->posts` not `{$wpdb->prefix}posts` #2

georgestephanis · 2020-10-01T13:33:37Z

fabrica-reusable-block-instances/fabrica-reusable-block-instances.php

Line 80 in 3a32abe

    
           $sql = "SELECT SUM((LENGTH(post_content) - LENGTH(REPLACE(post_content, %s, ''))) DIV LENGTH(%s)) AS instances FROM {$wpdb->prefix}posts WHERE post_content LIKE %s and post_status IN ('publish', 'draft', 'future', 'pending')";

andrewstaffell · 2020-10-04T21:56:12Z

@georgestephanis hello George, thanks for the suggestions, we'll incorporate these ASAP!

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Probably tidier to use `$wpdb->posts` not `{$wpdb->prefix}posts` #2

Probably tidier to use `$wpdb->posts` not `{$wpdb->prefix}posts` #2

georgestephanis commented Oct 1, 2020

andrewstaffell commented Oct 4, 2020

Probably tidier to use $wpdb->posts not {$wpdb->prefix}posts #2

Probably tidier to use $wpdb->posts not {$wpdb->prefix}posts #2

Comments

georgestephanis commented Oct 1, 2020

andrewstaffell commented Oct 4, 2020

Probably tidier to use `$wpdb->posts` not `{$wpdb->prefix}posts` #2

Probably tidier to use `$wpdb->posts` not `{$wpdb->prefix}posts` #2