Добрый день!
Подскажите, пожалуйста, что и куда надо добавить в код

<?php
require_once '../core.php';
$tpl->assign("page", "log");
if (!$_SESSION['logged_in']) {
    header("Location: login.php");
    die();
}
if (isset($_GET['logout'])) {
    session_destroy();
    header("Location: index.php");
    die();
}

$q = mysql_query("SELECT * FROM log l
LEFT JOIN users u ON l.log_user = u.user_id
LEFT JOIN games g ON l.log_game  = g.game_id
LEFT JOIN tasks t ON l.log_task = t.task_id
ORDER BY l.log_id DESC LIMIT 100
");
while ($d = mysql_fetch_array($q)) {
    $res[] = $d;
}
$tpl->assign("res", $res);

$tpl->display("../template/admin/log2.html");
?>

Чтобы вывод логов был не из всей таблицы, а только если значение
game_id равно 6?
Я чтот совсем запуталась=((

было

$q = mysql_query("SELECT * FROM log l
LEFT JOIN users u ON l.log_user = u.user_id
LEFT JOIN games g ON l.log_game  = g.game_id
LEFT JOIN tasks t ON l.log_task = t.task_id
ORDER BY l.log_id DESC LIMIT 100
");

станет

$q = mysql_query("SELECT * FROM log l
LEFT JOIN users u ON l.log_user = u.user_id
LEFT JOIN games g ON l.log_game  = g.game_id
LEFT JOIN tasks t ON l.log_task = t.task_id
WHERE g.game_id = 6
ORDER BY l.log_id DESC LIMIT 100
");

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

$q = mysql_query("SELECT * FROM log l
LEFT JOIN users u ON l.log_user = u.user_id
LEFT JOIN games g ON l.log_game  = g.game_id
LEFT JOIN tasks t ON l.log_task = t.task_id
ORDER BY l.log_id DESC LIMIT 100
");

$q = mysql_query("SELECT * FROM log l
LEFT JOIN users u ON l.log_user = u.user_id
LEFT JOIN games g ON l.log_game  = g.game_id
LEFT JOIN tasks t ON l.log_task = t.task_id
WHERE g.game_id = 6
ORDER BY l.log_id DESC LIMIT 100
");