Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Entretien propriété

Autres annonces du voisin

Tout voir
Service entretien espace vert
Service : entretien espace vert

Saint-Cezaire... 06530

Entretien propriété
Profil du voisin
Voisin #308562

Saint-Cezaire-sur-Siagne 06530

25€/h

Demander ce jardinier

Annonces similaires

Tout voir
Service entretien espace vert
Service : entretien espace vert

Montfort-sur-... 83570

Je propose tout travaux jardinage entret
Profil du voisin
Voisin #44690

Montfort-sur-Argens 83570

15€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Trans-en-Prov... 83720

Services divers entretien jardinage
Profil du voisin
Thierry B
5.0

Trans-en-Provence 83720

25€/h

Demander ce jardinier
5.0
Service entretien espace vert
Service : entretien espace vert

Aups 83630

Je suis là  pour vos espaces verts !
Profil du voisin
C B

Aups 83630

20€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Saint-Cezaire... 06530

Entretien propriété
Profil du voisin
Voisin #308562

Saint-Cezaire-sur-Siagne 06530

25€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Frejus 83600

Proposition de services
Profil du voisin
Dylan J

Frejus 83600

25€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Toulon 83200

Jardinière paysagiste qualifiée
Profil du voisin
Fanny H

Toulon 83200

16€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Fréjus 83600

Entretein espace vert
Profil du voisin
Voisin #73668

Fréjus 83600

15€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Saint-Laurent... 06700

Nos services pour vos jardins
Profil du voisin
Herve G

Saint-Laurent-du-Var 06700

25€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Le Muy 83490

Entretien et création de jardin
Profil du voisin
Marwan B

Le Muy 83490

15€/h

Demander ce jardinier
Service entretien espace vert
Service : entretien espace vert

Cogolin 83310

Entretien et remise en état espaces ver
Profil du voisin
Jeremy G

Cogolin 83310

200€/jr

Demander ce jardinier

Demande un service d'entretien d'espace vert entre voisins ou proposer mes services d'entretien d'espace vert.

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

  3. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='entretien-espace-vert' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='532'

  4. 0

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'entretien-espace-vert' 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='38'

  6. 0

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

  7. 0.0001

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

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

  23. 0.0001

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

  24. 0.0001

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

  26. 0

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

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

  35. 0.0001

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

  36. 0.0011

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.65*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.65*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.8- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>43.200339197041 AND ville_latitude_deg<44.099660802959 AND ville_longitude_deg>6.1785458818983 AND ville_longitude_deg<7.4214541181017 HAVING distance <= 50 ORDER BY distance ASC

  37. 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 (06530,06530,83440,83440,06530,06530,06460,06530,83440,83440,06460,06130,06520,83440,83440,06810,06580,06460,06750,83440,06550,83440,83600,06370,06750,06740,06650,06750,83600,83840,06210,06560,06620,06750,06620,06250,83840,06650,06620,83830,06110,06590,06330,06620,06620,83840,06150,06400,83840,06140,06220,83830,83830,83840,06850,04120,06910,83840,06850,06910,83480,06410,06850,06480,83370,83600,06140,83840,04120,06270,83131,83830,06570,83530,83700,06910,06910,06140,06160,06600,06910,83840,06910,83520,83380,06910,06800,04120,83490,04240,06910,06910,06610,83300,06510,04320,83920,04120,83300,06510,06640,06260,83720,06260,06700,83840,06910,04120,06510,06510,06260,06910,04320,06510,06260,83460,83111,06260,04170,06260,83780,06510,06510,04240,06670,04120,06260,04170,06300,06100,06200,06000,04170,83200,04240,06830,83460,06710,06670,04320,06260,06830,06830,06670,04240,06260,06830,06670,04170,06260,06790,83550,83510,04120,06710,06710,06730,06830,06690,06670,06950,83120,06470,04320,83690,04240,83120,06670,06710,06710,06260,06230,04330,06260,04170,04170,83630,04170,06340,06340,06230,06310,06340,83690,06390,06710,04330,83510,04240,83990,06390,06710,06390,06420,83340,83630,83680,83340,83630,06360,06260,06670,06450,04330,06390,83690,06390,06420,83570,04330,06470,06470,83310,06440,06440,06320,06420,83340,04330,06440,83310,06320,04270,83630) AND fami_id='3' AND cate_id='38' AND type_id='1' AND ssrubr_id='532' AND wish_id<>'500247' 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='532' 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=44690 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 = 44690 AND W.type_id = 1) OR (W.util_id != 44690 AND W.type_id = 2)) AND (`post_util_id` = 44690 OR `dest_util_id` = 44690) 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 = 44690

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

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

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

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

  52. 0.0001

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

  53. 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='532' LIMIT 0,1

  54. 0.0001

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

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

  56. 0.0001

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

  57. 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='532' LIMIT 0,1

  58. 0.0001

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

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

  60. 0.0001

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

  61. 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='532' LIMIT 0,1

  62. 0.0001

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

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

  64. 0.0001

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

  65. 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='532' LIMIT 0,1

  66. 0.0001

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

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

  68. 0.0001

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

  69. 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='532' LIMIT 0,1

  70. 0.0001

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

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

  72. 0.0001

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

  73. 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='532' LIMIT 0,1

  74. 0.0001

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

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

  76. 0.0001

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

  77. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 532

  78. 0.0008

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

  79. 0

    SELECT count(*) as nbwish FROM wish

  80. 0.0479

    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

80 requetes sql en 0.0597

Taille variable Globale : 57.48 KB