Lost connection to MySQL server during query SELECT everything.*, user_table.login AS signature, actions_table.value as spam_marker FROM (SELECT id AS id, parentid, text, user_id, spam_counter, rating, DATE_FORMAT(date, '%e.%c.%Y %T') AS _date  , ((SELECT count(1) FROM smutne_emocje WHERE parentid = main_table.id AND deleted = 0  )+rating) AS spec_rate ,  (SELECT count(1) FROM smutne_emocje WHERE parentid = main_table.id AND deleted = 0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) )) AS comments_count, (SELECT text AS T FROM smutne_emocje WHERE parentid = main_table.id AND deleted = 0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) ORDER BY date  DESC LIMIT 0,1) AS snippet, (SELECT DATE_FORMAT(date, '%e.%c.%Y %T') FROM smutne_emocje WHERE (parentid = main_table.id OR id = main_table.id)AND deleted = 0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) AND date >= '1999-11-30' AND date < '1999-12-01' ORDER BY date DESC LIMIT 0,1) AS special_date , (SELECT date FROM smutne_emocje WHERE (parentid = main_table.id OR id = main_table.id)AND deleted = 0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) AND date >= '1999-11-30' AND date < '1999-12-01' ORDER BY date DESC LIMIT 0,1) AS special_date_to_sort  FROM smutne_emocje AS main_table WHERE main_table.deleted = 0   AND main_table.id IN (SELECT id FROM smutne_emocje WHERE parentid IS null  AND deleted=0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) UNION DISTINCT SELECT parentid FROM smutne_emocje WHERE parentid IS NOT null  AND deleted=0 AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) ) AND (((perm_spam=0 OR (perm_spam=1 AND (spam_counter<8 OR rating > 50))) ) ) AND parentid IS null ORDER BY spec_rate DESC LIMIT 0, 100 ) AS everything LEFT JOIN 6mi_konta AS user_table ON (everything.user_id = user_table.id) LEFT JOIN smutne_akcje as actions_table ON (actions_table.type=1 AND actions_table.entry_id=everything.id AND actions_table.user_id = -1)