Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Service : ouvrir une porte (URGENT)

Autres annonces du voisin

Tout voir
Service repassage
Service repassage

Demande il y a + de 30j

Il y a + de 30j

FAIRE DU REPASSAGE (2H)
Profil du voisin
Priscille A

Vernouillet 78540

32€

Proposer mes services
Service montage de meubles
Service montage de meubles

Demande il y a + de 30j

Il y a + de 30j

MONTAGE DE LIT (3 HEURES)
Profil du voisin
Priscille A

Vernouillet 78540

60€

Proposer mes services
Service montage de meubles
Service montage de meubles

Demande il y a + de 30j

Il y a + de 30j

MONTER UNE CUISINE EN JOUET
Profil du voisin
Priscille A

Vernouillet 78540

20€/h

Proposer mes services
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

SERVICE : éLECTRONIQUE
Profil du voisin
Priscille A

Vernouillet 78540

30€/h

Proposer mes services
Service reparateur electromenager
Service reparateur electromenager

Demande il y a + de 30j

Il y a + de 30j

RéPARATION MACHINE A LAVER
Profil du voisin
Priscille A

Vernouillet 78540

40€/h

Proposer mes services

Annonces similaires

Tout voir
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

OUVERTURE BOITE AUX LETTRES
Profil du voisin
Greg P

Puteaux 92800

-- €

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

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

SIMPLE SERRURE à CHANGER
Profil du voisin
Elisabeth T

Paris 75015

35€/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

CHANGEMENT SERRURE BOITE AUX LETTRES
Profil du voisin
Lilia C

Rambouillet 78120

30€/h

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

OUVRIR UNE PORTE ET CHANGER LA SERRURE
Profil du voisin
Sandy A

Mitry-Mory 77290

35€/h

Proposer mes services
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

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERRURIER PORTE CLAQUéE URGENT
Profil du voisin
Myroam T

Paris 75016

100€/h

Proposer mes services
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

-- €

Proposer mes services
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

SERRURIER : OUVRIR MA BOîTE AUX LETTRES
Profil du voisin
Alison K

Brétigny-sur-Orge 91220

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

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

  7. 0.0001

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

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

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

  21. 0.0001

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

  22. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 345943

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

  25. 0.0001

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

  26. 0.0001

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

  27. 0

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

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

  36. 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='600' LIMIT 0,1

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

  38. 0.0002

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

  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='600' LIMIT 0,1

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

  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='583' LIMIT 0,1

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

  44. 0.0002

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

  45. 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='1165' LIMIT 0,1

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

  47. 0.0002

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

  48. 0.0001

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

  49. 0.0068

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.98333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.2983839280719 AND ville_longitude_deg<2.6682760719281 HAVING distance <= 50 ORDER BY distance ASC

  50. 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 (78540,78480,78510,78670,78670,78130,78570,78955,78920,78630,78630,95180,78740,95000,78740,78410,78260,78130,78300,78570,95280,78250,78780,78250,78580,95800,95450,78240,78250,95000,95490,78240,78250,78410,78700,78580,78250,95450,95650,95000,78410,78121,95610,78820,78580,78100,78126,78600,78112,78410,78410,78810,78580,95450,78124,78230,78810,95450,95650,78750,78250,78110,78680,78600,95300,78124,95520,78620,78440,95450,78450,95650,95650,78860,78160,78970,78360,78440,95310,78560,95450,78850,95220,78440,95450,95300,95450,95650,78440,78590,95480,95530,95370,78500,78430,95450,78870,78450,78440,78440,78770,78400,95450,78650,78590,78290,78380,78440,78580,78420,78440,95240,78640,78930,78440,78770,78340,95830,95250,78930,78800,95830,78370,95450,95450,95300,95450,78330,95430,78770,95870,92000,95450,95810,78150,78640,78170,78640,78440,78520,78770,95510,95130,92500,78770,95420,95300,78650,78440,95150,95550,95130,78930,78770,95640,95640,78390,78640,78150,95640,95810,78770,95540,95740,78200,78711,95110,78210,78200,78930,95100,78790,78790,78930,78490,92380,78520,95320,92700,95510,95640,92430,92420,78190,95430,95630,95640,78990,95120,95420,95420,92250,95420,95450,95810,78930,78930,92400,95810,78760,95510,95840,92800,92150,78490,95390,92270,78000,95840,78790,95750,95760,78200,95210,95218,92410,78520,92210,95810,78490,95420,95690,95600,95640,95640,78910,78910,95750,78180,95680,78790,78490,78490,95560,92200,78310,78490,78220,92600,92310,78280,78790,92300,78200,78200,95230,95580,95580,92230,95780,95510,78910,95420,95690,78140,95690,78490,78490,78200,93800,95620,78890,60240,78320,95420,78790,92110,78200,95880,95690,78940,92370,78200,78200,92100,95640,78910,78310,78960,78200,95290,78350,78530,60240,95810,95570,95420,95420,60240,78690,95510,95590,78910,95810,95170,78840,95560,95420,78710,95160,78490,92190,92360,92390,93450,60240,78350,78320,78117,78270,78940,60119,78790,78470,78520,78200,93430,60240,60119,78470,60240,78910,95780,78490,78270,95330,92130,78790,93400,78114,95560,95360,95410,95420,95660,78980,95570,95420,78270,78117,95350,92170,95710,95560,93200,93210,60110,95260,78111,60240,92140,78910,78320,60119,93380,95340,60240,78200,95350,95570,95510,78690,95590,92240,95780,95260,92320,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95460,78910,95710,95340,60240,92350,60240,78200,91400,78720,93240,95400,95200,78840,91190,27630,78550,91570,60230,92120,95590,78550,92220,78720,95440,78980,93120,93300,60173,91190,92260,92330,60240,78460,78270,95420,78490,92290,91430,60175,78610,78470,94250,95710,95270,78790,27620,78270,95570,60110,60540,60540,91430,78610,78790,78270,93500,60240,78720,60240,95270,60240,60110,94110,78460,95140,78980,95400,60240,93440,78550,95720,91370,93310,93350,91470,27620,95270,60540,60240,78910,78610,95340,78610,78950,95720,92340,78270,95720,78980,95270,95770,60530,91440,78550,94270,60110,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,95500,78980,27630,95820,60240,78980,91400,60530,60540,78270,95720,60240,27630,91940,91190,78720,60240,78270,78113,92160,95270,60790,93170,60240,27630,94800,94200,94205,28260,60240,60240,27630,60149,95770,95770,91470,91120,78125,91300,78270,95500,60240,95270,93260,93230,60240,60540,60570,28560,28260,78270,94260,93700,93150,91940,28260,27620,95270,95850,78550,27420,60530,93100,28410,91400,60820,78113,78550,94550,93000,94160,60240,60240,95190,78980,60240,27640,28560,27720,60530,94300,60530,95500,60240,91140,60790,91470,95190,95270,28260,94220,95190,78125,91940,91470,94150,27630,93140,91160,60110,60570,95850,91140,91320,93130,27630,78270,94400,95500,94140,94320,27620,95270,60590,27630,78120,78270,60530,78113,60240,60240,95270,95270,78720,60240,60240,91640,60790,60240,60530,78270,91380,91160,27720,28260,27420,91160,28410,94700,60240,60730,27120,60730,60790,27140,27420,60460,28410,95380,93110,95270,27870,60590,60790,95380,94410,60730,27510,60260,78113,60590,60430,27200,28410,28410,94600,94120,94310,94390,27540,93250,78830,93600,60570,94340,28260,78830,95700,27730,91420,27120,60460,95470,28260,94130,91550,60590,27830,93320,93340,91620,27510,60270,78120,60790,91470,95670,78125,28410,28260,94170,91160,78113,91640,27640,93420,78125,93270,27510,27420,93360,27780,27510,60580,28410,60240,60390,91640,27120,94000,78113,91620,94290,60340,95380,93220,91200,78125,78125,91360,91460,27120,60730,27120,27730,27420,60590,27950,27510,94360,93190,93390,28410,60730,60590,91640,27140,95380,27510,60340,91360,27420,94100,94210,94340,91700,94480,28260,93330,27950,95380,27660,27660,94500,91310,91310,60430,28210,91680,27640,27120,78730,78730,60390,27150,27150,60250,27730,93410,60390,27950,94460,28410,94380,91390,91600,27530,60390,94190,78125,28210,91260,60590,60390,60560,91470,91310,94430,60390,27750,93370,78120,27510,93290,28260,27950,28210,91270,60590,60660,60660,91310,60430,91240,60660,60500,91530,91680,28500,95470,60740,27120,27950,95470,94350,91560,93460,28500,27120,60520,77181,93470,27510,60660,60660,28210,60590,60430,78125,91170,77990,95470,60390,93160,27420,60390,78730,91410,27700,28230,78125,91210,60500,94450,91530,27940,60250,27220,91700,27150,78125,28570,27140,60250,28210,91180,91230,27120,77990,27220,60590,60430,60160,60430,27120,27950,27220,27150,27920,27920,28230,94420,91350,60250,94470,91520,91340,91220,91220,94370,94380,77500,60520,27220,60430,27950,60128,94490,94880,94880,27120,77290,27120,77230,78125,77270,27220,91650,91700,60390,77181,78730,27420,60160,27700,27120,27860,27150,91650,27220,27940,60000,91290,28500,77420,91330,91650,27120,77230,27600,60250,27150,28130,60250,91530,28210,28210,91000,91130,91290,27120,28520,28520,28130,27220,27220,60300,60300,28210,27150,60660,27950,60128,77230,60370,28500,91800,27150,27700,60390,28210,28210,60520,60650,60155,91410,91410,94510,77177,60250,60180,60370,60590,91630,78730,77185,28210,27120,27220,91070,60850,91530,27710,27120,60300,28500,27420,94440,94440,60134,77410,28500,91450,91630,60000,77340,27810,77184,77186,27120,27150,60134,27150,60100,91790,60430,28130,91080,27120,27150,60370,60250,27600,27950,91580,27150,27140,60590,28320,77410,28500,28500,77360,77290) 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<>'345943' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  54. 0.0002

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

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

  58. 0.0002

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

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

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

  66. 0.0002

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

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

  70. 0.0001

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

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

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

  78. 0.0001

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

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

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

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

  82. 0.0002

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

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

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

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

  86. 0.0001

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

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

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

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

  90. 0.0001

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

  91. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  92. 0.0009

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

  93. 0

    SELECT count(*) as nbwish FROM wish

  94. 0.0603

    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

94 requetes sql en 0.0813

Taille variable Globale : 57.98 KB