Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Besoin d'un serrurier

Retour Service Serrurier Service serrurier entre particuliers (77) Service serrurier entre particuliers (77)

Discuter

Ce voisin demande ce service à Montry (77450)

100€/h

Prix

100€/h

Description de l'annonce

Je cherche un serrurier pour un changement de système.
serrure 2 points sur porte vitrée
J'ai mis un montant à titre indicatif je souhaite un devis et de l'aide pour l'achat de la serrure.
#serrurier

Autres annonces du voisin

Tout voir
Location debroussailleuse
Location debroussailleuse

Demande il y a + de 30j

Il y a + de 30j

LOCATION DéBROUSSAILLEUSE
Profil du voisin
Lea B

Montry 77450

35€/j

Annonces similaires

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

-- €

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

METTRE UNE SERRURE SUR LA PORTE
Profil du voisin
Souibira L

Paris 75016

15€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERRURIER : OUVERTURE DE PORTE
Profil du voisin
Voisin #111360

Paris 75007

50€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : OUVRIR UNE PORTE
Profil du voisin
Aly T

Villejuif 94800

20€

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€

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

TROUVER UN SERRURIER
Profil du voisin
Voisin #49491

Rueil-Malmaison 92500

30€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

REMPLACEMENT SERRURE PORTE D'ENTRéE
Profil du voisin
Aminata T

Crosne 91560

45€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERRURE éLECTRIQUE SUR PORTAIL EXTéRIE
Profil du voisin
Louis M

Champlan 91160

40€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

APPEL D'OFFRE SUR 10 PORTES BLINDéES
Profil du voisin
Juste Y

Aulnay-sous-Bois 93600

-- €

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

-- €

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

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

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

  7. 0.0001

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

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

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

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

  25. 0.0001

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

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 300296 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 = 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

  29. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='300296' 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 = '630983'

  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='300296' AND wish_id<>'630983' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  32. 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='2' LIMIT 0,1

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

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

  35. 0.0002

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

  36. 0.0001

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

  37. 0.0056

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.83333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>2.1490697807905 AND ville_longitude_deg<3.5175902192095 HAVING distance <= 50 ORDER BY distance ASC

  38. 0.0025

    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 (77450,77450,77450,77450,77700,77100,77450,77860,77410,77860,77450,77100,77124,77450,77860,77450,77410,77100,77580,77700,77700,77144,77124,77580,77470,77410,77580,77580,77580,77410,77124,77400,77144,77410,77124,77700,77580,77410,77470,77400,77580,77470,77470,77400,77700,77600,77470,77580,77165,77165,77400,77410,77165,77910,77600,77470,77600,77163,77174,77122,77410,77400,77174,77470,77400,77910,77910,77165,77410,77600,77600,77400,77910,77580,77165,77600,77230,77163,77410,77580,77410,77230,77139,77230,77660,77230,77164,77440,77360,77580,77515,77580,77165,77165,77139,77177,77290,77440,77090,77183,77200,77230,77660,77181,77270,77163,77230,77135,77440,77120,77186,77230,77610,77178,77178,77139,77220,77640,77515,77500,77290,77440,77139,77515,93470,77181,77440,77440,77440,77440,77185,77120,77230,77420,77260,77260,77680,60440,77610,77230,77230,77610,93290,77515,77184,60330,77230,93410,77260,93370,93460,77990,60440,77610,60330,77440,77330,93390,93190,77515,77120,93160,77139,60330,60330,77220,77340,77440,77120,77280,77220,77230,77540,93270,77640,60620,77145,60620,77120,77260,93220,60440,77990,77440,94420,77610,60620,93420,94350,77220,60950,77131,93330,93320,93340,60620,93600,94510,77260,77510,93360,77230,77610,60440,77610,77260,77169,77120,77131,95380,77440,77220,77169,93250,60950,60620,95700,94360,77150,77840,77173,95380,94170,94880,94490,77120,94880,77750,95470,60620,94500,60890,77150,60950,77120,77138,93110,77260,95380,94430,77540,94120,60620,77390,93140,77750,95470,93130,95500,94130,60620,77840,77730,60128,60620,95380,94380,77440,94370,60440,94340,94100,94210,77540,77390,60440,77540,60440,77169,60128,60890,93150,93700,93000,60620,95500,77730,77120,77540,77166,60300,77170,77730,95500,02310,95190,95470,94340,94440,77750,77750,77170,93260,93230,60890,77840,77510,02810,94440,94410,94470,95500,77390,93100,77169,60440,60300,60300,77120,77390,77390,77510,94300,77170,93350,95380,02310,94380,95670,94000,93440,77510,02810,77540,77111,77730,95140,93170,60620,95720,02310,94440,95400,77390,60890,60890,60800,77390,60620,77390,77540,77111,95190,60520,77750,93500,77141,94520,94520,94160,77510,93310,77390,77720,94700,60300,60800,77320,94220,77166,60520,95190,02810,60890,94460,77320,02810,95470,94450,02310,93120,93300,77750,60620,91330,77320,95720,02310,93240,94140,60520,91480,77510,60560,60800,60800,02810,95850,95850,95270,02310,60800,77320,60890,77380,91800,95400,95200,77390,02310,60141,77320,77370,91800,60117,93380,95270,95270,02460,02310,95440,94190,60300,94205,94200,60810,93210,94600,93200,91860,77970,02310,95720,94400,02810,77550,60141,77390,60800,95350,77510,77720,91480,77970,60810,77550,60800,95270,02810,02810,95360,02310,95720,77390,91560,94270,60810,02400,95410,77320,77510,93430,75010,75004,75011,75006,75016,75017,75012,75013,75005,75014,75116,75020,75015,75008,75007,75001,75002,75019,75018,75003,75009,75000,60300,95460,94800,77720,93450,92390,93400,02810,95270,02810,94290,94310,94390,60117,60300,94320,77370,91230,95350,60800,77720,77320,77390,02310,02470,60580,95170,77970,77550,02810,95270,60810,95160,95270,77320,77320,77127,94480,02400,60117,02470,95880,77510,94250,77970,95570,77720,60117,60300,60300,77950,93800,02470,02600,77550,02810,95270,95330,91200,95570,94110,02400,77320,91270,60129,60800,77720,60800,77720,92230,92110,60260,77950,02460,77115,94550,77970,02460,95570,77510,92120,94239,94233,94234,94235,94236,94237,94238,94232,94231,94230,94240,60800,77720,02570,95230,02400,02400,02470,77320,60810,91250,02600,02470,94150,95580,02400,95580,92600,91210,92170,92300,77370,02470,02570,60300,60810,77950,60500,77320,95210,95218,92240,77320,95270,02470,60117,91550,77950,77560,60129,77370,91450,02400,60129,60320,92340,77320,02400,77720,92220,95600,60127,95560,77720,60700,02600,60500,91280,91450,92270,77950,02540,60810,92200,95570,95680,77370,02400,95270,02470,91320,77176,77370,77950,91260,02600,95560,95120,77240,02470,91250,60300,02600,94260,60410,91090,91000,92320,95560,02600,60270,77240,92400,60123,91000,91130,77370,92700,60320,60320,92250,95270,77820,95100,60129,95390,77160,02400,02400,91250,60410,92260,92330,92130,02570,95110,77176,77115,77370,91170,77560,92160,60127,60410,60123,92140,60740,02600,91100,92100,02600,95270,02600,60410,02210,02210,91420,77320,02400,95560,60410,95320,02400,92350,95590,92150,92800,02210,77370,91350,77370,77000,77000,95130,77320,02400,60320,02600,60700,92290,95130,95590,77320,60820,92360,92190,91600,91390,77560,02540,95840,60410,77350,77160,95870,60340,91300,77320,02540,77370,02540,02540,02540,91370,77370,77560,02400,02400,02210,95590,77240,77000,92210,77320,77560,60700,91160,91380,60340,91250,91830,91360,77160,91080,02400,77370,02400,78800,92000,60700,02210,77820,60460,02600,77820,02600,92500,91700,60100,91100,77160,91090,02540,95260,02600,02210,95820,60550,95240,02600,02400,95150,95550,95840,77310,91070,77320,91360,77190,02210,60160,60180,77350,77320,60870,95740,78420,02540,95250,77310,60700,78500,02210,92310,02540,02210,95340,95530,95260,02600,02600,02600,77000,02210,91160,92410,95370,60870,77320,92370,51210,77350,51310,91120,77160,92380,91700,60610,77560,77590,60870,02600,02400,60350,77310,77520,60160,60460,60660,60126,91540,91540,95340,51310,91570,77160,95660,60126,02210,91160,91160,60940,92420,92430,91140,51210,91700,95290,02210,95540,77590,78140,51210,02400,60350,60710,02600,77160,91430,95220,02330,02600,77560,02650,77650,91830,95630,95430,60530,02210,95480,78360,60710,60350) 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<>'630983' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  42. 0.0001

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

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

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

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

  54. 0.0001

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

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

  58. 0.0001

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

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

  62. 0.0001

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

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

  66. 0.0001

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

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

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

  74. 0.0001

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

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

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

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

  78. 0.0001

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

  79. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  80. 0.0008

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

  81. 0

    SELECT count(*) as nbwish FROM wish

  82. 0.0469

    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

82 requetes sql en 0.064

Taille variable Globale : 57.98 KB