Владимир Ватаманюк

---

SELECT A.*, AL.*, IU.medium_url #,(SELECT COUNT(com_id) FROM comments AS C WHERE C.xxx_id = A.text_id) AS Ccaount #,FROM_UNIXTIME(A.date_set) AS asas FROM text AS A INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id) LEFT JOIN `img_all` IA ON(IA.id_xxx = A.text_id) LEFT JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE A.text_id AND A.cat_id NOT IN (7,9,12,13) AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 AND A.cat_id !=7 AND A.date_set >= UNIX_TIMESTAMP(Date_Add( NOW(), Interval -DayOfWeek( NOW()) - 168 hour )) GROUP BY A.text_id ORDER BY A.date_set DESC, A.text_id DESC
Server shutdown in progress; KOD: 1053

---

SELECT CC.counts, CC.type_ago, A.*, AL.*, IU.medium_url,IU.img_id FROM comments_counts AS CC INNER JOIN `text` AS A ON A.`text_id` = CC.`text_id` INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id AND AL.`lang` = 1) INNER JOIN `img_all` IA ON(IA.id_xxx = CC.text_id) INNER JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE CC.`type_ago` = '1 YEAR' AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 GROUP BY CC.text_id ORDER BY CC.counts DESC #/template3/PrintMostDiscussedYearWidget.php
Lost connection to server during query; KOD: 2013

---

SELECT CC.counts, CC.type_ago, A.*, AL.*, IU.medium_url,IU.img_id FROM comments_counts AS CC INNER JOIN `text` AS A ON A.`text_id` = CC.`text_id` INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id AND AL.`lang` = 1) INNER JOIN `img_all` IA ON(IA.id_xxx = CC.text_id) INNER JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE CC.`type_ago` = '6 MONTH' AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 GROUP BY CC.text_id ORDER BY CC.counts DESC #/template3/PrintMostDiscussedYearWidget.php
Server has gone away; KOD: 2006