select max(state_change_date) from states where state_change_date<="2015-02-01" group by thing_id
select * from states where state_change_date<="2015-02-01"$db = new mysqli("localhost", "root", "", "gallery");
$items = $db->query ("SELECT * FROM table");
while ($row = $items->fetch_assoc())
{
if ($row['g_id'] != 1) continue;
echo '
<img src="'.$row["img_1"].'" alt="">
<img src="'.$row["img_2"].'" alt="">
<textarea readonly name="text" placeholder="размеры">'.$row["text"].'</textarea>';
}$db = new mysqli("localhost", "root", "", "gallery");
$items = $db->query ("SELECT * FROM table");
$itemsByG = array();
while ($row = $items->fetch_assoc())
{
if(!isset($itemsByG[$row['g_id']]))
{
$itemsByG[$row['g_id']] = array();
}
$itemsByG[$row['g_id']][] = $row;
}соответственно на выходе получить список записей, у который user_id < id по первой таблице и эти выбранные user_id не присутствуют во второй таблице
SELECT * FROM items WHERE category_id IN (SELECT_CATS)
UNION
SELECT * FROM items WHERE item_id = (SELECT item_id FROM cats_bind WHERE cat_id IN (SELECT_CATS))SELECT DATE_FORMAT(column_name, '%d/%m/%Y') FROM tablenameselect * from favorite_suppliers where user_id = 1 and supplier_id in
(
select friend_id from friend_requests where user_id = 1
)
UNION
select * from favorite_suppliers where user_id = 1WHERE
(prop2article.prop_id = 1 and prop2article.prop_value_id = 1)
AND
(prop2article.prop_id = 2 and prop2article.prop_value_id = 3)WHERE
(prop2article.prop_id = 1 and prop2article.prop_value_id = 1)
OR
(prop2article.prop_id = 2 and prop2article.prop_value_id = 3)