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 Server has gone away; KOD: 2006SELECT 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
Анатолий Курекь: «Надеюсь, завтра наша страна будет гордиться тем, что мы делаем сегодня»
Футболка ван дер Варта ушла с молотка за 1 000 евро в помощь Вадиму Кричмарю
Сергей Тарновский защитил титул лучшего в Европе
Молдова завоевала путёвку в Europe Group II турнира Billie Jean King Cup
