Rsa97

UPDATE `nested_table` AS `n`
    JOIN `t_product` AS `t` ON `t`.`NAME` = `n`.`NAME`
    SET `n`.`CODE` = `t`.`CODE`

SELECT * 
    FROM (SELECT DISTINCT IF(`who1` = 'glados', `who2`, `who1`) AS `name`
            FROM `whois` 
            WHERE (`who1` = 'glados' OR `who2` = 'glados') 
                AND `who1` != `who2`)
        AS `who`
    LEFT JOIN `whereis` AS `where` ON `where`.`author` = `who`.`name`

private function isNormalFileSize($filename) {
    clearstatcache(TRUE, $filename); // сброс кэша
    return (file_exists($filename) && (filesize($filename) < 1048576));
}