Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Service : Changer des lampes

Annonces similaires

Tout voir
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

QUI POUR BRANCHEMENT + PRISE POUR FOUR
Profil du voisin
Alain

Villemomble 93250

15€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE éLECTRICIEN/BRICOLEUR
Profil du voisin
Ludovic L

Rueil-Malmaison 92500

40€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

POSE DE MOTORISATION DE PORTAIL BATTANT
Profil du voisin
Voisin #86536

Issou 78440

25€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

CHANGER UN DISJONCTEUR
Profil du voisin
Alain A
5.0

Boissy-Saint-Leger 94470

30€/h

Proposer mes services
5.0
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UN éLECTRICIEN
Profil du voisin
Julio F

Sainte-Geneviève-des-Bois 91700

-- €

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

ELECTRICITé : RéPARER éCLAIRAGE HOTTE
Profil du voisin
Voisin #129698

Claye-Souilly 77410

30€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

INSTALLER HORLOGE SUR BALLON EAU CHAUDE
Profil du voisin
Frederic L

Flins-sur-Seine 78410

30€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

REMPLACEMENT INTERRUPTEUR (URGENT)
Profil du voisin
Vanessa F

Le Plessis-Trévise 94420

30€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

SERVICE : REMPLACER UNE PRISE
Profil du voisin
Sylvia D

Paris 75017

25€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

TéLéCOMMANDE VOLETS ROULANTS
Profil du voisin
Olivia D

Sucy-en-Brie 94370

-- €

Proposer mes services

Demande un service d'electricien entre voisins ou proposer mes services d'electricien.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='424501'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='electricien' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='583'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'electricien' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='50'

  6. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='248317' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 248317

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  11. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (50) ORDER BY ssrubr_order ASC

  12. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (38) ORDER BY ssrubr_order ASC

  13. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (45) ORDER BY ssrubr_order ASC

  14. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (231) ORDER BY ssrubr_order ASC

  15. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (47) ORDER BY ssrubr_order ASC

  16. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (42) ORDER BY ssrubr_order ASC

  17. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (37) ORDER BY ssrubr_order ASC

  18. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (43) ORDER BY ssrubr_order ASC

  19. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (39) ORDER BY ssrubr_order ASC

  20. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (229) ORDER BY ssrubr_order ASC

  21. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (230) ORDER BY ssrubr_order ASC

  22. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 424501

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=583 LIMIT 1

  24. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='424501'

  25. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='424501' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  26. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 248317 AND util_tel != ''

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 248317 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  28. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 248317 AND W.type_id = 1) OR (W.util_id != 248317 AND W.type_id = 2)) AND (`post_util_id` = 248317 OR `dest_util_id` = 248317) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  29. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='248317' AND note_visu IN (1,3,4)

  30. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '424501'

  31. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='248317' AND wish_id<>'424501' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  32. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='92190'

  33. 0.0085

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8083*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8083*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.24167- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.358639197041 AND ville_latitude_deg<49.257960802959 AND ville_longitude_deg>1.5588902204271 AND ville_longitude_deg<2.9244497795729 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0067

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (92360,92190,92140,92130,92100,92310,92370,92320,92350,92410,92330,92260,92210,92240,92220,78140,92290,92170,78220,92120,92430,92420,92380,92150,92800,92340,91570,91370,94250,94110,78350,94240,94234,94230,94239,94238,94231,94236,94232,94233,94235,94237,92160,78000,78170,94260,92200,91430,78150,91300,92500,91430,78530,94550,78350,94800,94270,75003,75006,75001,75002,75015,75005,75004,75007,75016,75018,75019,75020,75116,75010,75014,75013,75012,75011,75009,75008,75017,75000,78150,92400,91400,91120,92250,78380,94150,78290,94205,94200,92000,92300,78400,91320,92110,78430,78117,94320,92600,94400,91140,92700,91160,92270,93400,78560,78800,78870,91400,91380,91160,78420,78210,94220,94140,91190,94160,91440,78160,94390,94310,78117,78590,78280,94600,91190,78110,91550,91420,78360,91140,91160,95870,78330,94700,93310,78750,78590,93170,78620,78230,92230,94300,91940,78112,94290,78114,92390,93450,93500,78100,91200,93100,78960,95100,93120,94410,93300,78180,91190,91940,91160,93200,93210,93230,78500,93260,78470,94480,93800,78390,94340,78600,91940,91360,78450,94000,78470,78860,91360,78600,91260,94190,91270,91620,95110,91600,91390,91620,94460,95218,95210,94130,78190,91700,95530,93430,91400,94120,94380,93000,78240,91560,95880,93130,78470,78460,93110,91640,91170,93240,93350,91210,78340,94210,94340,94100,95360,78240,93140,91230,78450,95130,94170,91460,91310,95120,91310,94450,91310,95240,78300,91470,93380,95370,91240,95230,94430,94500,93440,91470,94360,91350,95170,91700,93150,93700,93250,95410,91470,93360,78810,94470,91310,95130,78370,78720,91330,91700,95600,78990,78460,95580,95580,78260,95140,91130,91000,78320,93330,94380,94370,78955,91220,91220,95220,78700,78720,78320,91640,95160,78630,91800,95500,91470,93320,93340,94350,94880,94490,94880,93220,91180,95320,91640,95350,95390,78570,95400,91450,91680,95250,95680,78810,78720,78320,94440,78670,78670,95400,95200,91070,91470,95480,94420,78121,94440,91680,78850,93160,78310,91080,91860,95350,93460,78310,78570,95500,91000,91090,78780,91640,91290,78640,91520,91340,95150,95550,91290,78640,78760,94510,95610,95440,93270,91800,91450,93600,93390,93190,78720,94520,94520,78540,93370,95330,94440,78830,78640,78510,95000,91090,78630,91480,95460,77420,78580,91530,77340,91630,95840,95500,91630,95560,95740,78690,77170,78690,95720,78480,91250,91650,91630,95570,91650,91630,91480,78640,77184,77500,93410,77185,78490,93420,95500,95570,78830,91250,95280,93470,77181,78650,95570,95720,95000,91470,78580,95310,91810,91650,95190,78920,91280,77380,78130,78124,77150,95840,91790,91630,95300,78490,78490,95540,78610,78720,77186,95560,95000,91100,95560,95430,95720,91540,78124,95490,95700,91100,93290,91530,77127,77177,95180,77150,78490,77680,91250,77181,78650,91710,91530,77200,91540,91540,95300,78410,91730,77360,78490,95800,78740,95430,95590,95630,77270,78580,77170,91910,95190,91730,91410,78125,95720,91540,95560,78580,78610,77183,77090,78770,78490,78490,91770,91580,95380,78730,78730,95520,77330,78740,95650,78770,78126,95570,78130,95850,78770,77410,95270,78490,78490,91510,91730,91510,95190,95650,95760,78410,78770,77600,91850,91530,78120,77173,78250,95450,91250,91830,78770,77400,91760,95270,95650,91610,78250,95270,95300,77400,78610,77166,77135,77290,78410,91750,95380,91580,95380,78410,78410,77550,77600,77600,77164,78250,95300,78250,77166,95850,77400,78770,91410,95290,95450,95380,95620,91580,95590,77176,91580,78120,91410,78940,78680,78490,77990,95380,78730,78250,91590,77600,95650,95650,77990,91830,77400,78580,78820,77410,77400,78770,95270,95270,91750,95670,95450,77550,78890,91580,95660,95260,95270,77400,95260,78610,78120,95270,95690,95590,95450,77240,95810,95270,95690,95270,77176,77600,78970,77410,78930,77111,95470,77400,77220,95270,91590,77410,95270,95450,77170,78940,95810,95470,95270,78910,77600,78730,78930,78910,77240,78440,77290,77550,77144,78490,77310,77410,95450,91580,77230,78250,95830,95340,91410,91590,78730,95450,91590,91590,77230,95690,77240,77410,95830,78790,78790,95690,77220,78125,95470,77410,77230,95810,91590,77550,77310,77230,78440,78910,77111,91750,91410,78440,77700,78790,77144,77220,95810,95450,95470,78440,95450,78930,77230,78440,91870,78910,77390,60230,95340,78125,77700,77220,91150,91590,77950,78125,95340,95810,78440,95820,77450,77310,77220,91590,91410,78660,60260,91890,91150,60820,78440,78440,77174,60128,77450,78910,77350,95450,95450,77230,77950,60560,78910,95640,60580,78930,95450,77230,77230,60530,77390,77950,91880,78125,91840,91410,60520,95640,95640,78520,78930,77350,78930,77410,77230,78930,77950,78790,77700,78550,77700,77410,78711,78200,91150,91150,78440,77390,78950,95450,95640,95450,77350,78790,77700,91820,78113,91820,77410,77930,77230,78113,78125,95810,77930,78200,60128,91490,77390,95640,77450,78790,77174,77930,77190,95640,60540,60530,60540,77610,95810,60270,91780,91780,77000,77000,78660,78200,60530,77450,78440,77610,77165,78440,77390,78550,95640,95420,95640,77450,78790,77410,95510,77610,60520,91410,77950,78125,77930,77450,77230,77280,78200,77450,60110,60460,91720,78113,91490,78660,77190,77165,78520,91490,78200,78125,77450,77165,77165,77580,78910,77230,77390,78660,91410,60240,77860,91410,60330,60540,91150,60520,78200,60530,60540,77930,78125,78790,60119,60110,60950,60530,95750,78550,77930,77000,91150,95510,28230,78550,78200,95420,95450,95750,77950,78125,28230,78125,78910,77610,78660,78200,91410,77000,77860,60500,60119,78660,91720,95420,95420,78200,78520,77230,60460,78111,60340,78113,95510,77390,60500,91780,78550,78550,28320,60340,91150,60530,60540,77390,78660,77610,78113,78200,60530,77124,77390,91720,95420,77630,77100,78980,77165,60740,60110,28700,77115,77720,77860,28700,77630,78200,60330,77610,77390,77115,60119,91490,77100,77124,78910,60300,60300,28700,28410,78113,60240,77580,77580,60175,77610,78790,95780,60240,95420,77122,77580,77390,28210,91150,60240,91150,28130,60240,60950,95420,95510,78710,77590,91720,60570,28410,78790,77163,78200,77163,91690,60173,78980,77124,28410,77390,77178,77630,91690) AND fami_id='3' AND cate_id='50' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='583' AND wish_id<>'424501' AND wish_url='' ORDER BY rand() LIMIT 0,10

  35. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  36. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=14760 AND note_visu IN (1,3,4)

  37. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 14760 AND W.type_id = 1) OR (W.util_id != 14760 AND W.type_id = 2)) AND (`post_util_id` = 14760 OR `dest_util_id` = 14760) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  38. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 14760

  39. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  40. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=65936 AND note_visu IN (1,3,4)

  41. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 65936 AND W.type_id = 1) OR (W.util_id != 65936 AND W.type_id = 2)) AND (`post_util_id` = 65936 OR `dest_util_id` = 65936) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 65936

  43. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  44. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86536 AND note_visu IN (1,3,4)

  45. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86536 AND W.type_id = 1) OR (W.util_id != 86536 AND W.type_id = 2)) AND (`post_util_id` = 86536 OR `dest_util_id` = 86536) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  46. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 86536

  47. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  48. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=285656 AND note_visu IN (1,3,4)

  49. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 285656 AND W.type_id = 1) OR (W.util_id != 285656 AND W.type_id = 2)) AND (`post_util_id` = 285656 OR `dest_util_id` = 285656) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  50. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 285656

  51. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  52. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=213816 AND note_visu IN (1,3,4)

  53. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 213816 AND W.type_id = 1) OR (W.util_id != 213816 AND W.type_id = 2)) AND (`post_util_id` = 213816 OR `dest_util_id` = 213816) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  54. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 213816

  55. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  56. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129698 AND note_visu IN (1,3,4)

  57. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 129698 AND W.type_id = 1) OR (W.util_id != 129698 AND W.type_id = 2)) AND (`post_util_id` = 129698 OR `dest_util_id` = 129698) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  58. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 129698

  59. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  60. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=6381 AND note_visu IN (1,3,4)

  61. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 6381 AND W.type_id = 1) OR (W.util_id != 6381 AND W.type_id = 2)) AND (`post_util_id` = 6381 OR `dest_util_id` = 6381) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  62. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 6381

  63. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  64. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196098 AND note_visu IN (1,3,4)

  65. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196098 AND W.type_id = 1) OR (W.util_id != 196098 AND W.type_id = 2)) AND (`post_util_id` = 196098 OR `dest_util_id` = 196098) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  66. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 196098

  67. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  68. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=151625 AND note_visu IN (1,3,4)

  69. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 151625 AND W.type_id = 1) OR (W.util_id != 151625 AND W.type_id = 2)) AND (`post_util_id` = 151625 OR `dest_util_id` = 151625) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  70. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 151625

  71. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='583' LIMIT 0,1

  72. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=251279 AND note_visu IN (1,3,4)

  73. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 251279 AND W.type_id = 1) OR (W.util_id != 251279 AND W.type_id = 2)) AND (`post_util_id` = 251279 OR `dest_util_id` = 251279) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  74. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 251279

  75. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 583

  76. 0.0009

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  77. 0

    SELECT count(*) as nbwish FROM wish

  78. 0.0464

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

78 requetes sql en 0.0705

Taille variable Globale : 57.46 KB