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

[georgestephanis]

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]

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