I'm using mysql. I have two tables, one is about movie type, and the other is about movie rating with timestamps. I want to join these two tables together with movie id to count the average rating for each type…
SQL optimization problem, which of the two solutions below is the most efficient? I have the table from the image, I need to group the data by CPF and date and know if the CPFs had at least one login_ok…
I'm trying to figure out why the outer query returns nothing if the second sub query has no return value even if the first does? SELECT * FROM ( SELECT category_id FROM story_category WHERE story_category.story_id = 9998 ) AS c,…
I tried to find the solution to this on Stackoverflow, maybe my wording is wrong. I have a query which takes to long to execute. I am sure there are simple ways to improve it. For example, I use the…
Server: MariaDB, version 10.4.17 Query: select something from (select 1, 2 as something) Error in phpMyAdmin: #1064 - Something is wrong in your syntax 'LIMIT 0, 25' Error in MySQL Workbench: You have an error in your SQL syntax; check…
enter image description here My table has data as shown in the picture. I selected the SiteInstanceID value based on a selection from another column "AttributeValue". SELECT `SiteInstanceID` FROM `sitecomponentattributevalues` WHERE `AttributeValue` = 00069 Now I want to select all…
So I currently have a database with the following structure: wp_giantbomb_game_list(post_id, important) wp_game_attribute_company(ID, important) wp_game_relation_publisher(ID, game_id, attribute_id) wp_game_relation_developer(ID, game_id, attribute_id) The important tag is a boolean that says whether or not a game is important. What I currently do is…