Макс

SELECT COUNT(pa.id) as nummo, nsi.name_short FROM lpu_nsi nsi,  patints_attachment pa  WHERE pa.mo_code=nsi.mo_code AND pa.nompod=nsi.nompod GROUP BY nsi.name_short

SELECT created_at,MAX(count) FROM analytics GROUP BY created_at ORDER BY created_at  LIMIT 5;

SELECT SUM(1) FROM (
SELECT COUNT(*)/2 FROM `work` WHERE `date_in` BETWEEN (SELECT UNIX_TIMESTAMP(NOW())+ 10740 SECOND) AND (SELECT UNIX_TIMESTAMP(NOW())+ 10800 SECOND) AND `kod`=0 
 UNION
(SELECT COUNT(*) FROM `work` WHERE `date_in` BETWEEN (SELECT UNIX_TIMESTAMP(NOW())+ 10740 SECOND) AND (SELECT UNIX_TIMESTAMP(NOW())+ 10800 SECOND)) AND `kod`>1 ))

Joins performed without indexes: 70

Disable secure-file-priv. This must be removed from startup and cannot be modified dynamically. To do this check your MySQL start up parameters (depending on platform) and my.ini.