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
#551Smash Balloon Social Photo Feed – Easy Social Feeds Plugin254491,3001m+Interpolated SQL is not prepared
#552IP Location Block2552162410k+Output is not escaped
#553JobWP – Job Board, Job Listing, Career Page and Recruitment Plugin251,5411,5781k+Non-prefixed global variable
#554JoomSport – for Sports: Team & League, Football, Hockey & more255231,7471k+Direct Query
#555Knit Pay – Cashfree, Instamojo, Razorpay, PayPal and more254,0191,2652k+Text Domain Mismatch
#556Live Composer – Free WordPress Website Builder251,21642710k+Output is not escaped
#557Logo Showcase – Responsive Logo Carousel, Logo Slider & Logo Grid256561,5065k+Non-prefixed global variable
#558Bulk Page Generator – LPagery256701,9263k+Non-prefixed global variable
#559MaxButtons – Create buttons2562640470k+Output is not escaped
#560Media Cleaner: Clean your WordPress!2515139190k+Direct Query
#561Media Cloud Sync251,0952741k+Exception output is not escaped
#562Create251,6377646k+Text Domain Mismatch
#563Multibanco / MB Way / Payshop / Cofidis Pay (by LUSOPAY) for WooCommerce25492216400Text Domain Mismatch
#564All-in-one Sticky Floating Contact Form, Call, Click to Chat, and 50+ Social Icon Tabs – My Sticky Elements2535259740k+Non-prefixed global variable
#565Nexter Extension – Security, Performance, Code Snippets & Site Toolkit2519871210k+Nonce verification recommended
#566NotificationX – FOMO, Live Sales Notification, WooCommerce Sales Popup, GDPR, Social Proof, Announcement Banner & Floating Notification Bar2525740040k+Non-prefixed hook name
#567Notifications for Forms & WordPress Actions253092821k+Text Domain Mismatch
#568Object Sync for Salesforce25192296500Non-prefixed global variable
#569Password Protected — Lock Entire Site, Pages, Posts, Categories, and Partial Content256811,513300k+Non-prefixed global variable
#570PDF Invoice for WooCommerce + Drag and Drop Template Builder251,008216400wp function not compatible with requires wp
#571phpinfo() WP — Site Health, PHP Compatibility & Server Audit252767043k+Non-prefixed global variable
#572Poll Maker by AYS – Versus Polls, Anonymous Polls, Image Polls254881,4127k+Non-prefixed global variable
#573Post Snippets – Custom WordPress Code Snippets Customizer258081,65420k+Non-prefixed global variable
#574Premmerce Product Search for WooCommerce255961,350900Non-prefixed global variable
#575Premmerce Wholesale Pricing for WooCommerce256351,377400Non-prefixed global variable
#576Quiz Maker by AYS255053,02320k+Non-prefixed global variable
#577Quttera ThreatSign – Web Malware Scanner for WordPress2533447110k+Non-prefixed global variable
#578reSmush.it : The original free image compressor and optimizer plugin2515569100k+Output is not escaped
#579The School Management – Education & Learning ERP2512,858800Non-prefixed global variable
#580Secure Copy Content Protection and Content Locking2595879920k+Output is not escaped
#581SEO Booster253931,4681k+Non-prefixed global variable
#582SEO Repair Kit – Meta Manager, Schema Manager, SEO Content Monitoring, GSC Integration, Keyword & Rank Tracking251969022k+Direct Query
#583ShopMagic – email automation2522814510k+Exception output is not escaped
#584Simple Link Directory – AI Powered251334202k+Non-prefixed global variable
#585Appointment Booking Calendar — Simply Schedule Appointments Booking Plugin2595873860k+Text Domain Mismatch
#586Simply Static – The Static Site Generator2516544830k+Non-prefixed hook name
#587Affiliate Program Suite — SliceWP Affiliates251,2912,08910k+Output is not escaped
#588Smart Image Resize for WooCommerce255824047k+Text Domain Mismatch
#589Smart Manager – Advanced WooCommerce Bulk Edit & Inventory Management2536692310k+SQL query is not prepared
#590Stylish Cost Calculator – Quote Generator, Lead Gen & Price Estimator256481,0211k+Output is not escaped
#591SupportCandy – AI Customer Support Ticket System & Live Chatbot Agent254321,35710k+Direct Query
#592SureDash – Community, Courses & Member Dashboard254228051k+Non-prefixed global variable
#593Survey Maker by AYS255672,3976k+Non-prefixed global variable
#594Taskbuilder – Project Management & Task Management Tool With Kanban Board251274,332800Non-prefixed global variable
#595Toocheke Companion254091,1141k+Non-prefixed global variable
#596Travelly – Tour & Travel Booking Manager for WooCommerce | Tour & Hotel Booking Solution251737261k+Non-prefixed global variable
#597Tourfic – AI Powered Travel Booking, Hotel Booking & Car Rental WordPress Plugin251192,7042k+Non-prefixed global variable
#598TrackShip for WooCommerce254219576k+Non-prefixed global variable
#599TranslatePress – Translate Multilingual sites with AI Translation254551,545400k+Non-prefixed function
#600TrueBooker – Appointment Booking and Scheduler System255292,746600Non-prefixed global variable