Евгений Самсонов

git checkout dev
git cherry-pick <hash>

git checkout master
git reset --soft HEAD^

SELECT 
    u.*, 
    GROUP_CONCAT(DISTINCT p.phone) AS phones, 
    GROUP_CONCAT(DISTINCT e.email) AS emails
FROM users u
LEFT JOIN phones p ON p.user_id = u.id
LEFT JOIN emails e ON e.user_id = u.id
GROUP BY u.id;

<div id="template">
    <input type="text" class="lol">
</div>

SELECT *
FROM main m
LEFT JOIN extra e1 ON m.id = e1.main_id
LEFT JOIN extra e2 ON e1.main_id = e2.main_id AND e2.date > e1.date
WHERE e2.date IS NULL AND e1.status = 1;

string Encrypt(string encrypt)
{
    ...

$source = 'some
<a href="link">a</a>
some';

echo preg_replace('/<a href="(.*?)">.*?<\/a>/', '$1', $source);

var ter = "(255, 0, 0, 0.1)";
var rer = ter.match(/(\d+(.\d+)?)/g);
alert (rer);

SELECT *
FROM users u
WHERE NOT EXISTS (
    SELECT * 
    FROM transactions t 
    WHERE u.id = t.user_id AND sum < 0
    LIMIT 1
);

var re = /bb\ncc/gm, match;
while (match = re.exec(s)) {
    console.log(match);
}

SELECT * 
FROM `payments` 
WHERE `date` BETWEEN DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) AND DATE(NOW());

var params = {
    id: $(this).attr('data-id'),
    comment: $('#comments').val()
};

if (условия){
     что делаем
     return;
}

$resultArray = [];
foreach ($firstArray as $key) {
    if (isset($secondArray[$key])) {
        $resultArray[$key] = $secondArray[$key];
        unset($secondArray[$key]);
    }
}

$resultArray = array_merge($resultArray, $secondArray);