Belacena.com - Goal 2

1-18-08
1111 visualizações

21
987 visualizações

Il codice gratta e vinci (TRAILER - Film parodia in ferrarese)
381 visualizações

Brincadeira com o trailer do 300
2888 visualizações

Dedication
814 visualizações

No End In Sight
377 visualizações

10.000 BC
564 visualizações

Hancock
459 visualizações

Spiderman
275 visualizações

Trailer do Saw 4
898 visualizações

Shrooms
457 visualizações

Rendition
401 visualizações

Spiral
258 visualizações

Beware
604 visualizações

Chicago 10
403 visualizações

In Bruges
450 visualizações

Look
524 visualizações

Possession
517 visualizações

Teeth
459 visualizações

The Amateurs
676 visualizações

20 queries took 177 ms

Query

Error

Affected

Num. rows

Took (ms)

SET NAMES utf8

SELECT `Member`.`id` AS `Member__id`, `Member`.`nome` AS `Member__nome`, `Member`.`nick` AS `Member__nick`, `Member`.`password` AS `Member__password`, `Member`.`email` AS `Member__email`, `Member`.`pais` AS `Member__pais`, `Member`.`cidade` AS `Member__cidade`, `Member`.`sexo` AS `Member__sexo`, `Member`.`homepage` AS `Member__homepage`, `Member`.`imagem_ficheiro` AS `Member__imagem_ficheiro`, `Member`.`videos_hits` AS `Member__videos_hits`, `Member`.`videos_send` AS `Member__videos_send`, `Member`.`votos` AS `Member__votos`, `Member`.`media_votos` AS `Member__media_votos`, `Member`.`comentarios` AS `Member__comentarios`, `Member`.`favoritos` AS `Member__favoritos`, `Member`.`ult_login` AS `Member__ult_login`, `Member`.`login_count` AS `Member__login_count`, `Member`.`inscricao` AS `Member__inscricao`, `Member`.`profile_hits` AS `Member__profile_hits`, `Member`.`activo` AS `Member__activo`, `Member`.`data_nascimento` AS `Member__data_nascimento`, `Member`.`quota` AS `Member__quota`, `Member`.`limite_upload` AS `Member__limite_upload`, `Member`.`nick_iol` AS `Member__nick_iol`, `Member`.`password_iol` AS `Member__password_iol` FROM `usr_membros` AS `Member` WHERE activo = 1 AND id > 1 ORDER BY `Member`.`id` DESC LIMIT 1

SELECT `Votes`.`id` AS `Votes__id`, `Votes`.`video_id` AS `Votes__video_id`, `Votes`.`user_id` AS `Votes__user_id`, `Votes`.`value` AS `Votes__value`, `Votes`.`data` AS `Votes__data` FROM `vd_votos` AS `Votes` WHERE `Votes`.`video_id` = '12541'

SELECT `Comments`.`id` AS `Comments__id`, `Comments`.`user` AS `Comments__user`, `Comments`.`video` AS `Comments__video`, `Comments`.`comentario` AS `Comments__comentario`, `Comments`.`data` AS `Comments__data`, `Comments`.`estado` AS `Comments__estado` FROM `vd_comentarios` AS `Comments` WHERE `Comments`.`video` = '12541' ORDER BY `Comments`.`data` DESC

SELECT `VideoHits`.`id` AS `VideoHits__id`, `VideoHits`.`video_id` AS `VideoHits__video_id`, `VideoHits`.`user_id` AS `VideoHits__user_id`, `VideoHits`.`data` AS `VideoHits__data`, `VideoHits`.`referer` AS `VideoHits__referer`, `VideoHits`.`week` AS `VideoHits__week`, `VideoHits`.`month` AS `VideoHits__month` FROM `vd_videos_hits` AS `VideoHits` WHERE `VideoHits`.`vd_video_id` = '12541'

1054: Unknown column 'VideoHits.vd_video_id' in 'where clause'

SELECT `Categories`.`id` AS `Categories__id`, `Categories`.`descricao` AS `Categories__descricao` FROM `vd_temas` AS `Categories` JOIN `vd_rel_vd_ct` ON `vd_rel_vd_ct`.`vd` = '12541' AND `vd_rel_vd_ct`.`ct` = `Categories`.`id` WHERE 1 = 1 ORDER BY descricao ASC

SELECT `Videos`.`id` AS `Videos__id`, `Videos`.`nome` AS `Videos__nome`, `Videos`.`video` AS `Videos__video`, `Videos`.`hits` AS `Videos__hits`, `Videos`.`tamanho` AS `Videos__tamanho`, `Videos`.`thumbnail` AS `Videos__thumbnail`, `Videos`.`n_votos` AS `Videos__n_votos`, `Videos`.`media` AS `Videos__media`, `Videos`.`duracao` AS `Videos__duracao`, `Videos`.`n_comentarios` AS `Videos__n_comentarios`, `Videos`.`vip` AS `Videos__vip`, `Videos`.`pendente` AS `Videos__pendente`, `Videos`.`data_intro` AS `Videos__data_intro`, `Videos`.`user` AS `Videos__user`, `Videos`.`md5hash` AS `Videos__md5hash`, `Videos`.`uploadmode` AS `Videos__uploadmode`, `Videos`.`favorito` AS `Videos__favorito`, `Videos`.`video_s3` AS `Videos__video_s3` FROM `vd_videos` AS `Videos` JOIN `vd_rel_vd_ct` ON `vd_rel_vd_ct`.`ct` = '4' AND `vd_rel_vd_ct`.`vd` = `Videos`.`id` WHERE 1 = 1 ORDER BY data_intro DESC

573

SELECT `Tags`.`id` AS `Tags__id`, `Tags`.`nome` AS `Tags__nome`, `Tags`.`nome_encoded` AS `Tags__nome_encoded` FROM `vd_tags` AS `Tags` JOIN `vd_videos_tags` ON `vd_videos_tags`.`video_id` = '12541' AND `vd_videos_tags`.`tag_id` = `Tags`.`id` WHERE 1 = 1

SELECT `Videos`.`id` AS `Videos__id`, `Videos`.`nome` AS `Videos__nome`, `Videos`.`video` AS `Videos__video`, `Videos`.`hits` AS `Videos__hits`, `Videos`.`tamanho` AS `Videos__tamanho`, `Videos`.`thumbnail` AS `Videos__thumbnail`, `Videos`.`n_votos` AS `Videos__n_votos`, `Videos`.`media` AS `Videos__media`, `Videos`.`duracao` AS `Videos__duracao`, `Videos`.`n_comentarios` AS `Videos__n_comentarios`, `Videos`.`vip` AS `Videos__vip`, `Videos`.`pendente` AS `Videos__pendente`, `Videos`.`data_intro` AS `Videos__data_intro`, `Videos`.`user` AS `Videos__user`, `Videos`.`md5hash` AS `Videos__md5hash`, `Videos`.`uploadmode` AS `Videos__uploadmode`, `Videos`.`favorito` AS `Videos__favorito`, `Videos`.`video_s3` AS `Videos__video_s3` FROM `vd_videos` AS `Videos` JOIN `vd_videos_tags` ON `vd_videos_tags`.`tag_id` = '9221' AND `vd_videos_tags`.`video_id` = `Videos`.`id` WHERE 1 = 1

SELECT `Videos`.`id` AS `Videos__id`, `Videos`.`nome` AS `Videos__nome`, `Videos`.`video` AS `Videos__video`, `Videos`.`hits` AS `Videos__hits`, `Videos`.`tamanho` AS `Videos__tamanho`, `Videos`.`thumbnail` AS `Videos__thumbnail`, `Videos`.`n_votos` AS `Videos__n_votos`, `Videos`.`media` AS `Videos__media`, `Videos`.`duracao` AS `Videos__duracao`, `Videos`.`n_comentarios` AS `Videos__n_comentarios`, `Videos`.`vip` AS `Videos__vip`, `Videos`.`pendente` AS `Videos__pendente`, `Videos`.`data_intro` AS `Videos__data_intro`, `Videos`.`user` AS `Videos__user`, `Videos`.`md5hash` AS `Videos__md5hash`, `Videos`.`uploadmode` AS `Videos__uploadmode`, `Videos`.`favorito` AS `Videos__favorito`, `Videos`.`video_s3` AS `Videos__video_s3` FROM `vd_videos` AS `Videos` JOIN `vd_videos_tags` ON `vd_videos_tags`.`tag_id` = '1288' AND `vd_videos_tags`.`video_id` = `Videos`.`id` WHERE 1 = 1

272

SELECT count(*) AS count FROM vd_temas Categories INNER JOIN vd_rel_vd_ct VdTemas ON VdTemas.ct = Categories.id INNER JOIN vd_videos Videos ON Videos.id = VdTemas.vd WHERE Categories.id = 12 AND Videos.pendente = 1 AND Videos.id = 12541

INSERT INTO `vd_videos_hits` (`video_id`,`user_id`,`data`) VALUES ('12541','1','2008-11-22 05:37:28')

SELECT `Video`.`id` AS `Video__id`, `Video`.`nome` AS `Video__nome`, `Video`.`video` AS `Video__video`, `Video`.`hits` AS `Video__hits`, `Video`.`tamanho` AS `Video__tamanho`, `Video`.`thumbnail` AS `Video__thumbnail`, `Video`.`n_votos` AS `Video__n_votos`, `Video`.`media` AS `Video__media`, `Video`.`duracao` AS `Video__duracao`, `Video`.`n_comentarios` AS `Video__n_comentarios`, `Video`.`vip` AS `Video__vip`, `Video`.`pendente` AS `Video__pendente`, `Video`.`data_intro` AS `Video__data_intro`, `Video`.`user` AS `Video__user`, `Video`.`md5hash` AS `Video__md5hash`, `Video`.`uploadmode` AS `Video__uploadmode`, `Video`.`favorito` AS `Video__favorito`, `Video`.`video_s3` AS `Video__video_s3` FROM `vd_videos` AS `Video` WHERE `Video`.`id` IN(13260, 4709, 6477, 10392, 3232, 4716, 4720, 7086, 7087, 7159, 6582, 7311, 7280, 7374, 6479, 6481, 6484, 6485, 6488, 6493, 6494, 6496, 6498, 7538, 7539, 7540, 7542, 8669, 8674, 8744, 8745, 8746, 8984, 8037, 8118, 8114, 8117, 7716, 7543, 9483, 9485, 9486, 9487, 9667, 10308, 10312, 10313, 10299, 10301, 10151, 11371, 11372, 11382, 11301, 11775, 11776, 11766, 11771, 11773, 11774, 11764, 11972, 12037, 12001, 11835, 11931, 10820, 10821, 10823, 10824, 10827, 10818, 12202, 12237, 12257, 12185, 12420, 12448, 12514, 12435, 12097, 12067, 12121, 12586, 12822, 13257, 13326, 13128, 13149, 13184, 13168, 13080, 12314, 12345, 13381, 13429, 13439, 2963, 1278, 4231, 5859, 4702, 4715, 4717, 4718, 4723, 4724, 4726, 4728, 7088, 7090, 7091, 6874, 7309, 7369, 7371, 7372, 7373, 7377, 6478, 6482, 6486, 6489, 6490, 6492, 6495, 7430, 7431, 7537, 7541, 6340, 8675, 8743, 8730, 8986, 8985, 9264, 9265, 8110, 8111, 8112, 8115, 8116, 7544, 7545, 7546, 9490, 9491, 9492, 9493, 9484, 9489, 9669, 9671, 10306, 10307, 10309, 10310, 10311, 10295, 10300, 10302, 10304, 10150, 10154, 10111, 11373, 11374, 11376, 11378, 11379, 11381, 11765, 11767, 11768, 11769, 11942, 11981, 12016, 12048, 11992, 11903, 10733, 10822, 10825, 10826, 10816, 10817, 10710, 12288, 12269, 12476, 12166, 12153, 12549, 12613, 12622, 12843, 12892, 13239, 13330, 13104, 13205, 13034, 12402, 12391, 12372, 12301, 12723, 12792, 12779, 12771, 13342, 13473, 13478, 4727, 4729, 6593, 6831, 7310, 7375, 7376, 6476, 6480, 6483, 6497, 9015, 9016, 9017, 9014, 8095, 8113, 7547, 9488, 9670, 10152, 10153, 11375, 11380, 11383, 11770, 11772, 11649, 10819, 10711, 12233, 12247, 12108, 12565, 12875, 12929, 12979, 12377, 12685, 4721, 7089, 7164, 7370, 6475, 6487, 6491, 6499, 7429, 8983, 8000, 10149, 11939, 11654, 12205, 12062, 12326, 12295) AND `Video`.`pendente` in (1, 25) ORDER BY `Video`.`id`=13260 DESC, `Video`.`id`=4709 DESC, `Video`.`id`=6477 DESC, `Video`.`id`=10392 DESC, `Video`.`id`=3232 DESC, `Video`.`id`=4716 DESC, `Video`.`id`=4720 DESC, `Video`.`id`=7086 DESC, `Video`.`id`=7087 DESC, `Video`.`id`=7159 DESC, `Video`.`id`=6582 DESC, `Video`.`id`=7311 DESC, `Video`.`id`=7280 DESC, `Video`.`id`=7374 DESC, `Video`.`id`=6479 DESC, `Video`.`id`=6481 DESC, `Video`.`id`=6484 DESC, `Video`.`id`=6485 DESC, `Video`.`id`=6488 DESC, `Video`.`id`=6493 DESC, `Video`.`id`=6494 DESC, `Video`.`id`=6496 DESC, `Video`.`id`=6498 DESC, `Video`.`id`=7538 DESC, `Video`.`id`=7539 DESC, `Video`.`id`=7540 DESC, `Video`.`id`=7542 DESC, `Video`.`id`=8669 DESC, `Video`.`id`=8674 DESC, `Video`.`id`=8744 DESC, `Video`.`id`=8745 DESC, `Video`.`id`=8746 DESC, `Video`.`id`=8984 DESC, `Video`.`id`=8037 DESC, `Video`.`id`=8118 DESC, `Video`.`id`=8114 DESC, `Video`.`id`=8117 DESC, `Video`.`id`=7716 DESC, `Video`.`id`=7543 DESC, `Video`.`id`=9483 DESC, `Video`.`id`=9485 DESC, `Video`.`id`=9486 DESC, `Video`.`id`=9487 DESC, `Video`.`id`=9667 DESC, `Video`.`id`=10308 DESC, `Video`.`id`=10312 DESC, `Video`.`id`=10313 DESC, `Video`.`id`=10299 DESC, `Video`.`id`=10301 DESC, `Video`.`id`=10151 DESC, `Video`.`id`=11371 DESC, `Video`.`id`=11372 DESC, `Video`.`id`=11382 DESC, `Video`.`id`=11301 DESC, `Video`.`id`=11775 DESC, `Video`.`id`=11776 DESC, `Video`.`id`=11766 DESC, `Video`.`id`=11771 DESC, `Video`.`id`=11773 DESC, `Video`.`id`=11774 DESC, `Video`.`id`=11764 DESC, `Video`.`id`=11972 DESC, `Video`.`id`=12037 DESC, `Video`.`id`=12001 DESC, `Video`.`id`=11835 DESC, `Video`.`id`=11931 DESC, `Video`.`id`=10820 DESC, `Video`.`id`=10821 DESC, `Video`.`id`=10823 DESC, `Video`.`id`=10824 DESC, `Video`.`id`=10827 DESC, `Video`.`id`=10818 DESC, `Video`.`id`=12202 DESC, `Video`.`id`=12237 DESC, `Video`.`id`=12257 DESC, `Video`.`id`=12185 DESC, `Video`.`id`=12420 DESC, `Video`.`id`=12448 DESC, `Video`.`id`=12514 DESC, `Video`.`id`=12435 DESC, `Video`.`id`=12097 DESC, `Video`.`id`=12067 DESC, `Video`.`id`=12121 DESC, `Video`.`id`=12586 DESC, `Video`.`id`=12822 DESC, `Video`.`id`=13257 DESC, `Video`.`id`=13326 DESC, `Video`.`id`=13128 DESC, `Video`.`id`=13149 DESC, `Video`.`id`=13184 DESC, `Video`.`id`=13168 DESC, `Video`.`id`=13080 DESC, `Video`.`id`=12314 DESC, `Video`.`id`=12345 DESC, `Video`.`id`=13381 DESC, `Video`.`id`=13429 DESC, `Video`.`id`=13439 DESC, `Video`.`id`=2963 DESC, `Video`.`id`=1278 DESC, `Video`.`id`=4231 DESC, `Video`.`id`=5859 DESC, `Video`.`id`=4702 DESC, `Video`.`id`=4715 DESC, `Video`.`id`=4717 DESC, `Video`.`id`=4718 DESC, `Video`.`id`=4723 DESC, `Video`.`id`=4724 DESC, `Video`.`id`=4726 DESC, `Video`.`id`=4728 DESC, `Video`.`id`=7088 DESC, `Video`.`id`=7090 DESC, `Video`.`id`=7091 DESC, `Video`.`id`=6874 DESC, `Video`.`id`=7309 DESC, `Video`.`id`=7369 DESC, `Video`.`id`=7371 DESC, `Video`.`id`=7372 DESC, `Video`.`id`=7373 DESC, `Video`.`id`=7377 DESC, `Video`.`id`=6478 DESC, `Video`.`id`=6482 DESC, `Video`.`id`=6486 DESC, `Video`.`id`=6489 DESC, `Video`.`id`=6490 DESC, `Video`.`id`=6492 DESC, `Video`.`id`=6495 DESC, `Video`.`id`=7430 DESC, `Video`.`id`=7431 DESC, `Video`.`id`=7537 DESC, `Video`.`id`=7541 DESC, `Video`.`id`=6340 DESC, `Video`.`id`=8675 DESC, `Video`.`id`=8743 DESC, `Video`.`id`=8730 DESC, `Video`.`id`=8986 DESC, `Video`.`id`=8985 DESC, `Video`.`id`=9264 DESC, `Video`.`id`=9265 DESC, `Video`.`id`=8110 DESC, `Video`.`id`=8111 DESC, `Video`.`id`=8112 DESC, `Video`.`id`=8115 DESC, `Video`.`id`=8116 DESC, `Video`.`id`=7544 DESC, `Video`.`id`=7545 DESC, `Video`.`id`=7546 DESC, `Video`.`id`=9490 DESC, `Video`.`id`=9491 DESC, `Video`.`id`=9492 DESC, `Video`.`id`=9493 DESC, `Video`.`id`=9484 DESC, `Video`.`id`=9489 DESC, `Video`.`id`=9669 DESC, `Video`.`id`=9671 DESC, `Video`.`id`=10306 DESC, `Video`.`id`=10307 DESC, `Video`.`id`=10309 DESC, `Video`.`id`=10310 DESC, `Video`.`id`=10311 DESC, `Video`.`id`=10295 DESC, `Video`.`id`=10300 DESC, `Video`.`id`=10302 DESC, `Video`.`id`=10304 DESC, `Video`.`id`=10150 DESC, `Video`.`id`=10154 DESC, `Video`.`id`=10111 DESC, `Video`.`id`=11373 DESC, `Video`.`id`=11374 DESC, `Video`.`id`=11376 DESC, `Video`.`id`=11378 DESC, `Video`.`id`=11379 DESC, `Video`.`id`=11381 DESC, `Video`.`id`=11765 DESC, `Video`.`id`=11767 DESC, `Video`.`id`=11768 DESC, `Video`.`id`=11769 DESC, `Video`.`id`=11942 DESC, `Video`.`id`=11981 DESC, `Video`.`id`=12016 DESC, `Video`.`id`=12048 DESC, `Video`.`id`=11992 DESC, `Video`.`id`=11903 DESC, `Video`.`id`=10733 DESC, `Video`.`id`=10822 DESC, `Video`.`id`=10825 DESC, `Video`.`id`=10826 DESC, `Video`.`id`=10816 DESC, `Video`.`id`=10817 DESC, `Video`.`id`=10710 DESC, `Video`.`id`=12288 DESC, `Video`.`id`=12269 DESC, `Video`.`id`=12476 DESC, `Video`.`id`=12166 DESC, `Video`.`id`=12153 DESC, `Video`.`id`=12549 DESC, `Video`.`id`=12613 DESC, `Video`.`id`=12622 DESC, `Video`.`id`=12843 DESC, `Video`.`id`=12892 DESC, `Video`.`id`=13239 DESC, `Video`.`id`=13330 DESC, `Video`.`id`=13104 DESC, `Video`.`id`=13205 DESC, `Video`.`id`=13034 DESC, `Video`.`id`=12402 DESC, `Video`.`id`=12391 DESC, `Video`.`id`=12372 DESC, `Video`.`id`=12301 DESC, `Video`.`id`=12723 DESC, `Video`.`id`=12792 DESC, `Video`.`id`=12779 DESC, `Video`.`id`=12771 DESC, `Video`.`id`=13342 DESC, `Video`.`id`=13473 DESC, `Video`.`id`=13478 DESC, `Video`.`id`=4727 DESC, `Video`.`id`=4729 DESC, `Video`.`id`=6593 DESC, `Video`.`id`=6831 DESC, `Video`.`id`=7310 DESC, `Video`.`id`=7375 DESC, `Video`.`id`=7376 DESC, `Video`.`id`=6476 DESC, `Video`.`id`=6480 DESC, `Video`.`id`=6483 DESC, `Video`.`id`=6497 DESC, `Video`.`id`=9015 DESC, `Video`.`id`=9016 DESC, `Video`.`id`=9017 DESC, `Video`.`id`=9014 DESC, `Video`.`id`=8095 DESC, `Video`.`id`=8113 DESC, `Video`.`id`=7547 DESC, `Video`.`id`=9488 DESC, `Video`.`id`=9670 DESC, `Video`.`id`=10152 DESC, `Video`.`id`=10153 DESC, `Video`.`id`=11375 DESC, `Video`.`id`=11380 DESC, `Video`.`id`=11383 DESC, `Video`.`id`=11770 DESC, `Video`.`id`=11772 DESC, `Video`.`id`=11649 DESC, `Video`.`id`=10819 DESC, `Video`.`id`=10711 DESC, `Video`.`id`=12233 DESC, `Video`.`id`=12247 DESC, `Video`.`id`=12108 DESC, `Video`.`id`=12565 DESC, `Video`.`id`=12875 DESC, `Video`.`id`=12929 DESC, `Video`.`id`=12979 DESC, `Video`.`id`=12377 DESC, `Video`.`id`=12685 DESC, `Video`.`id`=4721 DESC, `Video`.`id`=7089 DESC, `Video`.`id`=7164 DESC, `Video`.`id`=7370 DESC, `Video`.`id`=6475 DESC, `Video`.`id`=6487 DESC, `Video`.`id`=6491 DESC, `Video`.`id`=6499 DESC, `Video`.`id`=7429 DESC, `Video`.`id`=8983 DESC, `Video`.`id`=8000 DESC, `Video`.`id`=10149 DESC, `Video`.`id`=11939 DESC, `Video`.`id`=11654 DESC, `Video`.`id`=12205 DESC, `Video`.`id`=12062 DESC, `Video`.`id`=12326 DESC, `Video`.`id`=12295 DESC LIMIT 20

SELECT COUNT(*) AS count FROM `vd_videos` AS `Video` LEFT JOIN `usr_membros` AS `Member` ON `Video`.`user` = `Member`.`id` WHERE `Video`.`id` IN(13260, 4709, 6477, 10392, 3232, 4716, 4720, 7086, 7087, 7159, 6582, 7311, 7280, 7374, 6479, 6481, 6484, 6485, 6488, 6493, 6494, 6496, 6498, 7538, 7539, 7540, 7542, 8669, 8674, 8744, 8745, 8746, 8984, 8037, 8118, 8114, 8117, 7716, 7543, 9483, 9485, 9486, 9487, 9667, 10308, 10312, 10313, 10299, 10301, 10151, 11371, 11372, 11382, 11301, 11775, 11776, 11766, 11771, 11773, 11774, 11764, 11972, 12037, 12001, 11835, 11931, 10820, 10821, 10823, 10824, 10827, 10818, 12202, 12237, 12257, 12185, 12420, 12448, 12514, 12435, 12097, 12067, 12121, 12586, 12822, 13257, 13326, 13128, 13149, 13184, 13168, 13080, 12314, 12345, 13381, 13429, 13439, 2963, 1278, 4231, 5859, 4702, 4715, 4717, 4718, 4723, 4724, 4726, 4728, 7088, 7090, 7091, 6874, 7309, 7369, 7371, 7372, 7373, 7377, 6478, 6482, 6486, 6489, 6490, 6492, 6495, 7430, 7431, 7537, 7541, 6340, 8675, 8743, 8730, 8986, 8985, 9264, 9265, 8110, 8111, 8112, 8115, 8116, 7544, 7545, 7546, 9490, 9491, 9492, 9493, 9484, 9489, 9669, 9671, 10306, 10307, 10309, 10310, 10311, 10295, 10300, 10302, 10304, 10150, 10154, 10111, 11373, 11374, 11376, 11378, 11379, 11381, 11765, 11767, 11768, 11769, 11942, 11981, 12016, 12048, 11992, 11903, 10733, 10822, 10825, 10826, 10816, 10817, 10710, 12288, 12269, 12476, 12166, 12153, 12549, 12613, 12622, 12843, 12892, 13239, 13330, 13104, 13205, 13034, 12402, 12391, 12372, 12301, 12723, 12792, 12779, 12771, 13342, 13473, 13478, 4727, 4729, 6593, 6831, 7310, 7375, 7376, 6476, 6480, 6483, 6497, 9015, 9016, 9017, 9014, 8095, 8113, 7547, 9488, 9670, 10152, 10153, 11375, 11380, 11383, 11770, 11772, 11649, 10819, 10711, 12233, 12247, 12108, 12565, 12875, 12929, 12979, 12377, 12685, 4721, 7089, 7164, 7370, 6475, 6487, 6491, 6499, 7429, 8983, 8000, 10149, 11939, 11654, 12205, 12062, 12326, 12295) AND `Video`.`pendente` in (1, 25)

SELECT Member.*, MAX(Hits.data) AS data FROM usr_membros Member INNER JOIN vd_videos_hits Hits ON Hits.user_id = Member.id WHERE Hits.video_id = 12541 AND Member.id > 1 GROUP BY Member.id ORDER BY MAX(Hits.data) DESC LIMIT 30

SELECT COUNT(*) AS count FROM `vd_videos_hits` AS `VideoHits` WHERE `VideoHits`.`user_id` = 1 AND `VideoHits`.`video_id` = 12541

SELECT COUNT(*) AS count FROM `vd_videos_hits` AS `VideoHits` WHERE `VideoHits`.`user_id` > 1 AND `VideoHits`.`video_id` = 12541

SET NAMES utf8

Hosting - Dolfine.com	RSS - Contactos - Publicidade - Termos e Condições - Wallpapers
	BELACENA.COM 2007-2008