Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Tubage de cheminée (8h)

Autres annonces du voisin

Tout voir
Service plomberie
Service plomberie

Demande il y a + de 30j

Il y a + de 30j

RACCORDER UNE FONTAINE DE JARDIN
Profil du voisin
Patrick M

Rueil-Malmaison 92500

60€/h

Proposer mes services

Annonces similaires

Tout voir
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

POSE CHAPEAU VMC ET CHAPEAU CHEMINéE (3
Profil du voisin
Fabrice M
100% fiable

Roissy-en-France 95700

90€

Proposer mes services
100%
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

COUVREUR ZINGUEUR, REFAIRE NOEUD TOITURE
Profil du voisin
Peres M

Morangis 91420

30€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

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

RECHERCHE UN CHARPENTIER/COUVREUR
Profil du voisin
Voisin #105113

Mitry-Mory 77290

25€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : COUVERTURE
Profil du voisin
Humberto R

Croissy-Beaubourg 77183

130€/j

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

BESOIN D'UN COUVREUR POUR POSE DE TUILES
Profil du voisin
Voisin #125738

Verneuil-sur-Seine 78480

150€

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : COUVERTURE
Profil du voisin
Mo

Clichy-sous-Bois 93390

35€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

CHARPENTIER POUR RéPARER UNE TUILE
Profil du voisin
Samia B

Étampes 91150

15€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

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

FERMER LE CHAPEAU D'UNE CHEMINéE
Profil du voisin
Voisin #54731

Mureaux 78130

25€/h

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

  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, 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='92'

  7. 0.0001

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

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

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

  22. 0.0001

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

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=603 LIMIT 1

  24. 0.0001

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

  25. 0.0001

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

  27. 0

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

  29. 0.0001

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

  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='200097' AND wish_id<>'382400' 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='602' 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=200097 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 = 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

  35. 0.0002

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

  36. 0.0001

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

  37. 0.0084

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.5161968758251 AND ville_longitude_deg<2.8838031241749 HAVING distance <= 50 ORDER BY distance ASC

  38. 0.0041

    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 (92500,92000,92800,92150,78400,78800,78420,92250,92400,92380,92210,92200,78170,78360,78290,78380,92700,95870,92430,92420,78560,92270,78110,78430,92300,92410,92100,92600,92310,78500,78230,92110,78600,78150,78600,95100,78150,78750,78160,78100,92130,92190,92360,92230,92170,92370,78870,78140,95530,78220,78112,78620,93400,95110,92240,78590,78000,92140,93800,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,92320,95210,95218,95240,95370,92390,93450,92120,95130,92220,92350,95120,94250,78300,78590,78240,95880,92260,92330,93200,93210,78350,95220,95130,78330,93430,78700,95230,78260,78210,94110,78240,78350,78530,92290,78860,93120,93300,78955,94270,95600,95360,78450,93310,93500,92340,78570,95170,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,95250,91570,95580,95580,95480,95320,93380,93240,94800,94200,94205,91370,95410,95390,93170,78117,95680,78780,95160,78280,78450,78630,78390,78670,78670,78570,92160,95610,91430,91430,95150,95550,93350,94160,91400,94550,93260,93230,94260,78810,93100,94300,93440,78340,94220,95000,91300,95350,78180,78117,78540,95140,78510,94140,93000,78190,94400,95350,78960,94150,95740,95400,95200,94320,91120,95840,93700,93150,91190,95560,95280,95000,95330,78114,91320,78480,95400,95500,94700,78121,91190,93130,95310,93140,78810,78370,95300,95570,78470,95440,78630,94410,95540,91400,94600,91440,95430,95840,95460,95490,91140,93110,95000,94310,94390,94340,95570,91160,78580,78850,94120,95500,78470,78990,94130,95570,78130,91380,91160,95560,95300,95180,93250,78920,78470,95560,95800,91550,95430,95630,94170,91140,94000,91940,78740,95520,95720,91420,78640,91940,91190,91160,95650,95720,94290,95590,78460,78640,78580,93320,93340,93360,95500,78740,78320,95720,91200,95650,78410,95560,94360,94100,94210,94340,78320,95760,91940,95650,93600,78640,94500,78124,93220,94480,78130,95500,78124,78310,94380,95190,94460,95300,78760,78650,93330,95450,94190,91470,91160,91400,94430,78580,93270,95720,78720,95300,95570,78720,78250,78250,78310,78640,91360,91270,78580,93190,93390,95270,78460,91260,95620,91360,91470,95190,95450,78320,91560,78410,91620,93420,95290,78126,91640,94350,91620,78250,95270,91390,91600,95700,95850,95650,95650,94450,78250,78490,93370,93460,91700,95590,93160,78410,95450,95270,91470,78720,91210,95190,93410,78650,91230,78250,78690,94470,95380,91170,94370,94380,95810,78410,78410,95690,78490,94420,91460,78490,78490,94490,94880,94880,78770,95690,95660,78770,91470,95450,91310,91310,95260,77181,93470,95810,95260,91310,78770,78820,93290,78690,91330,95590,91240,95850,78680,95380,95830,91350,77500,78770,95270,91700,77420,78770,95450,95450,78720,95450,95690,95270,95830,91310,91640,95270,95810,95690,91800,95340,78490,78490,94510,78490,95270,95270,91640,95270,91700,95270,91000,91130,78250,95380,78770,91470,95810,94440,95380,94440,78970,78490,77181,78580,78490,91220,91220,78440,78610,77270,95270,77185,95270,77340,95450,95670,95810,77184,91680,95340,78440,95380,77177,78770,91180,91680,60230,95450,95470,91450,78930,77186,78830,91640,91860,78930,78440,95340,77290,95450,95640,91070,78440,77990,94440,95820,78610,94520,94520,77990,77360,95450,78440,91800,78940,78830,91080,78440,77410,77200,95450,95640,95640,78720,91090,91000,60820,91520,91340,91290,95640,78125,78490,78440,77170,95470,91290,78890,78440,60530,91530,95450,91450,95810,78790,78790,60260,77680,95450,91480,78910,78930,77090,77183,78910,78440,95640,78610,95640,95810,91470,77150,95470,91480,95640,95470,91650,60540,60540,95640,91090,91650,77410,77400,78790,78940,77400,78910,91630,91250,60580,91630,60530,77600,77230,77230,60110,77230,77150,78520,60530,91630,95420,77380,78930,60560,91650,91250,91630,60240,77290,78200,78711,77330,91530,77400,78930,95510,78440,78610,77600,77600,78440,60119,60270,91280,60128,60520,78120,78730,78730,78930,78930,78910,78200,95750,60540,91790,60110,60540,77230,78490,60460,91810,91410,77410,78120,91630,60530,77164,91530,95750,60119,77410,91100,77135,95420,95450,77170,77400,77400,78790,77127,77400,78910,77410,78790,77600,60530,91100,91540,77410,78910,78520,91250,95510,77230,77230,95420,95420,78200,77173,60540,91910,91730,91730,77400,91710,78790,60128,60530,91580,60520,91540,91540,78200,60110,77410,60119,60460,95420,77600,60530,78200,95510,78125,60175,60340,77230,91530,91540,60240,78550,77230,78520,91770,78790,60240,60500,77144,78730,60240,60340,78200,77230,95420,60240,78200,77600,78120,77166,60520,60173,91730,77166,91410,60500,60570,78200,91510,91510,78950,91410,95420,91580,78200,60740,78550,60110,91850,77144,77700,78790,78910,91250,91830,77450,77230,78200,77280,77550,95510,78113,95780,60240,60240,91760,91610,78125,77410,95420,77220,78113,91750,91580,60570,77450,78111,91580,60730,78910,60950,60330,60240,60300,60300,77700,78200,77176,77230,77410,78980,95420,78730,60730,78730,77230,77410,60660,95420,77165,78710,78125,78550,60149,95510,77170,77550,77111,77700,78840,77165,78520,91590,77410,60240,91830,60240,60240,60160,78270,78550,60790,60660,60660,60240,77220,78113,77450,78200,60730,77174,77165,77165,91580,78270,95420,77220,78550,60240,60660,60660,91410,91750,77220,95780,60730,95420,60300,60240,77176,60110,77240,78790,78270,77450,77700,78980,60300,78125,78910,77550,78125,60250,78550,77230,77450,77700,78125,78790,60240,95710,60790,91590,77240,60950,60330,60160,77111,78200,77390,78125,78660,91410,77550,60300,77220,77450,77450,91410,77310,77450,91580,60570,60730,78113,60430,77240,91590,60790,60240,95510,60180,77165,28410,77174,78125,95780,95710,91590,91870,91590,60300,60300,60300,60790,77310,60250,78113,60100,60240,28410,77860,78980,78840,77580,91590,60790,60240,60300,95420,28560,28260,27630,77950,78125,77124,60330,60300,60240,60950,91750,78270,60240,60240,28230,78125,28410,77610,91150,77178,28230,91150,78113,60240,78660,60660,77122,91590,91410,60240,60790,77860,78980,28260,95710,77310,28560,60250,60240,60240,77390,60870,77100,78980,77390,77950,27620,78270,78270,91590,77100,77124,78980,77610,28410,91890,60250,77178,78660,60240,60700,91150,77350,77610,77950,60290,77124,78660,77950,60330,77390,77860) 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='603' AND wish_id<>'382400' 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='603' 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=80512 AND note_visu IN (1,3,4)

  41. 0.0003

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 80512 AND W.type_id = 1) OR (W.util_id != 80512 AND W.type_id = 2)) AND (`post_util_id` = 80512 OR `dest_util_id` = 80512) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0003

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

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

  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='603' 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=111167 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 = 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

  50. 0.0002

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

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

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

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

  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='603' 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=135144 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 = 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

  66. 0.0002

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

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

  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='603' 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=112282 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 = 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

  74. 0.0002

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

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

  78. 0.0002

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

  79. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  80. 0.0017

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

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

Taille variable Globale : 57.98 KB