SELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5check
SELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5check
SELECT username, lng, lat, city FROM `users` WHERE lng != '' AND lat != '' LIMIT 100