WordPress.DB.PreparedSQL.InterpolatedNotPrepared

Interpolated SQL is not prepared

Variables are interpolated into a SQL string before the query is prepared.

critical weight

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.

Affected Plugins

RankPluginScoreErrorsWarningsInstallsAddedUpdatedTop Issue
#951Reviews Plus332233781k+Non-prefixed function
#952Schema & Structured Data for WP & AMP3363246100k+Non-prefixed global variable
#953SMTP2GO for WordPress – Email Made Easy3318611130k+Output is not escaped
#954Social Rocket – Social Sharing Plugin331,0162551k+Unsafe printing function
#955Spin Wheel – Interactive spinning wheel that offers coupons33680313500Unsafe printing function
#956Simple Sticky Add To Cart For WooCommerce3340170900Text Domain Mismatch
#957Sublanguage33266287700Output is not escaped
#958Uix Shortcodes33246444400Non-prefixed global variable
#959Website Monetization by MageNet33608720k+Output is not escaped
#960Rich Showcase for Google Reviews33213278100k+Output is not escaped
#961Wonder Slider Lite332731878k+Output is not escaped
#962Product Addons for Woocommerce – Product Options with Custom Fields3312411430k+Output is not escaped
#963CartBounty – Save and recover abandoned carts for WooCommerce3337039910k+Output is not escaped
#964Pay. Payment Methods for WooCommerce333181043k+Non Singular String Literal Domain
#965WOW Slider331761013k+Output is not escaped
#966Books Gallery – Book Showcase, Library & Affiliate Plugin331,7531782k+Output is not escaped
#967WP Edit3333713740k+Unsafe printing function
#968Connector for Gravity Forms and Google Sheets336921553k+Text Domain Mismatch
#969WP Multilang – Translation and Multilingual Plugin335311810k+Database parameter is not escaped
#970Paymattic – Secure, Simple Payment & Donation with Subscription Payments, Recurring Donations, Customer Management335383k+Direct Query
#971WP-UserOnline3311116110k+Output is not escaped
#972WPReplace内容字符替换插件33209195800Non Singular String Literal Domain
#973XML Sitemaps3365622k+Output is not escaped
#974Assistant – Every Day Productivity Apps34124974k+Exception output is not escaped
#975Audit Trail349010710k+Unsafe printing function
#976Automatic YouTube Gallery – Embed Auto-Updating YouTube Video Galleries, Feeds, Playlists & Channels34862559k+Direct Query
#977Bayarcash WooCommerce34148138700Non Singular String Literal Domain
#978Buckets346876500Output is not escaped
#979Cornerstone3416117430k+Nonce verification recommended
#980CSS JS Manager, Async JavaScript, Defer Render Blocking CSS34761061k+Input is not validated
#981Debug Log Manager Tool34441433k+Nonce verification recommended
#982Download After Email – Subscribe & Download Form Plugin34223567k+Input is not validated
#983Dr. Flex3483511k+Output is not escaped
#984Easy Social Sharing34162401k+Non-prefixed global variable
#985Einsatzverwaltung341521281k+Output is not escaped
#986ePayco Plugin for WooCommerce341551363k+Text Domain Mismatch
#987Flash Toolkit3415824210k+Non-prefixed global variable
#988Floating Side Tab3494153600Non-prefixed global variable
#989FluentAuth – The Ultimate Authorization & Security Plugin for WordPress344422910k+Nonce verification recommended
#990Geliver Akıllı Kargo Pazaryeri3449247400Non-prefixed global variable
#991APG Google Video Sitemap Feed349645800Output is not escaped
#992Gratisfaction- Loyalty, Rewards , Referral, Birthday and Giveaway Program34131352600Missing nonce verification
#993Signature Add-On for Gravity Forms34161481k+Text Domain Mismatch
#994HollerBox — Fast & Effective Popups & Lead-Generation3478922k+Output is not escaped
#995Inavii Social Feed – Live Social Proof Gallery345321809k+Text Domain Mismatch
#996Lenix Leads Collector3441424210k+Text Domain Mismatch
#997Login with Vipps and MobilePay34263174900Output is not escaped
#998Mass Ping Tool for SEO – WordPress ping list to get indexed faster on Google, Yandex, …347796400Output is not escaped
#999Montonio for WooCommerce344425710k+Non-prefixed global variable
#1000Multi Step Form342771369k+Output is not escaped