/{\%(.*?\%})\%}/i/{%([^{}%]*(?:(?R)|)[^{}%]*)%}/
SELECT `t2`.`number`, `t2`.`area` AS `newarea`, `t2`.`date` AS `lastdate`,
`t3`.`area` AS `oldarea`, `t3`.`date` AS `prevdate`
FROM (
SELECT `number`, MAX(`date`) AS `maxdate`
FROM `table`
GROUP BY `number`
) AS `t1`
JOIN `table` AS `t2` ON `t2`.`number` = `t1`.`number` AND `t2`.`date` = `t2`.`maxdate`
JOIN `table` AS `t3` ON `t3`.`number` = `t1`.`number` AND `t3`.`date` < `t3`.`maxdate`
AND `t3`.`area` < `t3`.`area`Options +FollowSymLinks
RewriteEngine On
RewriteRule ^$/categoriya[0-9]+/[0-9]+-(product-name[0-9]+).html /$1 [L,R=301]1 + 1 * 2 => <число(1)> <плюс> <число(2)> <умножить> <число(2)>
SELECT *
FROM (
SELECT `at`.`id_article` AS `id_article`, COUNT(*) AS `count`
FROM `article_tags` AS `at`
JOIN `tags` AS `t` ON `t`.`id` = `at`.`id_tag`
AND `t`.`name` IN ('Тег_10', 'Тег_11', 'Тег_12')
GROUP BY `id_article`
) AS `c`
JOIN `articles` AS `a` ON `a`.`id` = `c`.`id_article`
ORDER BY `c`.`count` DESCSET @id = 0;
UPDATE `tasks`
SET `state` = 'execute', `starttime` = NOW()
WHERE @id := `id` AND `state` = 'new'
ORDER BY `time`
LIMIT 1;
SELECT * FROM `tasks` WHERE `id` = @id;<input type="text" name="contact[]">. Тогда в PHP придёт массив значений $_POST['contact'][].<input type="file" name="f[]">. В обоих случаях обработка стандартная, через массив $_FILES