AccueilMes livresAjouter des livres
Découvrir
LivresAuteursLecteursCritiquesCitationsListesQuizForum
Rejoignez Babelio pour découvrir vos prochaines lectures

Listes avec des livres de cet auteur


Quiz Voir plus

Au dela du mal

Dans ce roman le sérial killer commence assez jeune à tuer...quel age a t'il lorsqu'il tue sa premiére victime

20 ans
15 ans
10 ans
18 ans

10 questions
61 lecteurs ont répondu
Thème : Au-delà du mal de Shane StevensCréer un quiz sur cet auteur
id_auteur=104583
Temps Emplacement 47 Requettes -0.003s - 0.111s
0 0.051 fonctions.php(666)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select country_code from `geoip` where ipnum_start<= "1373381079" and "1373381079" <=ipnum_end;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEgeoip system1 geoip_lookup 132439 Using where
1 0 headerauteur.php(16)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT a.id as id_auteur, a.* FROM t_auteur a inner join t_auteur2auteur a2a on a2a.id_1 = a.id WHERE a2a.id_2= "104583"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEa2a refid_1,canonique,secondaire secondaire 4 const 1
1 SIMPLEa eq_refPRIMARY PRIMARY 4 babelio_babelio2.a2a.id_1 1
2 0 headerauteur.php(23)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT a.id as id_auteur, a.* FROM t_auteur a inner join t_auteur2auteur a2a on a2a.id_1 = a.id WHERE a2a.id_1= "104583"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEa constPRIMARY PRIMARY 4 const 1
1 SIMPLEa2a refid_1,canonique id_1 4 const 1 Using where; Using index
3 0 headerauteur.php(76)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT a.id,a.nom,a.prenoms,en_active,en_explicite,en_no_gen FROM t_auteur a inner join t_auteur2auteur a2a on a2a.id_2 = a.id WHERE a2a.id_1= "104583" ORDER BY ca_copies desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEa2a refid_1,canonique,secondaire id_1 4 const 1 Using index; Using temporary; Using filesort
1 SIMPLEa eq_refPRIMARY PRIMARY 4 babelio_babelio2.a2a.id_2 1
4 0 headerauteur.php(163)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT url,description, credits,login,u.id as id_user,dt FROM t_auteur_photos p inner join t_user u on u.id = p.id_user WHERE p.id_auteur in (68677,104583) ORDER BY p.dt desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEp rangeauteur,id_user auteur 4 2 Using index condition; Using filesort
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.p.id_user 1
5 0 headerauteur.php(187)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(distinct c.id) as nb FROM t_oeuvre o inner join t_citation c on c.id_oeuvre = o.id WHERE o.id_auteur in (68677,104583)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEo rangePRIMARY,auteur,id auteur 4 5 Using where; Using index
1 SIMPLEc refoeuvre oeuvre 5 babelio_babelio2.o.id 6 Using index
6 0 headerauteur.php(200)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb FROM t_citation c WHERE c.id_auteur in (68677,104583) and c.id_oeuvre is null
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEc rangeoeuvre,id_auteur id_auteur 4 33 Using index condition; Using where
7 0 headerauteur.php(214)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb FROM t_auteur_videos p WHERE p.id_auteur = 104583
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEp refauteur auteur 4 const 5 Using index
8 0 headerauteur.php(224)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb from t_podcast p WHERE p.id_auteur = 104583
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEp refid_auteur_2,id_auteur id_auteur_2 4 const 1 Using index
9 0 infoauteur_.php(263)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb from t_auteur2oeuvre where id_auteur_canonique = "104583"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_auteur2oeuvre refid_auteur_canonique id_auteur_canonique 5 const 5 Using index
10 0 infoauteur_.php(273)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb from t_auteur2edition ae inner join t_codes_fonction f on f.code = ae.role where ae.id_auteur_canonique = "104583" and edition_principale=1 and role<>070
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEae refid_auteur_canonique,role,edition_principale id_auteur_canonique 5 const 12 Using where
1 SIMPLEf refcode code 5 babelio_babelio2.ae.role 1 Using where; Using index
11 0.002 infoauteur_.php(328)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 20 #
SELECT t1.id,libelle,t1.categorie,t1.cluster,count(*) as nb,no_aff,t1.no_reco FROM t_tag2 t1 inner join t_tag2oeuvre t2 on t2.id_tag_canonique = t1.id INNER JOIN t_oeuvre o on o.id = t2.id_oeuvre inner join t_auteur2oeuvre ao on ao.id_oeuvre = o.id WHERE ao.id_auteur_canonique = 104583 group by t1.id ORDER BY nb desc LIMIT 0,20
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEao refid_oeuvre,id_oeuvre_2,oeuvre,id_auteur_canonique id_auteur_canonique 5 const 5 Using temporary; Using filesort
1 SIMPLEo eq_refPRIMARY,id PRIMARY 4 babelio_babelio2.ao.id_oeuvre 1 Using index
1 SIMPLEt2 refid_oeuvre,id_oeuvre_2,Index_8,id_tag_canonique Index_8 4 babelio_babelio2.ao.id_oeuvre 14 Using where; Using index
1 SIMPLEt1 eq_refPRIMARY,libelle,ca_occurences,cluster,badges_cluster,ca_oeuvres PRIMARY 4 babelio_babelio2.t2.id_tag_canonique 1 Using where
12 0.002 infoauteur_.php(426)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb FROM t_oeuvre o inner join t_auteur2oeuvre ao on ao.id_oeuvre = o.id inner join t_critique c on c.id_oeuvre = o.id inner join t_user u on c.id_user = u.id WHERE ao.id_auteur_canonique = 104583 and u.biblio_publique = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEao refid_oeuvre,id_oeuvre_2,oeuvre,id_auteur_canonique id_auteur_canonique 5 const 5
1 SIMPLEo eq_refPRIMARY,id PRIMARY 4 babelio_babelio2.ao.id_oeuvre 1 Using index
1 SIMPLEc refuser,oeuvre oeuvre 5 babelio_babelio2.ao.id_oeuvre 4
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.c.id_user 1 Using where
13 0.002 infoauteur_.php(439)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT texte FROM t_interview WHERE id_auteur in (68677,104583)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_interview system1 234 Using where
14 0.001 infoauteur_.php(474)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 10 #
SELECT c.premiere_phrase,c.nb_votes,c.nb_comm,o.anom ,o.aprenoms ,o.id_auteur as aid_auteur,o.titre, o.id as id_oeuvre,o.ca_couverture as url_couverture, c.id as id_citation, u.id as id_user,u.login, texte, c.dt, a.prenoms,a.nom,a.id as id_auteur,url_photo, c.nb_votes+ log(length(texte)) + case when datediff(now(),c.dt) <16 then 20-datediff(now(),c.dt) else 0 end as tri FROM t_citation c INNER JOIN t_auteur a on a.id = c.id_auteur INNER JOIN t_user u on u.id = c.id_user LEFT JOIN t_oeuvre o on o.id = c.id_oeuvre WHERE c.id_auteur in (68677,104583) ORDER BY tri DESC LIMIT 0,10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEc rangeuser,id_auteur id_auteur 4 33 Using index condition; Using filesort
1 SIMPLEa eq_refPRIMARY PRIMARY 4 babelio_babelio2.c.id_auteur 1
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.c.id_user 1
1 SIMPLEo eq_refPRIMARY,id PRIMARY 4 babelio_babelio2.c.id_oeuvre 1
15 0 infoauteur_.php(500)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
select p.id,p.titre,p.sous_categorie,pl.annee from t_prix p inner join t_prix2laureat pl on p.id = pl.id_prix where pl.id_auteur in (68677,104583) ORDER BY annee desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEpl rangeid_auteur id_auteur 4 2 Using index condition; Using filesort
1 SIMPLEp eq_refPRIMARY PRIMARY 4 babelio_babelio2.pl.id_prix 1
16 0 infoauteur_.php(592)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT id,description,lien,id_user FROM t_auteur_liens b WHERE b.id_auteur in (68677,104583) ORDER BY dt desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEb system1 Index_2 3 Using where; Using filesort
17 0 infoauteur_.php(642)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT SQL_CALC_FOUND_ROWS script from t_podcast p WHERE p.id_auteur in (68677,104583) ORDER BY p.dt desc
18 0 infoauteur_.php(647)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT FOUND_ROWS() as nb ;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLENo tables used
19 0 infoauteur_.php(663)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 8 #
SELECT iframe,script as url,description, login,u.id as id_user,dt,image,p.id FROM t_auteur_videos p inner join t_user u on u.id = p.id_user WHERE p.id_auteur in (68677,104583) ORDER BY p.dt desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEp rangeauteur,id_user auteur 4 8 Using index condition; Using filesort
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.p.id_user 1
20 0 infoauteur_.php(675)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT * from t_dossier_auteur WHERE id_auteur in (68677,104583) ;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_dossier_auteur rangeid_auteur id_auteur 4 2 Using index condition
21 0 infoauteur_.php(715)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT url,description, credits,login,u.id as id_user,dt FROM t_auteur_photos p inner join t_user u on u.id = p.id_user WHERE p.id_auteur in (68677,104583) ORDER BY p.dt desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEp rangeauteur,id_user auteur 4 2 Using index condition; Using filesort
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.p.id_user 1
22 0 infoauteur_.php(730)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT count(*) as nb from t_auteur_videos where id_auteur in (68677,104583)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_auteur_videos rangeauteur auteur 4 8 Using where; Using index
23 0 infoauteur_.php(743)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT description,b.pays, p.pays as nom_pays, dt_naissance,dt_deces,lieu_naissance,lieu_deces,id_user,dt,source FROM t_auteur_bio b LEFT join t_user u on u.id = b.id_user LEFT JOIN t_pays p on p.id = b.pays WHERE b.id_auteur in (68677,104583) ORDER BY dt desc LIMIT 0,1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEb rangeauteur auteur 4 2 Using index condition; Using filesort
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.b.id_user 1 Using index
1 SIMPLEp eq_refPRIMARY PRIMARY 8 babelio_babelio2.b.pays 1 Using where
24 0 infoauteur_.php(761)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT max(dt) as dt_,id_user,login from t_auteur_bio d INNER join t_user u on u.id = d.id_user WHERE d.id_auteur in (68677,104583) GROUP BY u.id ORDER by dt_ desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEd rangeauteur,id_user auteur 4 2 Using index condition; Using temporary; Using filesort
1 SIMPLEu eq_refPRIMARY,login,dt_inscription,email,ca_calsse_cri,critiques_privees,spec_account PRIMARY 4 babelio_babelio2.d.id_user 1
25 0 infoauteur_.php(786)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT titre FROM t_oeuvre o WHERE o.id_auteur_canonique in (68677,104583) order by o.ca_copies DESC LIMIT 0, 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEo rangeIndex_24 Index_24 4 6 Using index condition; Using filesort
26 0.001 infoauteur_droit.php(37)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT c.id_cluster,count(*) as nb from t_o2bcluster c inner join t_oeuvre o on o.id = c.id_oeuvre where o.id_auteur in (68677,104583) and c.id_cluster > 0 group by c.id_cluster having nb>1 order by nb desc
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEo rangePRIMARY,auteur,id auteur 4 5 Using where; Using index; Using temporary; Using filesort
1 SIMPLEc refid_oeuvre_2,id_oeuvre,id_cluster,id_cluster_2 id_oeuvre_2 4 babelio_babelio2.o.id 2 Using where; Using index
27 0.001 infoauteur_droit.php(44)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 4 #
select * from t_paramg where type='CAMPAGNES_24_7' and id>1 and val4=1 order by id
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_paramg refPRIMARY,type,type_2 type 52 const 75 Using index condition; Using where; Using filesort
28 0 infoauteur_droit.php(92)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
SELECT * from t_oeuvre2encart where (id_item = "104583" and type=3) or (id_item = "" and type=2) or (id_item = "" and type=4) or (exists (select * from t_filtre2user where id_user="" and id_filtre=id_item and type=5))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 PRIMARYt_oeuvre2encart system1 type 8 Using where
2 DEPENDENT SUBQUERYt_filtre2user eq_refid_filtre id_filtre 8 babelio_babelio2.t_oeuvre2encart.id_item,const 1 Using where; Using index
29 0 infoauteur_droit.php(146)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 2 #
SELECT SQL_CALC_FOUND_ROWS titre, o.id, o.ca_couverture as url_couverture, o.dt_first_edition, datediff(o.dt_first_edition,NOW()) as intervalle, ca_note as note, o.ca_nb_critiques , o.ca_copies as nb,o.ca_nb_citations FROM t_oeuvre o inner join t_auteur2oeuvre ao on ao.id_oeuvre = o.id WHERE ao.id_auteur_canonique = 104583 and o.canonique=1 GROUP BY o.id order by o.dt_first_edition desc, nb desc LIMIT 0,8
30 0 infoauteur_droit.php(154)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT FOUND_ROWS() as nb ;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLENo tables used
31 0.014 infoauteur_droit.php(215)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 9 #
SELECT SQL_CALC_FOUND_ROWS u.id, u.login, u.photo, max(b.id) as biblio,count(*) as nb FROM t_user u INNER JOIN t_bibliotheque b ON u.id = b.id_user inner join t_auteur2oeuvre ao on ao.id_oeuvre = b.id_oeuvre WHERE ao.id_auteur_canonique = "104583" AND statut =1 GROUP BY u.id ORDER BY count(*) DESC LIMIT 0,9
32 0 infoauteur_droit.php(223)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT FOUND_ROWS() as nb ;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLENo tables used
33 0.003 infoauteur_droit.php(250)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 6 #
SELECT a.prenoms,a.nom ,a.id as id_auteur,a.url_photo, sum(log(80-pos)*(o.ca_copies)) as score FROM t_oeuvre o INNER JOIN t_recos r ON r.id_1 = o.id inner join t_oeuvre o2 on r.id_2 = o2.id inner join t_auteur a on a.id = o2.id_auteur_canonique WHERE o.id_auteur_canonique =104583 AND a.id>0 and r.algo =44424 GROUP BY a.id ORDER by score DESC LIMIT 0,6
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEo refPRIMARY,Index_24,id Index_24 4 const 5 Using temporary; Using filesort
1 SIMPLEr refid_1,id_2,algo id_1 4 babelio_babelio2.o.id 79 Using index condition; Using where
1 SIMPLEo2 eq_refPRIMARY,Index_24,id PRIMARY 4 babelio_babelio2.r.id_2 1 Using where
1 SIMPLEa eq_refPRIMARY,prenoms,nom,ca_membres,ca_nb_citations,ca_note,ca_variance,ca_oeuvres,Index_8,Index_9,id_bnf,id_sudoc,ca_copies,ca_membres_2,srch_vector PRIMARY 4 babelio_babelio2.o2.id_auteur_canonique 1 Using where
34 0 infoauteur_droit.php(259)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 0 #
select id_user,u.spec_account from t_auteur_user au inner join t_user u on u.id = au.id_user where id_auteur ="104583"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEau refid_auteur,id_user id_auteur 4 const 1
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.au.id_user 1 Using where
35 0.001 infoauteur_droit.php(280)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 2 #
select l.id,l.image,img_couv_thumb,l.titre,l.nb_livres,u.id as id_user,u.login,l.description from t_liste l inner join t_user u on u.id = l.id_user inner join t_liste2oeuvre qt on qt.id_liste = l.id inner join t_oeuvre o on o.id = qt.id_oeuvre and o.id_auteur_canonique = "104583" where publique >1 and publie = 1 group by l.id order by nb_votes DESC LIMIT 0,3
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEo refPRIMARY,Index_24,id Index_24 4 const 5 Using index; Using temporary; Using filesort
1 SIMPLEqt refid_liste,id_oeuvre id_oeuvre 4 babelio_babelio2.o.id 1
1 SIMPLEl eq_refPRIMARY,id_user,publique PRIMARY 4 babelio_babelio2.qt.id_liste 1 Using where
1 SIMPLEu eq_refPRIMARY PRIMARY 4 babelio_babelio2.l.id_user 1
36 0.001 articles_bloc_droite.php(5)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 3 #
select * from t_article where publie = 1 order by niveau, priorite desc, id desc limit 0,3;
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_article system1 id 398 Using where; Using filesort
37 0 infoauteur_droit.php(307)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select q.* from t_q_quiz q WHERE id_auteur = "104583" and statut = 1 and q.classification>1 and adulte=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEq refid_auteur id_auteur 5 const 1 Using where
38 0 infoauteur_droit.php(387)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select * from t_q_quiz WHERE id = "4126"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_q_quiz constPRIMARY PRIMARY 4 const 1
39 0 infoauteur_droit.php(410)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select * from t_oeuvre WHERE id = "122261"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_oeuvre constPRIMARY,id PRIMARY 4 const 1
40 0 infoauteur_droit.php(435)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select * from t_q_question WHERE numero = "1" and id_quiz = "4126"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_q_question refid_quiz id_quiz 4 const 10 Using where
41 0 infoauteur_droit.php(441)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 4 #
select * from t_q_reponse WHERE id_question = "37145" ORDER BY numero
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_q_reponse refid_question_2,id_question id_question_2 4 const 4 Using index condition
42 0 header.php(149)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
SELECT * from babelio_phpbb.t_ca_global where id = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_ca_global systemPRIMARY 1
43 -0.001 headerFF.tpl(283)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 -INF%
# #
headerFF.tpl
44 -0.001 headerAuteur.tpl(932)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 -INF%
# #
headerAuteur.tpl
45 -0.001 infoauteur.tpl(938)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 -INF%
# #
infoauteur.tpl
46 0 php/Smarty3/plugins/function.paramg.php(11)
zéro
Warning: Division by zero in /home/www/babelio/public_html/php/Smarty3/templates_c/34c725a96a72eee60d05c8ba02289d9629bb24f8_1.file.footer2.tpl.php on line 234 NAN%
# 1 #
select * from t_paramg where type="CARRE_PUB" and nom="auteur"
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1 SIMPLEt_paramg consttype,type_2,nom type 104 const,const 1

. .