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

RankPluginScoreErrorsWarningsInstallsUpdatedTop Issue
#651annasta Filters for WooCommerce321,0734412k+Text Domain Mismatch
#652Author Avatars List/Block32851354k+Non-prefixed hook name
#653Auto YouTube Importer323381731k+Text Domain Mismatch
#654Blog2Social: Social Media Auto Post & Scheduler32795550k+Direct Query
#655BuddyPress for LearnDash321902841k+Output is not escaped
#656Addi – Cuotas que se adaptan a ti321062102k+Direct Query
#657Fable Extra32792824k+Non-prefixed global variable
#658Freesoul Deactivate Plugins – Disable plugins on individual WordPress pages32537739k+Nonce verification recommended
#659Insights from Google PageSpeed3241447520k+Text Domain Mismatch
#660Gwolle Guestbook3226852820k+Output is not escaped
#661HurryTimer – An Scarcity and Urgency Countdown Timer for WordPress & WooCommerce3239614220k+Output is not escaped
#662ThumbPress – Compress Images, Manage Thumbnails, Detect Image Issues, WebP/AVIF, Lazy Loading, Hotlinking & More3210130830k+Non-prefixed global variable
#663MapPress Maps for WordPress3269413330k+Missing Arg Domain
#664DEPRECATED – Shipmondo – A complete shipping solution for WooCommerce321661195k+Output is not escaped
#665گرویتی فرم فارسی3219017420k+Text Domain Mismatch
#666TS Poll – Survey, Versus Poll, Image Poll, Video Poll325701714k+Text Domain Mismatch
#667Volunteer Sign Up Sheets329674011k+Output is not escaped
#668Quick Featured Images3243632350k+Non-prefixed global variable
#669Restrict Usernames Emails Characters323273671k+Output is not escaped
#670WowRevenue – Product Bundles & Bulk Discounts32192,0271k+Non-prefixed global variable
#671Revolut Gateway for WooCommerce32851576k+Input is not sanitized
#672Simple Ajax Chat – Add a Fast, Secure Chat Box321082662k+Output is not escaped
#673Stock Sync for WooCommerce323622321k+Text Domain Mismatch
#674Thrive Automator32848410k+SQL query is not prepared
#675Ultimate Store Kit – Addon For WooCommerce, EDD and Elementor32572934k+Post Not In exclude
#676WebwinkelKeur: Webshop keurmerk & reviews for WordPress32200474k+Short PHP open tag found
#677BEAR – Bulk Editor and Products Manager Professional for WooCommerce by Pluginus.Net32593340k+Non-prefixed global variable
#678wp-jalali322196610k+Text Domain Mismatch
#679SEOPress – AI SEO Plugin & On-site SEO32138429300k+Non-prefixed global variable
#680WP-Stats322371262k+Output is not escaped
#681Privacy Policy Generator – WPLP Legal Pages322640910k+Non-prefixed global variable
#682Advanced Forms for ACF331692783k+Non-prefixed hook name
#683Auto Listings – Car Listings & Car Dealership Plugin for WordPress33803212k+Non-prefixed global variable
#684Chartify – WordPress Chart Plugin33764113k+Non-prefixed global variable
#685ChatHelp – Click to Chat Button, WooCommerce Chat to Order & Floating Chat Form33572041k+Non-prefixed global variable
#686Companion Auto Update3315929850k+Direct Query
#687Companion Sitemap Generator – Simple, Smart, and SEO-Ready33118577k+Missing Translators Comment
#688EchBay Phonering Alo3374471k+Output is not escaped
#689Flipbox – Awesomes Flip Boxes Image Overlay334007,27910k+Input is not validated
#690ImageLinks – Interactive Image Builder with Hotspots33517901k+Text Domain Mismatch
#691ITRO Popup Plugin335911356k+Output is not escaped
#692Logo Showcase Ultimate – Logo Carousel, Logo Slider & Logo Grid332741063k+Text Domain Mismatch
#693Forms for Mailchimp by Optin Cat – Grow Your MailChimp List33711332k+Missing direct file access protection
#694MWB HubSpot for WooCommerce – CRM, Abandoned Cart, Email Marketing, Marketing Automation & Analytics33262797k+Non-prefixed global variable
#695MAS Companies For WP Job Manager33623081k+Non-prefixed hook name
#696News Announcement Scroll332372592k+Non-prefixed global variable
#697Frisbii Pay33912921k+Non-prefixed global variable
#698Schema & Structured Data for WP & AMP3363246100k+Non-prefixed global variable
#699SMTP2GO for WordPress – Email Made Easy3318611130k+Output is not escaped
#700Social Rocket – Social Sharing Plugin331,0162551k+Unsafe printing function