nike90
CREATE TABLE IF NOT EXISTS `actions` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`action` int(11) NOT NULL,
UNIQUE KEY `user_id_action_idx` (`user_id`, `action`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
select user_id, count(action) as actions_number
from actions
group by user_id
having actions_number = 3
_____________
Senior PHP developer: PHP5, MySQL, JavaScript, CakePHP, Yii/Yii2, Zend Framework, Smarty, XML/Xslt, JQuery, Jquery Mobile, Bootstrap, ExtJS, HTML, HTML5, CSS, Linux, SVN, Git, Memcached, Redis, MongoDB, Zend Guard, Ioncube, FFMpeg, PayPal, Webmoney, Qiwi, Facebook API, Vkontakte Api, Google API, Twitter Api, Steam Api.
Junior Android Developer: Android SDK, многопоточность, работа с HTTP запросами, JSON, SQLite, фрагменты.