Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche un menuisier (changer serrure)

Annonces similaires

Tout voir
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

CHERCHE SERRURIER
Profil du voisin
Perpétue M
5.0

Grigny 91350

35€/h

Proposer mes services
5.0
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

PORTE D'ENTRéE BLOQUéE
Profil du voisin
Asitan D

Creteil 94000

-- €

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : CHANGEMENT DE SERRURE
Profil du voisin
Nadia B

Puteaux 92800

-- €

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UN SERRURIER
Profil du voisin
Chantal C

Franconville 95130

40€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

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

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

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

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

REMPLACEMENT SERRURE PORTE BLINDéE
Profil du voisin
Anne-marie R

Paris 75019

35€/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='388775'

  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

    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='13168' 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` = 13168

  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.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 = 388775

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

  25. 0.0001

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

  27. 0

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

  28. 0.0002

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 13168 AND W.type_id = 1) OR (W.util_id != 13168 AND W.type_id = 2)) AND (`post_util_id` = 13168 OR `dest_util_id` = 13168) 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='13168' 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 = '388775'

  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='13168' AND wish_id<>'388775' 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='93130'

  33. 0.0069

    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.46667- 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.7828668758251 AND ville_longitude_deg<3.1504731241749 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0027

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

  38. 0.0001

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

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

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

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

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

  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=59001 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 = 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

  58. 0.0001

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

  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=194822 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 = 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

  62. 0.0001

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

  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=192349 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 = 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

  66. 0.0001

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

  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=113924 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 = 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

  70. 0.0001

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

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

  74. 0.0002

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

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

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

Taille variable Globale : 57.51 KB