SELECT org.id AS OrganizationId, org.LastChange AS OrganizationLastChange, org.Registrationdate AS OrganizationRegDate, org.Name AS OrganizationName, org.Important AS OrganizationImportant, org.Site AS OrganizationSite, fst.name as OrganizationStatusName, fty.name as OrganizationTypeName, fgr.name as OrganizationGroupName, fci.name as OrganizationCityName, ffo.name as OrganizationFormName, fus.login as OrganizationOpenUserName, OldComment.date as CommentDate, OldComment.alarm as CommentAlarmClock, OldComment.alarm_active AS CommentAlarmClockActive, OldComment.login as CommentUser, OldComment.commenttext As CommentText, OldContact.FIO as ContactName, OldContact.vacancy AS ContactVacancy, OldContact.phone1 AS ContactPhone1, OldContact.phone2 AS ContactPhone2, OldContact.mail AS ContactMail
FROM data_organization AS org
LEFT JOIN (
SELECT * 
FROM(
SELECT data_comment.id,data_comment.date,data_comment.LastChange, data_comment.organization, data_comment.alarm, data_comment.alarm_active, filter_user.login, data_comment.commenttext, data_comment.meta, data_comment.type
FROM data_comment LEFT JOIN Filter_User ON filter_user.id=data_comment.user
ORDER BY data_comment.date DESC
) AS CommentsByDate
GROUP BY CommentsByDate.organization
) AS OldComment 
ON OldComment.organization = org.id
LEFT JOIN(
SELECT *
FROM (
SELECT * FROM data_contact
ORDER BY data_contact.prioriti DESC
) AS ContactPrioriti
GROUP BY ContactPrioriti.organization
) AS OldContact
ON OldContact.organization = org.id
LEFT JOIN Filter_User AS fus
ON org.User=fus.id
LEFT JOIN Filter_Status AS fst
ON org.status=fst.id
LEFT JOIN Filter_Form AS ffo
ON org.form=ffo.id
LEFT JOIN Filter_Type AS fty
ON org.type=fty.id
LEFT JOIN Filter_City AS fci
ON org.city=fci.id
LEFT JOIN Filter_Group AS fgr
ON org.group=fgr.id
WHERE org.LastChange > '2012-02-01 0:00:00'
ORDER BY fst.priority;