/usr/sbin/mysqld, Version: 5.5.41-0ubuntu0.12.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 150128 6:25:43 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 225.593680 Lock_time: 0.000133 Rows_sent: 0 Rows_examined: 236521 use kkkkkkk; SET timestamp=1422422743; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '192','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3075','751','1477','2410','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3653','3445','282','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','1783','2233','1946','836','44','381','3677','1557','1917','1361','3859','2886','3500','3932','3739','2519','967' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '192','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3075','751','1477','2410','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3653','3445','282','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','1783','2233','1946','836','44','381','3677','1557','1917','1361','3859','2886','3500','3932','3739','2519','967' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 7:30:32 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 213.935139 Lock_time: 0.000173 Rows_sent: 0 Rows_examined: 236522 SET timestamp=1422426632; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '3602','2520','790','3557','1074','3774','2789','3890','86','3670','2300','371','2898','2587','756','1991','73','2904','2401','3930','1724','2337','3615','598','360','3803','504','903','3880','2732','2594','3180','576','1092','3722','2581','2504','3166','3939','362','2430','831','288','3411','3181','484','125','1240','1536','179','3923','1491','973','3854','2653','1909','1109','3187','2557','1182','2993','2834','1366','1583','3506','2622','3417','1301','3307','2252','3787','35','3824','2379','2961','1488','3603','2045','845','2429','3140','3937','3047','2325','2269','764','3231','2395','3517','3936','219','3875','3579','3889','3574','2783','3735','1392','713','3838' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '3602','2520','790','3557','1074','3774','2789','3890','86','3670','2300','371','2898','2587','756','1991','73','2904','2401','3930','1724','2337','3615','598','360','3803','504','903','3880','2732','2594','3180','576','1092','3722','2581','2504','3166','3939','362','2430','831','288','3411','3181','484','125','1240','1536','179','3923','1491','973','3854','2653','1909','1109','3187','2557','1182','2993','2834','1366','1583','3506','2622','3417','1301','3307','2252','3787','35','3824','2379','2961','1488','3603','2045','845','2429','3140','3937','3047','2325','2269','764','3231','2395','3517','3936','219','3875','3579','3889','3574','2783','3735','1392','713','3838' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 7:35:55 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 236.793277 Lock_time: 0.000221 Rows_sent: 0 Rows_examined: 236523 SET timestamp=1422426955; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '2398','2773','2030','3647','3745','1447','3927','687','3959','66','579','3528','163','3396','3898','2719','3850','3942','1497','2421','131','1459','3272','437','3321','3945','3916','2375','3275','2637','2136','259','694','861','769','3651','3227','1866','2996','931','3957','1430','3143','2561','107','1704','418','2883','3686','3385','2646','1766','1077','3958','91','3963','2569','1025','2567','3964','2830','596','2484','1499','2253','1375','236','3793','1252','188','949','1142','187','2154','3079','1463','2396','3935','2872','2480','3780','1795','3960','3258','31','1138','1674','3317','3100','3812','1132','2660','2481','1076','3955','1226','3055','655','3007','821' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '2398','2773','2030','3647','3745','1447','3927','687','3959','66','579','3528','163','3396','3898','2719','3850','3942','1497','2421','131','1459','3272','437','3321','3945','3916','2375','3275','2637','2136','259','694','861','769','3651','3227','1866','2996','931','3957','1430','3143','2561','107','1704','418','2883','3686','3385','2646','1766','1077','3958','91','3963','2569','1025','2567','3964','2830','596','2484','1499','2253','1375','236','3793','1252','188','949','1142','187','2154','3079','1463','2396','3935','2872','2480','3780','1795','3960','3258','31','1138','1674','3317','3100','3812','1132','2660','2481','1076','3955','1226','3055','655','3007','821' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 7:39:26 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 208.080902 Lock_time: 0.000373 Rows_sent: 0 Rows_examined: 236523 SET timestamp=1422427166; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '2410','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3075','751','192','1477','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3653','3445','282','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','1783','2233','1946','836','44','381','3677','1557','1917','1361','3859','2886','3500','3932','3739','2519','967' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '2410','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3075','751','192','1477','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3653','3445','282','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','1783','2233','1946','836','44','381','3677','1557','1917','1361','3859','2886','3500','3932','3739','2519','967' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 8:50:36 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 218.172134 Lock_time: 0.000187 Rows_sent: 0 Rows_examined: 236530 SET timestamp=1422431436; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '125','2300','2520','790','3557','1074','3774','2789','3890','86','371','2898','2337','3602','2587','756','1991','73','2904','2401','3930','1724','3670','3615','1092','360','3803','504','903','3880','2732','2594','3180','3722','2581','3181','598','2504','3166','3939','362','2430','831','288','3411','576','3579','3707','3187','1536','179','3923','1491','973','3854','2653','1909','2557','1182','3307','1240','2993','2834','1366','1583','3506','2622','3417','1301','1109','2252','3140','35','3824','2379','2961','1488','3603','2045','845','3937','3047','3875','3787','2325','2269','764','3231','2395','3517','3936','219','2429','484','3889','3574','2783','3735','1392','713' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '125','2300','2520','790','3557','1074','3774','2789','3890','86','371','2898','2337','3602','2587','756','1991','73','2904','2401','3930','1724','3670','3615','1092','360','3803','504','903','3880','2732','2594','3180','3722','2581','3181','598','2504','3166','3939','362','2430','831','288','3411','576','3579','3707','3187','1536','179','3923','1491','973','3854','2653','1909','2557','1182','3307','1240','2993','2834','1366','1583','3506','2622','3417','1301','1109','2252','3140','35','3824','2379','2961','1488','3603','2045','845','3937','3047','3875','3787','2325','2269','764','3231','2395','3517','3936','219','2429','484','3889','3574','2783','3735','1392','713' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 8:56:35 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 217.012048 Lock_time: 0.000191 Rows_sent: 0 Rows_examined: 236530 SET timestamp=1422431795; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '163','2030','3647','3745','1447','3927','687','3959','131','2773','66','579','3396','3898','2719','3850','3942','1497','2421','3528','1459','3272','769','3321','3945','3916','2375','3275','2637','2136','3143','437','259','694','3651','3227','1866','2996','931','3957','1430','861','1674','3963','1704','418','2883','3686','3385','2646','1766','1499','107','1077','3958','2569','1025','2567','3964','2830','596','2484','91','2253','1375','3935','3793','1252','188','949','1142','187','2154','1138','236','3079','1463','2872','2480','3780','1795','3960','3258','31','2396','2398','381','3100','3812','1132','2660','2481','1076','3955','1226','3055','655','3500','821','3007' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '163','2030','3647','3745','1447','3927','687','3959','131','2773','66','579','3396','3898','2719','3850','3942','1497','2421','3528','1459','3272','769','3321','3945','3916','2375','3275','2637','2136','3143','437','259','694','3651','3227','1866','2996','931','3957','1430','861','1674','3963','1704','418','2883','3686','3385','2646','1766','1499','107','1077','3958','2569','1025','2567','3964','2830','596','2484','91','2253','1375','3935','3793','1252','188','949','1142','187','2154','1138','236','3079','1463','2872','2480','3780','1795','3960','3258','31','2396','2398','381','3100','3812','1132','2660','2481','1076','3955','1226','3055','655','3500','821','3007' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 9:00:25 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 207.060331 Lock_time: 0.000143 Rows_sent: 0 Rows_examined: 236531 SET timestamp=1422432025; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '3317','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','751','1066','2410','192','1477','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','3653','3445','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','282','1783','2233','1946','836','44','3677','1557','1917','1361','3859','2886','3589','3932','3739','2519','967' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '3317','3237','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','751','1066','2410','192','1477','70','3559','2438','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','3653','3445','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','282','1783','2233','1946','836','44','3677','1557','1917','1361','3859','2886','3589','3932','3739','2519','967' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 10:02:50 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 231.492724 Lock_time: 0.000541 Rows_sent: 0 Rows_examined: 236537 SET timestamp=1422435770; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '2587','790','3557','1074','3774','2789','3890','86','3670','3615','2520','2300','371','756','1991','73','2904','2401','3930','1724','2337','2898','598','2504','3803','504','903','3880','2732','2594','3180','576','484','360','1092','3722','3166','3939','362','2430','831','288','3411','3181','2581','3889','3602','2993','179','3923','1491','973','3854','2653','1909','1109','2252','1536','3187','2557','2834','1366','1583','3506','2622','3417','1301','3307','1182','3787','2325','3824','2379','2961','1488','3603','2045','845','2429','3579','35','3140','3937','2269','764','3231','2395','3517','3936','219','3875','3047','125','3574','2783','3735','1392','713','3838','3925' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '2587','790','3557','1074','3774','2789','3890','86','3670','3615','2520','2300','371','756','1991','73','2904','2401','3930','1724','2337','2898','598','2504','3803','504','903','3880','2732','2594','3180','576','484','360','1092','3722','3166','3939','362','2430','831','288','3411','3181','2581','3889','3602','2993','179','3923','1491','973','3854','2653','1909','1109','2252','1536','3187','2557','2834','1366','1583','3506','2622','3417','1301','3307','1182','3787','2325','3824','2379','2961','1488','3603','2045','845','2429','3579','35','3140','3937','2269','764','3231','2395','3517','3936','219','3875','3047','125','3574','2783','3735','1392','713','3838','3925' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 10:08:40 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 220.844659 Lock_time: 0.000164 Rows_sent: 0 Rows_examined: 236537 SET timestamp=1422436120; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '1138','66','2773','2030','3647','3745','1447','3927','687','579','3528','2421','2398','163','3396','3898','2719','3850','3942','1497','3959','131','1459','259','437','3321','3945','3916','2375','3275','2637','694','861','1430','3272','769','3651','3227','1866','2996','931','3957','2136','967','1077','107','1704','418','2883','3686','3385','2646','3958','91','2484','2561','3963','2569','1025','2567','3964','2830','596','1766','1499','2253','3079','236','3793','1252','188','949','1142','187','1463','2396','31','1375','3935','2872','2480','3780','1795','3960','3258','2154','2410','1674','3100','3812','1132','2660','2481','1076','3955','2886','3055','655','3007','3317' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '1138','66','2773','2030','3647','3745','1447','3927','687','579','3528','2421','2398','163','3396','3898','2719','3850','3942','1497','3959','131','1459','259','437','3321','3945','3916','2375','3275','2637','694','861','1430','3272','769','3651','3227','1866','2996','931','3957','2136','967','1077','107','1704','418','2883','3686','3385','2646','3958','91','2484','2561','3963','2569','1025','2567','3964','2830','596','1766','1499','2253','3079','236','3793','1252','188','949','1142','187','1463','2396','31','1375','3935','2872','2480','3780','1795','3960','3258','2154','2410','1674','3100','3812','1132','2660','2481','1076','3955','2886','3055','655','3007','3317' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) ); # Time: 150128 10:12:33 # User@Host: kkkkkkk[kkkkkkk] @ localhost [] # Query_time: 215.162033 Lock_time: 0.000137 Rows_sent: 1 Rows_examined: 236537 SET timestamp=1422436353; SELECT `mess`.`id` as messageId, `mess`.*, `conv`.* FROM `ow_mailbox_conversation` AS `conv` INNER JOIN `ow_mailbox_last_message` AS `last_m` ON (`last_m`.`conversationId` = `conv`.`id`) INNER JOIN `ow_mailbox_message` AS `mess` ON ( `last_m`.`initiatorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` > `last_m`.interlocutorMessageId ) OR `last_m`.`interlocutorMessageId` = `mess`.id AND ( `last_m`.`initiatorMessageId` < `last_m`.interlocutorMessageId ) ) WHERE `conv`.`notificationSent` = 0 AND ( ( `conv`.`initiatorId` IN ( '192','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3653','3237','751','1477','70','3559','2438','3261','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3445','282','1783','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','2233','1946','836','44','3143','381','3677','1557','1917','1361','3859','821','3500','3932','3739','2519','2521' ) AND `last_m`.`interlocutorMessageId` > 0 AND `conv`.`deleted` != 1 AND NOT `conv`.`read` & 1 AND NOT `conv`.`viewed` & 1 ) OR ( `conv`.`interlocutorId` IN ( '192','52','3921','3423','2720','2748','3437','3947','2806','3198','1145','3451','1914','240','225','2443','3653','3237','751','1477','70','3559','2438','3261','2073','3656','1997','648','3553','2573','3796','3092','1071','2972','1066','3445','282','1783','2528','3894','1756','389','2474','1730','676','2764','3770','2216','3353','265','3926','2531','155','3842','55','3570','2233','1946','836','44','3143','381','3677','1557','1917','1361','3859','821','3500','3932','3739','2519','2521' ) AND `conv`.`deleted` != 2 AND NOT `conv`.`read` & 2 AND NOT `conv`.`viewed` & 2 ) );