Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche : serrurier

Autres annonces du voisin

Tout voir
Service pose de cuisine
Service pose de cuisine

Demande il y a + de 30j

Il y a + de 30j

SERVICE : POSE CUISINE
Profil du voisin
Kadia M

Louvres 95380

15€/h

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€

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€

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

-- €

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

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

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

PROBLèME SERURIER
Profil du voisin
Taieb A

Limeil-Brévannes 94450

25€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : RéPARATION SERRURE
Profil du voisin
Marie S

Acheres 78260

20€/h

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

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

INSTALLATION SERRURE
Profil du voisin
Hamza B

Gentilly 94250

20€

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

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

  7. 0.0001

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

  9. 0.0001

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

  10. 0.0002

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

  11. 0.0002

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

  12. 0.0002

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

  13. 0.0002

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

  14. 0.0002

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

  15. 0.0002

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

  16. 0.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.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 = 365126

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

  25. 0.0001

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

  27. 0

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

  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='176296' AND wish_id<>'365126' 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='604' 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=176296 AND note_visu IN (1,3,4)

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

  36. 0.0001

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

  37. 0.0062

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.53333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.600339197041 AND ville_latitude_deg<49.499660802959 AND ville_longitude_deg>1.8472370769771 AND ville_longitude_deg<3.2194229230229 HAVING distance <= 50 ORDER BY distance ASC

  38. 0.003

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

  42. 0.0001

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

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

  46. 0.0001

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

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

  50. 0.0001

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

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

  54. 0.0001

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

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

  58. 0.0001

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

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

  62. 0.0002

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

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

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

  70. 0.0002

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

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

  78. 0.0001

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

  79. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  80. 0.0009

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

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

Taille variable Globale : 57.96 KB