select meta.meta_value, game.title
from game
join (SELECT game.id as id_games, max(meta.id) as id_meta
FROM meta
JOIN game ON game.id = meta.id_game and game.month = 2 AND game.year = 2016
WHERE meta.meta_key = 'video'
GROUP BY game.id
ORDER BY game.score + game.like DESC LIMIT 10) A on A.id_games=game.id
join meta on meta.id=A.id_meta
Почему при выводе, напримерstd :: cout << cStr ;
Выводится "string" , то есть значение, а не адрес значения как обычно с указателями ?
select c1.category_name, g.Goods_name
from goods as g
left join category as c on c.id_category = g.id_category
left join category as c1 on c1.id_category = с.parent_Id