Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Trouver un serrurier

Annonces similaires

Tout voir
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UN SERRURIER
Profil du voisin
Voisin #171803

Courbevoie 92400

40€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

INSTALLATION SERRURE
Profil du voisin
Hamza B

Gentilly 94250

20€

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

CHANGEMENT SERRURE BOITE AUX LETTRES
Profil du voisin
Lilia C

Rambouillet 78120

30€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

CHANGEMENT DE SERRURE (3H)
Profil du voisin
Voisin #113924

Saint-Ouen 93400

200€

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

BESOIN D'UN SERRURIER
Profil du voisin
Lea B

Montry 77450

100€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : OUVERTURE DE PORTE
Profil du voisin
Hyppo Y

Colombes 92700

50€

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

OUVERTURE BOITE AUX LETTRES
Profil du voisin
Greg P

Puteaux 92800

-- €

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : SERRURIER
Profil du voisin
Bessa M

Sannois 95110

15€

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

CLé CASSéE DANS SERRURE
Profil du voisin
Mireille iris M

Saint-Germain-en-Laye 78100

40€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

CHERCHE SERRURIER POUR OUVERTURE PORTE
Profil du voisin
Djamila M

Noisy-le-Roi 78590

20€/h

Proposer mes services

Demande un service de serrurerie entre voisins ou proposer mes services de serrurerie.

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='266249'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='serrurier' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1071'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'serrurier' 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='49491' 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` = 49491

  9. 0

    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.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 (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.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 (43) ORDER BY ssrubr_order ASC

  19. 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 (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.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 (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 = 266249

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1071 LIMIT 1

  24. 0.0001

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

  25. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='266249' 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` = 49491 AND util_tel != ''

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 49491 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 = 49491 AND W.type_id = 1) OR (W.util_id != 49491 AND W.type_id = 2)) AND (`post_util_id` = 49491 OR `dest_util_id` = 49491) 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='49491' 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 = '266249'

  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='49491' AND wish_id<>'266249' 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='92500'

  33. 0.0056

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.5161968758251 AND ville_longitude_deg<2.8838031241749 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0026

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

  38. 0.0001

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

  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='1071' 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=419705 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 = 419705 AND W.type_id = 1) OR (W.util_id != 419705 AND W.type_id = 2)) AND (`post_util_id` = 419705 OR `dest_util_id` = 419705) 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 = 419705

  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='1071' 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=403790 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 = 403790 AND W.type_id = 1) OR (W.util_id != 403790 AND W.type_id = 2)) AND (`post_util_id` = 403790 OR `dest_util_id` = 403790) 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 = 403790

  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='1071' 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=113924 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 = 113924 AND W.type_id = 1) OR (W.util_id != 113924 AND W.type_id = 2)) AND (`post_util_id` = 113924 OR `dest_util_id` = 113924) 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 = 113924

  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='1071' 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=300296 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 = 300296 AND W.type_id = 1) OR (W.util_id != 300296 AND W.type_id = 2)) AND (`post_util_id` = 300296 OR `dest_util_id` = 300296) 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 = 300296

  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='1071' 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=469782 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 = 469782 AND W.type_id = 1) OR (W.util_id != 469782 AND W.type_id = 2)) AND (`post_util_id` = 469782 OR `dest_util_id` = 469782) 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 = 469782

  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='1071' 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=243346 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 = 243346 AND W.type_id = 1) OR (W.util_id != 243346 AND W.type_id = 2)) AND (`post_util_id` = 243346 OR `dest_util_id` = 243346) 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 = 243346

  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='1071' 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=441116 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 = 441116 AND W.type_id = 1) OR (W.util_id != 441116 AND W.type_id = 2)) AND (`post_util_id` = 441116 OR `dest_util_id` = 441116) 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 = 441116

  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='1071' 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=192349 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 = 192349 AND W.type_id = 1) OR (W.util_id != 192349 AND W.type_id = 2)) AND (`post_util_id` = 192349 OR `dest_util_id` = 192349) 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 = 192349

  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='1071' 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=13010 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 = 13010 AND W.type_id = 1) OR (W.util_id != 13010 AND W.type_id = 2)) AND (`post_util_id` = 13010 OR `dest_util_id` = 13010) 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 = 13010

  75. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  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.0478

    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.0645

Taille variable Globale : 57.51 KB