Как вытащить значение?

[Doctor_Chaos]

Есть такой запрос:

$q = $db->query("SELECT SQL_CALC_FOUND_ROWS `auto`.* , `mark`.`name` AS `mark`, `model`.`model`, `photo`.`path` AS `photo` , `firm`.`title` AS `salon`, `firm`.`id` AS `salon_id`, `city`.`city_name` AS `city`, `engine`.`drive_type` as `engine`
                    FROM `auto`
                    LEFT JOIN `mark` ON `mark`.`id` = `auto`.`mark_id`
                    LEFT JOIN `model` ON `model`.`id` = `auto`.`model_id`
                    LEFT JOIN `photo` ON `photo`.`auto_id` = `auto`.`id`
                    LEFT JOIN `firm` ON `firm`.`user_id` = `auto`.`user_id`
                    LEFT JOIN `city` ON `city`.`id` = `auto`.`city_id`
                        LEFT JOIN `engine` ON `engine`.`id` = `auto`.`engine_id`
                    WHERE {$sql_add}
                    GROUP BY `auto`.`id`
                    ORDER BY vip_time DESC, {$order}

                    LIMIT {$limit_start}, {$limit}");

    $total_q = $db->query("SELECT FOUND_ROWS() AS `total`");
    $total = $db->get_row($total_q);
    $adverts_num = $total['total'];

    $i = 0;
    $items = array();

    while ($item = $db->get_row($q)) {
  $items[$i]['photo'] = $item['photo'];
}

В таблице photo для одного id массив path состоит из 6 фотографий. Как сделать запрос, чтобы из в запросе брался не последний, а первый элемент массива?

 

[segalp]

$q = $db->query("SELECT SQL_CALC_FOUND_ROWS `auto`.* , `mark`.`name` AS `mark`, `model`.`model`, (SELECT `photo`.`path` FROM `photo` WHERE `photo`.`auto_id` = `auto`.`id` ORDER BY `photo`.`id` ASC LIMIT 1) AS `photo` , `firm`.`title` AS `salon`, `firm`.`id` AS `salon_id`, `city`.`city_name` AS `city`, `engine`.`drive_type` as `engine`
FROM `auto`
LEFT JOIN `mark` ON `mark`.`id` = `auto`.`mark_id`
LEFT JOIN `model` ON `model`.`id` = `auto`.`model_id`
LEFT JOIN `firm` ON `firm`.`user_id` = `auto`.`user_id`
LEFT JOIN `city` ON `city`.`id` = `auto`.`city_id`
LEFT JOIN `engine` ON `engine`.`id` = `auto`.`engine_id`
WHERE {$sql_add}
GROUP BY `auto`.`id`
ORDER BY vip_time DESC, {$order}

LIMIT {$limit_start}, {$limit}");