Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Clé cassée dans la serrure (URGENT)

Annonces similaires

Tout voir
Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

OUVERTURE D'UNE PORTE SIMPLE
Profil du voisin
Edwige A

Élancourt 78990

40€/h

Service serrurier
Service serrurier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SERRURIER (CHANGER BARILLET)
Profil du voisin
Antar A

Antony 92160

-- €

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

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

SERVICE : SERRURIER
Profil du voisin
Marlene D

Pierrefitte-sur-Seine 93380

40€/h

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

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

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

POSE D'UNE SERRURE à CLEF SUR PETIT MEU
Profil du voisin
Chantal K

Beauvais 60000

20€

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

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

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

  7. 0.0001

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

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

  23. 0.0001

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

  25. 0.0001

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

  27. 0

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

  29. 0.0001

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

  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='142742' AND wish_id<>'339001' 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='78510'

  33. 0.0083

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.3148258054235 AND ville_longitude_deg<2.6851741945765 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0029

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

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

  42. 0.0002

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

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

  46. 0.0002

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

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

  50. 0.0001

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

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

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

  58. 0.0002

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

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

  62. 0.0001

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

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

  66. 0.0001

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

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

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

  74. 0.0001

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

  75. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1071

  76. 0.001

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

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

Taille variable Globale : 57.48 KB