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

• Start
• Nasze Uzdrowiska
• Baza noclegowa
• O projekcie
• Aktualności
• Kontakt

szukaj w serwisie:

• Start
• Nasze Uzdrowiska
• Baza noclegowa
• O projekcie
• Aktualności
• Mapa strony
• Kontakt
• Login

copyrights © 2010 - Wszelkie prawa zastrzeżone. design: Encja.com

Projekt współfinansowany przez Unię Europejską z Europejskiego Funduszu Rozwoju Regionalnego w ramach Regionalnego Programu Operacyjnego dla Województwa Dolnośląskiego na lata 2007 – 2013