WordPress.DB.PreparedSQL.InterpolatedNotPrepared
Interpolated SQL is not prepared
Variables are interpolated into a SQL string before the query is prepared.
Why It Shows Up
The scan found dynamic values placed directly inside SQL, often through string interpolation, before `$wpdb->prepare()` can safely bind them.
Why It Matters
Preparing a query after unsafe interpolation does not reliably protect the dynamic value.
How to Fix
- Replace interpolated variables with placeholders.
- Pass each dynamic value as a separate `$wpdb->prepare()` argument.
- Use allowlists for SQL identifiers and directions that cannot be represented as normal values.
References
Affected Plugins
| Rank | Plugin | Score | Errors | Warnings | Installs | Added | Updated | Top Issue |
|---|---|---|---|---|---|---|---|---|
| #1351 | Coupon Generator for WooCommerce | 40 | 39 | 28 | 10k+ | Unsafe printing function | ||
| #1352 | Cron Logger | 40 | 49 | 36 | 1k+ | Output is not escaped | ||
| #1353 | Cryptocurrency Widgets Pack | 40 | 222 | 52 | 700 | Unsafe printing function | ||
| #1354 | FameTheme Demo Importer | 40 | 8 | 74 | 30k+ | Nonce verification recommended | ||
| #1355 | GetPaid > Item Inventory | 40 | 112 | 52 | 400 | Text Domain Mismatch | ||
| #1356 | Product Enquiry for WooCommerce | 40 | 57 | 41 | 3k+ | Output is not escaped | ||
| #1357 | WP All Import – Listings Import for Listify | 40 | 34 | 27 | 400 | Output is not escaped | ||
| #1358 | LLM Bot Tracker – AI Crawler Detection & Analytics | 40 | 18 | 90 | 800 | Database parameter is not escaped | ||
| #1359 | Modal Window – create popup modal window | 40 | 4 | 170 | 10k+ | Non-prefixed global variable | ||
| #1360 | Page Comments Off Please | 40 | 17 | 29 | 1k+ | Nonce verification recommended | ||
| #1361 | Paystack MemberPress | 40 | 71 | 76 | 400 | Output is not escaped | ||
| #1362 | Random Banner | 40 | 59 | 125 | 1k+ | Output is not escaped | ||
| #1363 | Role Based Redirect | 40 | 20 | 96 | 2k+ | Non-prefixed global variable | ||
| #1364 | Select Post Export | 40 | 51 | 18 | 500 | Output is not escaped | ||
| #1365 | Serviceform Pixel | 40 | 18 | 22 | 400 | Output is not escaped | ||
| #1366 | Multipage | 40 | 72 | 28 | 900 | Unsafe printing function | ||
| #1367 | Show Pages URL List | 40 | 29 | 234 | 1k+ | Non-prefixed global variable | ||
| #1368 | Simple Statistics for Feeds | 40 | 64 | 131 | 800 | Nonce verification recommended | ||
| #1369 | ThemeZee Toolkit | 40 | 44 | 116 | 6k+ | Nonce verification recommended | ||
| #1370 | Thin Out Revisions | 40 | 93 | 35 | 800 | Non Singular String Literal Domain | ||
| #1371 | UTM Leads Tracker – XLPlugins | 40 | 21 | 38 | 400 | Output is not escaped | ||
| #1372 | WC Search Orders By Product | 40 | 47 | 66 | 800 | Nonce verification recommended | ||
| #1373 | Webo-facto | 40 | 41 | 102 | 1k+ | Nonce verification recommended | ||
| #1374 | NP Quote Request for WooCommerce | 40 | 91 | 145 | 9k+ | Non-prefixed global variable | ||
| #1375 | Total Sales Counts for WooCommerce | 40 | 121 | 62 | 700 | SQL query is not prepared | ||
| #1376 | Wallet for WooCommerce | 40 | 32 | 524 | 20k+ | Non-prefixed hook name | ||
| #1377 | Word Balloon | 40 | 20 | 125 | 10k+ | Request data is not unslashed | ||
| #1378 | WP All Import – Job Listing Import for WP Job Manager | 40 | 35 | 27 | 2k+ | Output is not escaped | ||
| #1379 | WP Multisite Content Copier/Updater | 40 | 19 | 144 | 800 | Interpolated SQL is not prepared | ||
| #1380 | WP Reroute Email | 40 | 141 | 106 | 1k+ | Output is not escaped | ||
| #1381 | WPS Menu Exporter | 40 | 47 | 22 | 10k+ | Output is not escaped | ||
| #1382 | Yektanet Ecommerce | 40 | 45 | 103 | 1k+ | Request data is not unslashed | ||
| #1383 | AMP for WP – Accelerated Mobile Pages | 41 | 656 | 2,401 | 80k+ | Non-prefixed global variable | ||
| #1384 | Alma – Pay in installments or later for WooCommerce | 41 | 116 | 68 | 1k+ | Exception output is not escaped | ||
| #1385 | Auto Image Attributes From Filename With Bulk Updater (Add Alt Text, Image Title For Image SEO) | 41 | 175 | 26 | 100k+ | Unsafe printing function | ||
| #1386 | Autocomplete Google Address | 41 | 22 | 67 | 2k+ | Nonce verification recommended | ||
| #1387 | AxiaChat AI – Free AI Chatbot (Answers Customers Automatically) | 41 | 1 | 135 | 2k+ | Interpolated SQL is not prepared | ||
| #1388 | BuddyPress Xprofile Custom Field Types | 41 | 39 | 189 | 4k+ | Missing nonce verification | ||
| #1389 | Bulk Delete Comments | 41 | 15 | 61 | 5k+ | Direct Query | ||
| #1390 | Cache control by Cacholong | 41 | 87 | 30 | 500 | Non Singular String Literal Domain | ||
| #1391 | CMS Tree Page View – Reorder Pages with a Drag-and-Drop Tree | 41 | 121 | 96 | 50k+ | Unsafe printing function | ||
| #1392 | Hash Form – Drag & Drop Form Builder | 41 | 9 | 275 | 3k+ | Non-prefixed global variable | ||
| #1393 | Multiple Themes | 41 | 112 | 41 | 10k+ | Output is not escaped | ||
| #1394 | Log cleaner for Solid Security | 41 | 65 | 47 | 8k+ | Text Domain Mismatch | ||
| #1395 | Mollie Forms | 41 | 14 | 565 | 3k+ | Request data is not unslashed | ||
| #1396 | Native Emoji | 41 | 54 | 37 | 5k+ | Unsafe printing function | ||
| #1397 | OSS Aliyun | 41 | 19 | 40 | 4k+ | Request data is not unslashed | ||
| #1398 | Page & Post Notes | 41 | 12 | 77 | 1k+ | Non-prefixed global variable | ||
| #1399 | Smart Post – Post Grid, Post Carousel, Post Slider Gutenberg Blocks for Blog & News | 41 | 537 | 20k+ | Non-prefixed global variable | |||
| #1400 | Simple Lightbox | 41 | 21 | 48 | 100k+ | Nonce verification recommended |
