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
#201BuddyPress235849,012100k+Non-prefixed function
#202Announcement & Notification Banner – Bulletin239301,5762k+Non-prefixed global variable
#203Business Directory Plugin – Easy Listing Directories for WordPress236111,06310k+Non-prefixed global variable
#204Geo Controller23914501k+Non-prefixed global variable
#205All In One Login — Login Page Security and Customization for WordPress with Google reCAPTCHA, Social Login, Temporary Login, 2FA, and more.237501,35960k+Non-prefixed global variable
#206WPBot – AI ChatBot for Live Support, Lead Generation, AI Services234881,1625k+Non-prefixed global variable
#207Classified Listing – AI-Powered Classified ads & Business Directory231552,0749k+Non-prefixed global variable
#208CLUEVO LMS, E-Learning Platform231,8431,176400Text Domain Mismatch
#209Content Aware Sidebars – Fastest Widget Area Plugin239931,73830k+Non-prefixed global variable
#210Content Egg – Affiliate Product Importer & Price Comparison231,2451,27510k+Non-prefixed global variable
#211Contest Gallery – Upload & Vote Photos, Media, Sell with PayPal & Stripe239,31526,6441k+Non-prefixed global variable
#212Free Theme Builder for Elementor – CRT Addons (Header, Footer, Archive, WooCommerce & 50+ Widgets)237912,331400Non-prefixed global variable
#213Easy Digital Downloads – eCommerce Payments and Subscriptions made easy233,72310,28340k+Non-prefixed namespace
#214EazyDocs – AI Powered Knowledge Base, Wiki, Documentation & FAQ Builder233551,5412k+Non-prefixed global variable
#215ElementsReady Addons for Elementor232316663k+Non-prefixed global variable
#216Error Log Monitor236941,41420k+Non-prefixed global variable
#217Essential Real Estate235295,0608k+Non-prefixed global variable
#218Everest Forms – Contact Form, Payment Form, Quiz, Survey & Custom Form Builder with AI233951,34290k+Non-prefixed global variable
#219Spreadsheet Price Changer for WooCommerce and WP E-commerce – Light23386999400Non-prefixed global variable
#220Ezoic2343251610k+Output is not escaped
#221Finpose – Accounting for WooCommerce231,6491,307400Non-prefixed global variable
#222Image Photo Gallery Final Tiles Grid235781,50220k+Non-prefixed global variable
#223Freshdesk (official)23194386900Non-prefixed function
#224Front End PM239782,2645k+Non-prefixed global variable
#225Tracking and Consent Manager – WP Full Picture231,2803,2233k+Non-prefixed global variable
#226FV Flowplayer Video Player231,3111,45420k+Output is not escaped
#227GamiPress – Gamification plugin to reward points, achievements, badges & ranks in WordPress233,5892,76010k+Output is not escaped
#228The GDPR Framework By Data443231,28751710k+Short PHP open tag found
#229Anti-Malware Security and Brute-Force Firewall23543965100k+Output is not escaped
#230Gmedia Photo Gallery233501,1217k+Non-prefixed global variable
#231Groundhogg — CRM, Newsletters, and Marketing Automation231369212k+Non-prefixed global variable
#232Interactive Content – H5P2356538040k+Non Singular String Literal Domain
#233Ibtana – Ecommerce Product Addons231,5471,7186k+Non Singular String Literal Domain
#234Payment forms, Buy now buttons, and Invoicing System | GetPaid233891,2665k+Non-prefixed global variable
#235IP Geo Block233995898k+Output is not escaped
#236Jeg Kit for Elementor – Powerful Addons for Elementor, Widgets & Templates for WordPress2391694300k+Non-prefixed namespace
#237Joli FAQ SEO – WordPress FAQ Plugin231,0831,526700Non-prefixed global variable
#238Justified Gallery235891,4178k+Non-prefixed global variable
#239King Addons for Elementor – 80+ Elementor Widgets, 4 000+ Elementor Templates, WooCommerce, Mega Menu, Popup Builder231,8343,87710k+Non-prefixed global variable
#240Masteriyo LMS – LMS Course Builder, Quizzes & Certificates231902,1225k+Non-prefixed global variable
#241License Manager for WooCommerce231297976k+Nonce verification recommended
#242Like Button Rating ♥ LikeBtn231,2316174k+Unsafe printing function
#243Link Whisper Free233,8825,30330k+Text Domain Mismatch
#244LLMagnet – AI Visibility & AI SEO for Claude, ChatGPT & More236271,798400Non-prefixed global variable
#245Master Addons For Elementor – Widgets, Extensions, Theme Builder, Popup Builder & Template Kits235251,54130k+Non-prefixed global variable
#246Master Slider – Responsive Touch Slider2380040860k+Output is not escaped
#247Media Library Assistant231,1313,75970k+Nonce verification recommended
#248MediaPress239045834k+Output is not escaped
#249Order Bump for WooCommerce231,7201,562600Output is not escaped
#250Moloni239013562k+Missing Arg Domain