I am trying to write a simple mysql query on this site that I am creating - I only need it to bring back to fields from one table. However the site is going to be multisite - which I am then cloning via your Pro Site and Blog Template plugins. I need the mysql query to only return the data related to each individual blog (rather than them all). I am using WP Business Intelligence to run the query but I cant figure out where to put the blog id placeholder.
This is the query I have got which works perfectly if you add the correct blog_id - but obviously I need this to be added in automatically.
SELECT campaign_name, amount FROM wp__charitable_campaign_donations
It says on WP Business Intelligence to use :blog_id as a placeholder - but I have no idea where to put that - and where I have tried does not work.