Apparently both wattp_users and wattp2_as_score tables have a column named score_as.
Put a prefix with the table name before every mention to score_as column, just as you did with the ID (e.g. wattp2_users.ID) to avoid beeing ambiguous.
Related Posts:
- Transaction when using WP functions rather than vanilla SQL?
- How to get the list of WooCommerce product image of a certain category from database?
- How to make WordPress plugin check for database changes and then do something?
- How to Join two tables from separate databases within WordPress
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- register_activation_hook isn’t adding table to DB
- What SQL / WordPress queries would need a nonce?
- Importing Geo data into wordpress database
- WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
- $wpdb->insert() does not Insert record in a table
- Use $wpdb or other PHP script method to find/replace in WP database
- How can I add a new row in a separate database when someone registers via WordPress?
- Use variable in SQL statement
- mySQL queries are executed twice on wordpress website
- making php value numeric
- Database SQL query error
- How to run complex query using PHP
- Inserting other fields to existing registration form in a WordPress theme
- SQL Query Search page
- can’t delete a row from post_meta table
- Conditional statement within WP SQL query
- SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
- dbDelta support for FOREIGN KEY
- is it possible to run some php code within a wordpress page?
- How to correctly submit a search form and display the result in an independent page
- How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
- Does WordPress cache get_user_meta() results?
- Using Echo in ShortCode – Stuck
- Database “Migration” for Plugins?
- No wp-config.php file on local install of wordpress – site still displays
- Use ajax to update_post_meta
- Automatically generate Post/Page from searched Database item?
- List of posts by day of the week
- How to display posts of specific category using a custom Query in WordPress?
- Is the outdated PHP mysql extension a requirement for WordPress 4.6?
- Different database query in function.php using mysqli
- Why is variable not working on custom sql query using wpdb?
- How can I export posts with featured images, without download them
- How to securely provide a $_POST var in WP_Query with PHP 7?
- Create WP_Query to search for posts by their categories or their parent/child categories
- WSoD being caused by this piece of code
- How to display data from custom table in wordpress phpmyadmin
- Calculating a large number of MYSQL queries as customshort codes, slow
- Update results, Before deleting the related category [closed]
- Sum the total amount of a specific product purchased per user and display in table
- Replacing mysql_escape_string in a custom plugin when moving to PHP7
- Weird 404 URL Problem – domain name being placed at end of urls
- database sent to a JSON file
- WordPress SQL injection
- multiple where condition in result query
- Grouping posts by a custom meta value
- Mixing variables into an array when inserting values
- wpdb prepare insert table doesn’t work
- Make a database query using WordPress
- dynamic page using php from sql database
- I can’t update my data through $wpdb
- Output: “Array”
- Using wordpress function to retrieve data
- form $_post action value gets truncated after it passes through two forms
- Add row to custom database Table and delete all rows older than 1 day
- Using color schemes with Color Picker
- populate select options from extra mysql table data
- get different meta-data of a complicated query at the same time
- Please help! I have a problem with getting wordpress databas
- Build A Custom SQL Query for WordPress Search
- Storing huge number of users in wordpress
- Creating multiple tables with Plugin
- Custom User registration system
- How to use Multi SQL Database in WordPress?
- Usermeta data unserialize, extract and display in table in WordPress
- Conditional formatting on data fetched from MYSQL
- Can I split a huge wp_postmeta table across different databases or servers?
- I can’t separate the array by commas
- WordPress mysql deos not work with php7
- How can i limit the number of posts to the most recent 6 in my query?
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- WP + MySql db / PHP
- The plugin generated 225 characters of unexpected output during activation
- append data to mysql table via submit button coded in php – not working
- WordPress select query issue
- How to do a MySql query in WordPress?
- Add two or multiple functions in WordPress Post or Page
- direct query to post_meta table
- What to create new post using wp_insert_post, but it repeat the post infinitely
- Send data from plugin to external database
- How to set max users to 17.000
- Passed variable gets undefined variable error on insert on next page
- directorypress theme error mysql_error() [closed]
- How to set up an auto delete post?
- See output of a sql query while plugin installation in wordpress
- Querying multiple meta_keys in WordPress SQL query
- How can I order metaboxes in my posts in WordPress?
- Cannot Upload Custom Header Image into WordPress Dashboard
- MySQL update text field with ‘
- Predefine Magazine Style Layouts
- Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
- Execute multiple PHP Snippets causes error?
- How to sort search result by post_title, then by post_content
- what to do after instlling cyberpanel on VPS
- Can’t insert into a database wordpress