Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Service : Tuiles à remplacer

Annonces similaires

Tout voir
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

CHERCHE UN COUVREUR POUR TOIT
Profil du voisin
Stephane A

Cercottes 45520

10€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : REMETTRE TUILES
Profil du voisin
Catherine E

Huisseau-sur-Mauves 45130

35€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : RéNOVATION TOITURE
Profil du voisin
Alban R

Mittainville 78125

250€/j

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

POSE D UN FILM ANTI CHALEUR
Profil du voisin
Sabrina D

Gambais 78950

35€/h

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

REMPLACEMENT DE VELUX
Profil du voisin
Jocelyne C

Ablis 78660

150€/j

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RéPARER TOIT ABRI DE JARDIN (4H)
Profil du voisin
Eric L

Ingre 45140

100€

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

DéPLACEMENT DE VELUX (3H)
Profil du voisin
Ghyslain B

Saint-Jean-de-la-Ruelle 45140

150€

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COUVREUR CHARPENTIER
Profil du voisin
Ludivine L

Thiron-Gardais 28480

-- €

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

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

  7. 0.0001

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

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

  23. 0.0001

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

  25. 0.0001

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

  27. 0

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

  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='25356' AND wish_id<>'498359' 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='28360'

  33. 0.004

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.35*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.35*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.900339197041 AND ville_latitude_deg<48.799660802959 AND ville_longitude_deg>0.82338257380487 AND ville_longitude_deg<2.1766174261951 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0024

    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 (28360,28630,28630,28630,28630,28630,28630,28150,28360,28630,28360,28150,28600,28630,28360,28360,28630,28630,28120,28140,28120,28150,28360,28110,28360,28150,28360,28630,28120,28120,28630,28000,28300,28150,28190,28120,28120,28120,28150,28800,28150,28120,28300,28300,28800,28300,28300,28150,28700,28150,28700,28300,28150,28150,28800,28120,28700,28800,28120,28300,28300,28800,28190,28120,28300,28800,28300,28300,28800,28700,28120,28800,28700,28190,28150,28150,28700,28150,28120,28800,28190,28700,28190,28700,28120,28300,28800,28120,28300,28130,28120,28700,28150,28800,28160,28800,28190,28800,28300,28150,28120,28190,28700,28190,28700,28150,28190,28150,28150,28120,28300,28190,28150,28800,28800,28130,28160,28700,28190,28300,28120,28190,28130,28800,28700,28160,28320,28120,28130,28140,28700,28190,28320,28140,28130,28300,28700,28240,28130,28800,28120,28310,28700,28700,28800,28700,28700,28320,28310,28140,28310,28140,28130,28190,28190,28120,28240,28160,28140,28200,28700,28200,28700,28130,28140,28700,28320,28700,28200,28240,28310,28160,28160,28130,28210,28320,28200,28170,28140,28170,28700,28140,28160,28140,78660,28480,28240,28190,28200,28310,28170,28700,78660,28200,28200,28310,28130,28310,28130,28310,28310,28190,28210,28170,78660,28700,28700,28130,28200,28700,28160,78125,28140,28140,28240,78660,78660,28140,28230,28170,28170,28310,28210,78660,28160,28200,28700,28480,28310,28480,28230,78125,28250,28310,28170,28170,28310,78125,28310,28140,28310,28210,28210,28210,28700,28170,28140,28200,28160,28210,78125,28210,91410,28200,28480,28200,78125,28170,28170,28240,28310,28200,28140,28290,28240,56580,91410,28310,45310,28210,28210,28200,28210,35290,28210,91410,28310,28240,28240,78125,78660,45310,45310,28310,91740,28420,78125,78730,91740,28500,22530,28210,28200,78125,91670,91410,28140,45310,28160,28240,45480,28250,28140,28210,45310,91780,28200,28240,91410,28200,28170,28500,28480,91740,78120,28480,28500,78125,28500,45170,28500,28210,28500,91410,28240,78730,28500,28210,28220,45480,28170,28240,28290,45410,22680,28480,78113,28290,28240,28240,28220,28420,78113,78730,28290,45410,45310,28250,91930,28170,28220,28290,28500,41240,53220,28250,45480,45410,28500,45480,35750,28500,28220,78125,78120,28500,45310,45480,91410,45310,78113,28420,28400,78120,28500,45410,28220,28500,91410,28220,91150,28500,45170,28420,78113,28330,28220,28400,28220,28240,28250,41240,91780,91780,45310,28400,45520,91410,28500,91660,28500,28270,28220,28100,28220,78730,78730,45410,28480,28420,45310,91410,78113,28410,91690,28220,41240,28410,28500,28400,45410,61110,41240,28500,91870,41270,61290,78125,28330,45310,28250,28330,45520,78610,45130,45480,28270,78610,28500,45480,91690,45480,28330,61290,41270,78720,28270,35420,45140,28500,91410,78113,61110,45480,28330,45170,28410,28410,61110,28410,28410,28250,78610,45130,41270,91690,41270,28400,41160,61110,28270,41270,78550,91660,41160,78830,28500,28400,61290,91530,27650,45520,78490,45170,28400,41270,78950,41160,45130,91690,91150,91690,78610,28250,41160,91530,41240,28410,91150,28570,27650,28500,28330,45300,45130,78550,28270,91150,28270,28270,41270,45170,41270,91580,91470,78720,78830,91150,45480,28400,91690,45170,61110,27320,28400,61110,45480,45520,28400,45300,28380,28330) 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<>'498359' 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='603' 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=69796 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 = 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

  38. 0.0002

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

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

  42. 0.0001

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

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

  46. 0.0001

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

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

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

  54. 0.0001

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

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

  58. 0.0001

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

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

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

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

  71. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  72. 0.0008

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

  73. 0

    SELECT count(*) as nbwish FROM wish

  74. 0.0457

    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

74 requetes sql en 0.0598

Taille variable Globale : 56.99 KB