Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Appel d'offre sur 10 portes blindées

Annonces similaires

Tout voir
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 92210

Pose d'une (paire) poignée de tirage
Profil du voisin
Voisin #59001

Saint-Cloud 92210

20€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 78510

Clé cassée dans la serrure (urgent)
Profil du voisin
Mely Y

Triel-sur-Seine 78510

35€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 95310

Porte d’entrée bloqué
Profil du voisin
Dede C

Saint-Ouen-l'Aumone 95310

20€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 91560

Remplacement serrure porte d'entrée
Profil du voisin
Aminata T

Crosne 91560

45€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 78590

Cherche serrurier pour ouverture porte
Profil du voisin
Djamila M

Noisy-le-Roi 78590

20€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 94800

Service : ouvrir une porte
Profil du voisin
Aly T

Villejuif 94800

20€

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 93210

Ouvrir ma serrure de boîte aux lettres
Profil du voisin
Fatou D

Saint-Denis 93210

15€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 94450

Problème serurier
Profil du voisin
Taieb A

Limeil-Brévannes 94450

25€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 91220

Serrurier : ouvrir ma boîte aux lettres
Profil du voisin
Alison K

Brétigny-sur-Orge 91220

35€/h

Proposer mes services
Service serrurier
Service : serrurier

Demande il y a + de 30j

Il y a + de 30j • 75016

Serrurier porte claquée urgent
Profil du voisin
Myroam T

Paris 75016

100€/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='341748'

  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, 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

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='146164' 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` = 146164

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

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

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

  15. 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 (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.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 (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.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.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 (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 = 341748

  23. 0.0001

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

  24. 0.0001

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

  25. 0.0001

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

  26. 0

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

  27. 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 = 146164 AND W.type_id = 1) OR (W.util_id != 146164 AND W.type_id = 2)) AND (`post_util_id` = 146164 OR `dest_util_id` = 146164) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  28. 0.0001

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

  29. 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 = '341748'

  30. 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='146164' AND wish_id<>'341748' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  31. 0.0001

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

  32. 0.0058

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.500339197041 AND ville_latitude_deg<49.399660802959 AND ville_longitude_deg>1.8319532137498 AND ville_longitude_deg<3.2013867862502 HAVING distance <= 50 ORDER BY distance ASC

  33. 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 (93600,93270,93420,93410,93290,93190,93390,93700,93150,93320,93340,95700,95500,95500,77181,93470,95500,93140,95500,93370,93440,93000,93250,93220,95140,93350,77270,95400,77290,77181,93130,95190,93360,95380,93110,95380,95720,77990,93260,93230,77500,93240,93460,93500,93120,93300,77410,77990,93100,93380,77410,94170,93330,95380,95400,95200,93310,77177,94120,95380,93160,93200,93210,95720,93170,95190,95440,95350,77290,95360,77230,94300,77420,95410,93430,94360,94130,95380,94350,77230,77230,77410,77360,95470,77410,92390,93450,95190,95170,77410,95720,77186,95350,77400,95850,77230,95460,95160,77230,93400,95880,77200,94500,95670,94160,77185,77410,93800,95470,94340,94420,77400,94410,95720,95850,77230,77400,92230,77410,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95230,95330,77230,77400,77230,77400,95570,77230,77600,95270,94220,77184,94430,94100,94210,94340,95580,95580,92110,95470,95470,77090,77183,95270,95210,95218,77400,95270,95270,60128,95570,77600,77600,92600,77230,77400,95270,94200,94205,94700,95600,92300,77340,77600,94140,77410,95570,94270,95680,95120,92270,77450,94490,94880,94880,94000,77165,77230,94510,77280,95570,77680,77600,77144,95100,77410,95270,60128,95560,77230,95110,77410,95390,77165,92200,77144,77700,77410,92700,77164,95270,94800,60330,94250,92400,77165,77165,92250,77450,60560,95270,94400,60520,94370,94380,95560,92170,94380,95270,60950,77450,95560,95320,92120,95130,95560,77230,94110,77135,95130,77600,77700,94600,92240,95870,77450,94470,60520,95840,77700,60580,94460,95590,60330,94320,77450,77165,92800,92150,60520,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,92220,60260,95270,77330,95240,92100,77450,78800,92130,77124,95270,94550,95150,95550,92000,77450,77700,94310,94390,92320,94450,94440,95250,77122,92500,77450,78500,92340,95590,95270,60950,95840,77178,95530,95740,94190,95370,78420,60330,92140,92210,94290,77150,92260,92330,94150,77178,77860,77174,77700,92190,92360,77150,77100,77124,77100,60950,95590,77124,91330,94440,92350,77580,95220,94440,91560,77170,95540,95260,60330,95480,94260,77860,77165,77165,78600,60270,94480,60820,60300,60300,77124,78360,92380,92160,91200,95260,77860,92290,95430,95630,92310,77174,92410,91320,95290,77910,78400,91800,60300,60300,60500,94520,94520,60440,60500,77100,92430,92420,60300,95660,95820,91550,77173,77220,91230,60300,77139,95760,78600,77910,92370,95430,95620,95340,91270,91370,95340,60300,77220,60440,78170,60300,78290,78380,60440,77580,77580,60440,91300,78140,91860,91800,77139,78110,60460,60740,78560,77580,77220,77580,91480,77470,60340,91210,60300,77170,78220,60440,78700,78430,77470,60340,77610,91420,77910,78230,77580,60230,60530,77220,60300,91260,95310,91570,95610,60300,91480,60810,77166,77470,77470,95690,77380,77139,78150,77139,60530,78150,77163,91380,91160,77910,78100,77580,95300,60440,91120,60460,78750,60810,95340,95300,91430,78000,78350,78260,60810,91170,78160,95300,60530,78570,77470,77580,60530,91160,77220,78780,91430,77610,78870,95690,95000,78112,91450,60700,91390,91600,95690,77163,77166,60160,77610,91140,77440,77470,95000,78300,91000,91130,78620,60530,60440,77390,91360,77170,77470,60660,77163,95300,77440,78350,78530,78590,91360,95690,91350,60800,91160,60440,91400,60530,91250,60810,78955,95520,60100,77127,60540,60540,60180,91450,77610,78570,77111,91090,91000,95810,60620,60160,60620,78240,77610,91160,95650,77139,95280,77580,77515,77580,60800,60540,60800,91140,60810,77111,95490,78590,77660,77580,60660,60660,60620,77440,78117,60620,60660,60660,78210,91700,77440,91700,78240,91400,60530,60550,91280,60870,91250,78330,60810,77610,95650,77550,77440,60540,95810,95810,91700,78670,78670,77660,91440,77610,78510,91080,91620,77390,60810,95650,77580,78860,91190,60620,60540,91070,95000,77440,77440,60620,91240,77550,78280,77515,60620,78450,95800,78117,60870,91250,78540,91100,60870,60410,77550,77515,60290,60110,60800,78480,91190,78630,91310,60290,60700,60800,91940,91620,77440,77440,77120,60700,77515,91090,77550,95180,95810,95810,91310,91310,77390,77540,60250,60660,91220,91220,77390,77145,95810,60700,78390,77640,60110,60800,77390,95650,95650,60800,78450,77390,77120,91940,60620,78960,60730,60410,60940,60940,78114,78740,78180,60730,91940,91190,60940,91460,95830,60140,77176,60290,91100,60620,60250,60410,77440,60700,78810,77260,77260,60800,95450,78340,60620,78470,77131,95810,60620,60320,91310,60730,95830,60570,60410,78740,77390,78190,60110,60800,77515,77390,78470,77950,60890,95450,77390,60250,78130,78630,60140,91250,91830,77260,95640,95640,60570,60800,60129,60620,77840,60140,95450,91640,77176,77950,77120,60410,60620,91400,60290,91540,91540,77240,77440,77240,78121,60250,60117,77540,95450,60290,91540,60730,91180,77390,77390,78810,60730,60410,78920,78470,77131,60119,78580,77440,78370,77120,91810,77950,78460,77120,78130,60890,77540,77950,78250,95450,60140,60700,77240,60175,60320,60320,77720,95640,91290,77390,60890,60140,95640,60700,77120,60129,60890,77260,95450,78410,91630,60700,77640,60110,60320,91290,77390,78850,91470,60290,91540,91680,78250,78990,91630,60710,91470,78250,60129,60240,95640,77720,91640,60250,60119,60141,91710,77540,60890,91470,77540,95640,95640,60710,77540,78250,77260,91520,91340,60140,60117,77310,77260,95450,91630,02810,91830,77840,60250,77950,60800,77310,78580,60600,91750,78250,60117,60890,60126,60250,91630,77115,78640,78320,78720,60119,78320,77120,60190,78460,77350,60127,60570,60250,60126,60129,77510,60173,77950,91640,91680,77720,60680,95450,78640,77169,78410,95450,78580,77169,78720,77000,77000,77120,91470,77540,60141,78124,60110,60430,77720,91470,60250,78124,60149,91630,91610,77260,60600,60250,91770,60600,95640,95450,77310,77440,78310,60600,60840,60190,60190,91750,77350,60430,60610,60790,78640,95450,78410,77138,78126,91640,60190,77350,78760,78650,78580,77750,95750,60890,60240,78320,60600,60880,78820,78720,60117,77190,02810,91650,77720,60600,95450,77840,78310,60127,60370,77115,78250,91790,95450,77000,91650,78640,60790,60117,78440,78410,78410,02460,77730,60680,60680,02600) 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<>'341748' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  35. 0.0001

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

  36. 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 = 59001 AND W.type_id = 1) OR (W.util_id != 59001 AND W.type_id = 2)) AND (`post_util_id` = 59001 OR `dest_util_id` = 59001) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  37. 0.0001

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

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

  39. 0.0001

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

  40. 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 = 142742 AND W.type_id = 1) OR (W.util_id != 142742 AND W.type_id = 2)) AND (`post_util_id` = 142742 OR `dest_util_id` = 142742) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  41. 0.0001

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

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

  43. 0.0001

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

  44. 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 = 194822 AND W.type_id = 1) OR (W.util_id != 194822 AND W.type_id = 2)) AND (`post_util_id` = 194822 OR `dest_util_id` = 194822) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0001

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

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

  47. 0.0001

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

  48. 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 = 205989 AND W.type_id = 1) OR (W.util_id != 205989 AND W.type_id = 2)) AND (`post_util_id` = 205989 OR `dest_util_id` = 205989) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0001

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

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

  51. 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)

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

  53. 0.0001

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

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

  55. 0.0001

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

  56. 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 = 137196 AND W.type_id = 1) OR (W.util_id != 137196 AND W.type_id = 2)) AND (`post_util_id` = 137196 OR `dest_util_id` = 137196) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

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

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

  59. 0.0001

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

  60. 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 = 62369 AND W.type_id = 1) OR (W.util_id != 62369 AND W.type_id = 2)) AND (`post_util_id` = 62369 OR `dest_util_id` = 62369) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0001

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

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

  63. 0.0001

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

  64. 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 = 85865 AND W.type_id = 1) OR (W.util_id != 85865 AND W.type_id = 2)) AND (`post_util_id` = 85865 OR `dest_util_id` = 85865) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  65. 0.0001

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

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

  67. 0.0001

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

  68. 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 = 143575 AND W.type_id = 1) OR (W.util_id != 143575 AND W.type_id = 2)) AND (`post_util_id` = 143575 OR `dest_util_id` = 143575) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  69. 0.0001

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

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

  71. 0.0001

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

  72. 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 = 138913 AND W.type_id = 1) OR (W.util_id != 138913 AND W.type_id = 2)) AND (`post_util_id` = 138913 OR `dest_util_id` = 138913) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  73. 0.0001

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

  74. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  75. 0.0009

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

  76. 0

    SELECT count(*) as nbwish FROM wish

  77. 0.0489

    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

77 requetes sql en 0.0651

Taille variable Globale : 57.46 KB