
SELECT COUNT(id_log) as readed_counter, sc.id_site_content, IF (LENGTH(sc.content_title_pl) > 5, 0, 1) AS contentPL, IF (LENGTH(sc.content_title_pl) > 5, sc.content_title_pl, sc.content_title_pl) AS content_title, IF (LENGTH(sc.content_lead_pl) > 5, sc.content_lead_pl, sc.content_lead_pl) AS content_lead, sc.create_date, f.id_file, f.file_ext #(SELECT COUNT(id_log) FROM log WHERE id_site_content = sc.id_site_content) AS readed_counter FROM log LEFT JOIN `site_content` as sc USING (id_site_content) LEFT JOIN site_content_has_file as schf ON schf.id_site_content = sc.id_site_content LEFT JOIN file as f ON f.id_file = schf.id_file LEFT JOIN `region` AS r ON r.id_region = sc.id_region WHERE sc.id_status <> 2 #AND LENGTH(sc.content_title_pl) > 5 AND sc.content_type = 'news' GROUP BY log.id_site_content ORDER BY readed_counter DESC LIMIT 0, 4
SQL error: Lost connection to MySQL server during query
SELECT log.id_site_content as idlogcontent, log.data as read_date, sc.id_site_content, IF (LENGTH(sc.content_title_pl) > 5, 0, 1) AS contentPL, IF (LENGTH(sc.content_title_pl) > 5, sc.content_title_pl, sc.content_title_pl) AS content_title, IF (LENGTH(sc.content_lead_pl) > 5, sc.content_lead_pl, sc.content_lead_pl) AS content_lead, sc.create_date, f.id_file, f.file_ext #(SELECT l.data FROM log AS l WHERE l.id_site_content = sc.id_site_content ORDER BY l.data DESC LIMIT 1) AS read_date FROM `log` LEFT JOIN `site_content` as sc USING (id_site_content) LEFT JOIN site_content_has_file as schf USING (id_site_content) LEFT JOIN file as f ON f.id_file = schf.id_file LEFT JOIN `region` AS r ON r.id_region = sc.id_region WHERE sc.id_status <> 2 #AND LENGTH(sc.content_title_pl) > 5 AND sc.content_type = 'news' GROUP BY idlogcontent ORDER BY read_date DESC LIMIT 0, 4
SQL error: MySQL server has gone away
SELECT r.id_region, r.name, r.domain, IF (LENGTH(sc.content_main_pl) > 5, 0, 1) AS contentPL, IF (LENGTH(sc.content_main_pl) > 5, sc.content_main_pl, sc.content_main_pl) AS descr, f.id_file, f.file_ext FROM `region` AS r LEFT JOIN `site_content` AS sc ON sc.id_region = r.id_region AND sc.content_type = 'region' AND sc.id_status = 1 LEFT JOIN site_content_has_file as schf ON schf.id_site_content = sc.id_site_content AND schf.file_position = 0 AND schf.gallery_type = 3 LEFT JOIN file as f ON f.id_file = schf.id_file WHERE r.id_status != 2 ORDER BY r.name
SQL error: MySQL server has gone away
Nasze dotychczasowe filmowe spotkania odbywały się zwykle w letniej porze. W ubiegłym roku postanowiliśmy po raz pierwszy zaproponować Państwu filmowy program w czasie ferii zimowych. Pomysł naszym widzom spodobał się, impreza się świetnie udała. Pora więc
Ray Wilson – były wokalista GENESIS zaprezentuje podczas koncertu zarówno największe przeboje tej legendarnej grupy jak i autors
Koncert odbędzie się 24.08.2017 o godzinie 19:30 w Kościele pw. Wniebowzięcia NMP w Polanicy-Zdroju. Wstęp: wolne datki na remon
Koncert odbędzie się 22.08.2017 o godzinie 16:00 w muszli koncertowej w Polanicy-Zdroju. Wstęp wolny.
copyrights © 2010 - Wszelkie prawa zastrzeżone. design: Encja.com