SELECT
pd.pid
FROM
promisers_data pd
INNER JOIN promisers_data pd2 ON pd.pid = pd2.pid
WHERE 1
AND (pd.key='family' AND pd.value LIKE '%Иванов%')
AND (pd2.key='name' AND pd2.value LIKE '%Иван%')
$sql = "SELECT COUNT(*) FROM `categlist` WHERE `Code`=?"; # use bind!
set @id=UUID();
insert into categlist(id, <col2>) values (@id, 'another value');
select @id;
SELECT DATE(FROM_UNIXTIME(`created_at`)) AS thedate, MAX(count) FROM analytics WHERE DATE(FROM_UNIXTIME(CURRENT_TIMESTAMP)) = DATE(FROM_UNIXTIME(`created_at`)) GROUP BY DATE(FROM_UNIXTIME(`created_at`))
UNION ALL
SELECT DATE(FROM_UNIXTIME(`created_at`)) AS thedate, MAX(count) FROM analytics WHERE DATE(FROM_UNIXTIME(CURRENT_TIMESTAMP - day)) = DATE(FROM_UNIXTIME(`created_at`)) GROUP BY DATE(FROM_UNIXTIME(`created_at`))
UNION ALL
SELECT DATE(FROM_UNIXTIME(`created_at`)) AS thedate, MAX(count) FROM analytics WHERE DATE(FROM_UNIXTIME(CURRENT_TIMESTAMP - 2days)) = DATE(FROM_UNIXTIME(`created_at`)) GROUP BY DATE(FROM_UNIXTIME(`created_at`))
UNION ALL
SELECT DATE(FROM_UNIXTIME(`created_at`)) AS thedate, MAX(count) FROM analytics WHERE DATE(FROM_UNIXTIME(CURRENT_TIMESTAMP - 3days)) = DATE(FROM_UNIXTIME(`created_at`)) GROUP BY DATE(FROM_UNIXTIME(`created_at`))
UNION ALL
SELECT DATE(FROM_UNIXTIME(`created_at`)) AS thedate, MAX(count) FROM analytics WHERE DATE(FROM_UNIXTIME(CURRENT_TIMESTAMP - 4days)) = DATE(FROM_UNIXTIME(`created_at`)) GROUP BY DATE(FROM_UNIXTIME(`created_at`))