Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Service : Couverture

Autres annonces du voisin

Tout voir
Location avec chauffeur
Location : avec chauffeur

Clichy-sous-B... 93390

Service vtc
Profil du voisin
Mo

Clichy-sous-Bois 93390

50€/jr

Louer avec chauffeur

Annonces similaires

Tout voir
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 77131

Poteau en bois à  changer par ipn
Profil du voisin
Lanfranco A

Touquin 77131

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 75012

Toiture terrasse (8h)
Profil du voisin
Monzon D

Paris 75012

200€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 77540

Fuite solin béton (2h)
Profil du voisin
Voisin #113749

Rozay-en-Brie 77540

50€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 95100

Service : toiture à changer
Profil du voisin
David L

Argenteuil 95100

6000€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 92500

Tubage de cheminée (8h)
Profil du voisin
Patrick M

Rueil-Malmaison 92500

240€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 78750

Pose d'un velux
Profil du voisin
Vincent V

Mareil-Marly 78750

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 92800

Remplacer couverture en tuile plate
Profil du voisin
Edgard L

Puteaux 92800

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 60260

Installer : chapeau de cheminée inox
Profil du voisin
Alain D

Lamorlaye 60260

25€/h

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 91380

Poser du carrelage et du parquet (10h)
Profil du voisin
Youssef A

Chilly-Mazarin 91380

350€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 77470

Service : replacer tuiles
Profil du voisin
Laurent C

Villemareuil 77470

-- €

Proposer mes services

Demande un service de couvreur entre voisins ou proposer mes services de couvreur.

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='charpentier' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='603'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'charpentier' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='50'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

  7. 0.0001

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

  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.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 (38) ORDER BY ssrubr_order ASC

  13. 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 (45) ORDER BY ssrubr_order ASC

  14. 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 (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.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 (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.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 = 641012

  23. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='641012'

  24. 0.0001

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

  25. 0

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

  26. 0

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

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

  28. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='135144' AND note_visu IN (1,3,4)

  29. 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 = '641012'

  30. 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='135144' AND wish_id<>'641012' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  31. 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='868' LIMIT 0,1

  32. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=135144 AND note_visu IN (1,3,4)

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

  34. 0.0001

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

  35. 0.0001

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

  36. 0.0062

    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.55- 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>1.8657397807905 AND ville_longitude_deg<3.2342602192095 HAVING distance <= 50 ORDER BY distance ASC

  37. 0.0028

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

  38. 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='603' LIMIT 0,1

  39. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37491 AND note_visu IN (1,3,4)

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

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

  43. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=163368 AND note_visu IN (1,3,4)

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

  45. 0.0001

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

  46. 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='603' LIMIT 0,1

  47. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=113749 AND note_visu IN (1,3,4)

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

  49. 0.0001

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

  50. 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='603' LIMIT 0,1

  51. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=401804 AND note_visu IN (1,3,4)

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

  53. 0.0001

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

  54. 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='603' LIMIT 0,1

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=200097 AND note_visu IN (1,3,4)

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

  57. 0.0001

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

  58. 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='603' LIMIT 0,1

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=76713 AND note_visu IN (1,3,4)

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

  61. 0.0001

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

  62. 0

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

  63. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=17338 AND note_visu IN (1,3,4)

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

  65. 0.0001

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

  66. 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='603' LIMIT 0,1

  67. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=112282 AND note_visu IN (1,3,4)

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

  69. 0.0001

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

  70. 0

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

  71. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111167 AND note_visu IN (1,3,4)

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

  73. 0.0001

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

  74. 0

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

  75. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78336 AND note_visu IN (1,3,4)

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

  77. 0.0001

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

  78. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  79. 0.0008

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

  80. 0

    SELECT count(*) as nbwish FROM wish

  81. 0.0516

    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

81 requetes sql en 0.0683

Taille variable Globale : 57.93 KB