Ranking | DokądJechać.pl

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/dokadj/domains/dokadjechac.pl/public_html/libs/adodb/drivers/adodb-mysql.inc.php on line 365
'#(RankVoteModel::getTopCountriesSQL:393) SELECT c.id,c.name,c.symbol, c.name as country_name, con.name as continentName, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) as DECIMAL(10,2) ) as rank_average, rvc.vote_count as rank_vote_count, \'\' as rank_name, \'\' as rank_names_all, \'0\' as rank_is_average, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) / 2 as SIGNED ) as rank_average_one_to_five, cc.*, (SELECT thumb FROM gallery_picture gp WHERE CHAR_LENGTH(gp.thumb) > 4 and gp.active = 1 and gp.deleted = 0 AND gp.id_gallery IN (SELECT id_gallery FROM hot_spot hs WHERE hs.id_country = c.id) LIMIT 1) as thumb_name FROM country c LEFT JOIN (SELECT id_rank_category, id_country, AVG(avg_value) as avg_value, SUM(vote_count) as vote_count FROM rank_vote_compiled rvc WHERE 1 GROUP BY id_country,id_rank_category ) as rvc ON rvc.id_country = c.id LEFT JOIN country_climate_compiled cc ON cc.id_country = c.id LEFT JOIN continent con ON c.id_continent = con.id LEFT JOIN hot_spot hs ON hs.id_country = c.id LEFT JOIN gallery g ON g.id = hs.id_gallery AND g.active = 1 AND g.deleted = 0 WHERE c.active = 1 AND c.deleted = 0 AND c.symbol != \'pl\' AND 1 AND ( id_continent = ) GROUP BY c.id ORDER by rank_average DESC, rank_vote_count DESC, id asc '#0 DBDriverADO->checkRes(, #(RankVoteModel::getTopCountriesSQL:393) SELECT c.id,c.name,c.symbol, c.name as country_name, con.name as continentName, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) as DECIMAL(10,2) ) as rank_average, rvc.vote_count as rank_vote_count, '' as rank_name, '' as rank_names_all, '0' as rank_is_average, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) / 2 as SIGNED ) as rank_average_one_to_five, cc.*, (SELECT thumb FROM gallery_picture gp WHERE CHAR_LENGTH(gp.thumb) > 4 and gp.active = 1 and gp.deleted = 0 AND gp.id_gallery IN (SELECT id_gallery FROM hot_spot hs WHERE hs.id_country = c.id) LIMIT 1) as thumb_name FROM country c LEFT JOIN (SELECT id_rank_category, id_country, AVG(avg_value) as avg_value, SUM(vote_count) as vote_count FROM rank_vote_compiled rvc WHERE 1 GROUP BY id_country,id_rank_category ) as rvc ON rvc.id_country = c.id LEFT JOIN country_climate_compiled cc ON cc.id_country = c.id LEFT JOIN continent con ON c.id_continent = con.id LEFT JOIN hot_spot hs ON hs.id_country = c.id LEFT JOIN gallery g ON g.id = hs.id_gallery AND g.active = 1 AND g.deleted = 0 WHERE c.active = 1 AND c.deleted = 0 AND c.symbol != 'pl' AND 1 AND ( id_continent = ) GROUP BY c.id ORDER by rank_average DESC, rank_vote_count DESC, id asc , Array ()) called at [/home/dokadj/domains/dokadjechac.pl/public_html/sys/DBDriverADO.php:122] #1 DBDriverADO->callADOLegacyMethod(getAll, #(RankVoteModel::getTopCountriesSQL:393) SELECT c.id,c.name,c.symbol, c.name as country_name, con.name as continentName, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) as DECIMAL(10,2) ) as rank_average, rvc.vote_count as rank_vote_count, '' as rank_name, '' as rank_names_all, '0' as rank_is_average, CAST( SUM(rvc.avg_value*rvc.vote_count) / SUM(rvc.vote_count) / 2 as SIGNED ) as rank_average_one_to_five, cc.*, (SELECT thumb FROM gallery_picture gp WHERE CHAR_LENGTH(gp.thumb) > 4 and gp.active = 1 and gp.deleted = 0 AND gp.id_gallery IN (SELECT id_gallery FROM hot_spot hs WHERE hs.id_country = c.id) LIMIT 1) as thumb_name FROM country c LEFT JOIN (SELECT id_rank_category, id_country, AVG(avg_value) as avg_value, SUM(vote_count) as vote_count FROM rank_vote_compiled rvc WHERE 1 GROUP BY id_country,id_rank_category ) as rvc ON rvc.id_country = c.id LEFT JOIN country_climate_compiled cc ON cc.id_country = c.id LEFT JOIN continent con ON c.id_continent = con.id LEFT JOIN hot_spot hs ON hs.id_country = c.id LEFT JOIN gallery g ON g.id = hs.id_gallery AND g.active = 1 AND g.deleted = 0 WHERE c.active = 1 AND c.deleted = 0 AND c.symbol != 'pl' AND 1 AND ( id_continent = ) GROUP BY c.id ORDER by rank_average DESC, rank_vote_count DESC, id asc Ranking | DokądJechać.pl

Copyright © 2012 DokądJechać.pl

Wszystkie prawa zastrzeżone. Żadna część ani całość serwisu nie może być reprodukowana ani przetwarzana w sposób elektroniczny, mechaniczny, fotograficzny i inny. Nie może być użyta do innej publikacji oraz przechowywana w jakiejkolwiek bazie danych bez pisemnej zgody Administratora serwisu.

Projekt graficzny: Triso.pl
Realizacja: Grafinet

Mapa serwisu