RO    EN    
 


Topul vlogurilor din Romania

  Categorii Toate categoriile  
Activitati zilniceDezvoltare software CulinareCritici vloguriExperimente stiintifice
MuzicaCoafura, frizerieJocuri PCTehnologie, gadgeturiJurnalistica
CopilarieFilmeDivertismentTopuri, clasamente, curiozitatiTeatru
Comedie, umoristicaCiclismMotociclismModa/Frumusete/MachiajMestesugarit
Desene animateCalatoriiJocuri in aer liberSuferintaScene socante
TutorialeSport, antrenamenteTalk showTraficExperimente sociale
ParodiiEducationalCantece copii miciDocumentarePasari
AnimaleMistere, enigmeViata de familieMasiniInterviuri
JucariiAnimatiiSlimeBloguriCultura generala
PovestiTrucuri magiceLogicaArta seductieiHip Hop
AventuriPolitica   
Dupa numarul de abonatiDupa nr videoclipuriDupa total vizualizariRaport vizualizari/videoclipuriMedie abonati ziMedie videoclipuri ziMedie vizualizari zi
Categoria: Experimente socialeTop medie videoclipuri pe zi [Vloguri] [Canale]Tara [Toate] [Romania] [Moldova]  Topul disstrack-urilor
select v.id as id_vlog, v.title, v.platforma, v.abonati, v.nr_videos, v.vizualizari, DATE_FORMAT(v.last_update, '%d.%m.%Y %H:%i:%s') as d_last_update, v.autor, DATE_FORMAT(v.data_creare, '%d.%m.%Y') as data_start, v.id_canal, v.id_spec1, cs.denumire_ro as city_s_ro , cs.denumire_en as city_s_en, ts.denumire_ro as country_s_ro , ts.denumire_en as country_s_en, c.denumire_ro as city_ro , c.denumire_en as city_en, t.denumire_ro as country_ro , t.denumire_en as country_en, l.denumire_ro as lang_ro, l.denumire_en as lang_en , v.nr_videos/DATEDIFF(v.last_update, v.data_creare) as vid_zi , vid_zi_vl as ord_saved from vlogs v left outer join clasamente_vloguri cv on cv.id_vlog=v.id left outer join cities cs on cs.id_city=v.id_city_sursa left outer join regions rs on rs.id_region=cs.id_region left outer join countries ts on ts.id_country=v.id_country_sursa left outer join cities c on c.id_city=v.id_city_curent left outer join regions r on r.id_region=c.id_region left outer join countries t on t.id_country=v.id_country_curent left outer join languages l on l.id_lang=v.id_lang where 1=1 and v.tip_canal=1 and v.stare=0 and id in (select id_vlog from vlogs_categories where id_categorie= 30) /* and (v.abonati>10000 or v.abonati=0) and v.vizualizari>100000) */ order by ord_saved limit 0, 20
1052: Column 'id' in IN/ALL/ANY subquery is ambiguous

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/city-star.org/httpdocs/lib/database.php on line 182
Nr crtPozVideo/ziTitluData startPlatformaAbonatiVideoclipuriTotal vizualizariCategoriiLimbaTara curentaTara origine
             
 
 
1-20 


eXTReMe Tracker
© 1999 - 2020 (site) © 2016 - 2020 (pagina) Dan Mihaiu, Europa, Romania
Despre statisticile site-ului   Despre site   Copyright   Statistici   Privacy Policy   Site principal