SELECT users.*, roles.name AS rolename , CONCAT(usersExtra.name, ' ', usersExtra.last_name) AS userName,
                        usersExtra.gender, usersExtra.country, usersExtra.activeness,
	                    CASE
	                        WHEN (users.last_action BETWEEN DATE_ADD(NOW(), INTERVAL -5 MINUTE) AND NOW() )
	                                AND users.exitmark != 'exit'
	                            THEN 1
	                        WHEN (users.last_action BETWEEN DATE_ADD(NOW(), INTERVAL -7 DAY) AND DATE_ADD(NOW(), INTERVAL -5 MINUTE))
	                                OR
	                             ((users.last_action BETWEEN DATE_ADD(NOW(), INTERVAL -5 MINUTE) AND NOW() )
	                                AND users.exitmark = 'exit')
	                            THEN 2
	                        WHEN users.last_action BETWEEN DATE_ADD(NOW(), INTERVAL -31 DAY) AND DATE_ADD(NOW(), INTERVAL -8 DAY)
	                            THEN 3
	                        WHEN users.last_action BETWEEN DATE_ADD(NOW(), INTERVAL -182 DAY) AND DATE_ADD(NOW(), INTERVAL -32 DAY)
	                            THEN 4
	                        ELSE 5
	                    END AS lastVisitMarker
                    FROM 
                usersExtra
                LEFT JOIN roles ON users.id_role = roles.id
                LEFT JOIN users ON usersExtra.id = users.id
            
                    
                    
                        WHERE users.id_role != 1 AND users.deleted != 'deleted'
                        ORDER BY usersExtra.activeness ASC,last_name ASC
                        LIMIT 0, 20