Discuter
Description de l'annonce
Location lors d'un prochain weekend ensoleillée.
#taille haie
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Location lors d'un prochain weekend ensoleillée.
#taille haie
Annonces similaires
Tout voirLouer un taille haie entre particuliers ou proposer un taille haie en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
30€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='407829'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='taille-haie' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='14'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'taille-haie' LIMIT 1
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='5' AND c.cate_id='88'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='27'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='226572' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 226572
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
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 (87) ORDER BY ssrubr_order ASC
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 (88) ORDER BY ssrubr_order ASC
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 (81) ORDER BY ssrubr_order ASC
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 (110) ORDER BY ssrubr_order ASC
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 (227) ORDER BY ssrubr_order ASC
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 (176) ORDER BY ssrubr_order ASC
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 (79) ORDER BY ssrubr_order ASC
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 (208) ORDER BY ssrubr_order ASC
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 (228) ORDER BY ssrubr_order ASC
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 (207) ORDER BY ssrubr_order ASC
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 (95) ORDER BY ssrubr_order ASC
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 (173) ORDER BY ssrubr_order ASC
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 (83) ORDER BY ssrubr_order ASC
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 (93) ORDER BY ssrubr_order ASC
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 (193) ORDER BY ssrubr_order ASC
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 (91) ORDER BY ssrubr_order ASC
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 (232) ORDER BY ssrubr_order ASC
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 (92) ORDER BY ssrubr_order ASC
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 = 407829
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=14 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='407829'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='407829' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 226572 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 226572 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 226572 AND W.type_id = 1) OR (W.util_id != 226572 AND W.type_id = 2)) AND (`post_util_id` = 226572 OR `dest_util_id` = 226572) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='226572' AND note_visu IN (1,3,4)
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 = '407829'
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='226572' AND wish_id<>'407829' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='27520'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.2667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((0.816667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.817039197041 AND ville_latitude_deg<49.716360802959 AND ville_longitude_deg>0.12756569569402 AND ville_longitude_deg<1.505768304306 HAVING distance <= 50 ORDER BY distance ASC
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 (27520,27520,27370,27520,27520,27520,27520,27800,27520,27290,27520,27520,27800,27310,27520,27520,27290,27370,27370,27520,27800,27800,27370,27670,27370,27310,27370,27370,27290,27370,27290,27800,27670,27310,27800,27290,27290,27370,27310,27890,27290,27370,27310,27800,27370,27290,27670,27370,27800,27110,27310,27110,27370,27370,27290,27310,27370,27370,27800,27310,27310,76500,27290,27800,27800,27110,27370,27350,27290,76113,76530,27110,76500,27310,27370,27110,27110,27110,27800,27310,27800,27450,27290,27350,27110,27370,27450,76500,27170,27110,27370,27450,76530,27350,27800,27800,27110,76530,27350,27800,27800,27370,27550,27350,27110,76410,27500,27350,27110,27350,27110,27170,27350,27290,27370,27800,76530,27450,76320,27350,27370,76530,27800,27500,27110,27350,76113,76410,27800,27170,27170,76320,14450,27110,50680,27450,76113,76480,27800,50250,27110,27550,27110,27800,50570,27370,27450,27110,27350,27110,27300,27340,76480,76380,27170,27400,27560,27170,76840,27800,27450,27560,27500,27470,27400,27560,27400,27470,27110,27500,76410,27400,27560,76650,27110,27300,27500,76480,76940,76480,27170,27300,27170,27500,27300,27340,27500,27110,27110,27400,27110,27560,27340,27560,76410,76350,27400,27560,27470,27110,27170,76580,27500,27230,27560,27110,27230,76480,27170,27500,76120,27300,76480,76840,27500,27680,27190,27300,27500,27110,27300,76410,27500,27400,27180,27300,27170,27230,50310,76140,76800,27680,27300,27230,27400,76940,27680,27170,76520,27500,27560,76480,27680,27500,27300,27460,27500,27400,27340,76380,27180,27230,76520,76380,76330,27110,27500,27400,76940,76920,27400,27300,27400,27230,76840,27190,76300,27680,27260,27930,76330,76940,27170,27260,76000,76100,27340,27400,27460,76150,76250,76480,27410,27930,27400,27260,27230,27400,27400,27190,27500,76520,27300,27230,76480,76330,27300,27210,76150,27180,27410,76520,76480,27410,27260,27500,76240,27500,27460,76940,27230,27100,27930,27930,27930,27410,27300,27260,27400,27230,27190,27690,27430,27100,76170,27210,27430,76520,76240,76960,76330,27410,76130,27270,76240,27210,27400,76150,76480,27190,27170,76480,76490,76490,27410,27210,27400,27170,27260,76490,27680,76520,27930,27410,27190,76160,27230,76160,27430,27230,27230,76360,27190,27300,76520,27930,27590,27300,27930,27210,76420,27680,50390,76170,27410,27680,27260,50410,27930,27430,27260,76190,27760,27410,76490,76160,27410,27740,27260,27930,27930,27270,27230,76770,76230,27180,27330,27230,27260,27400,27270,76490,76360,27930,27410,27210,27490,27100,27430,27430,76490,27590,76520,76360,27190,27210,27180,50630,27210,27190,76190,27600,76190,27680,76160,76190,27190,27230,27360,27610,27210,27230,27490,76170,76770,76190,27330,27930,76170,27190,14100,76160,76770,76170,27430,27180,76360,27600,27180,27330,27380,27190,27190,14590,27930,27270,27210,76490,76160,14590,27190,27190,27230,76490,27210,27270,76430,27930,27430,14130,76570,76190,27190,76190,76230,76490,27190,27930,14590,27430,76520,27490,14100,27600,76570,76570,76710,50210,27210,27380,76520,76160,27940,14100,76190,76170,27270,76190,27330,76170,76710,27190,76160,14130,27930,27380,14590,27330,27000,76170,27270,27940,76190,76190,76570,27190,50700,27210,27700,27700,76190,76210,27490,76170,76160,14130,27270,27230,27930,27330,27210,76210,27380,27600,27210,27930,27600,14130,14290,76710,27270,14380,76190,27190,27180,76160,76690,27930,14100,27380,76570,27490,27700,76520,27440,14130,76430,27700,14130,76190,27930,76170,76190,76710,14130,76190,27600,27910,76210,27330,27180,14130,76640,76570,27190,27190,76210,27940,27600,76170,76230,27930,76690,76570,27330,27270,27210,14100,14130,76190,27180,14600,27380,14290,14600,27440,27190,14100,27700,14290,76570,76210,76116,76116,27270,14290,76116,76160,76210,27380,27330,76970,14100,14100,27930,76970,27380,27160,27940,14100,50270,50260,76760,27330,27720,14130,27390,27190,76210,76690,14290,76210,27240,14130,27390,27700,27700,76640,27330,14290,27120,76760,76430,76430,27330,27930,27120,27910,14100,27950,27600,14100,76690,76750,76640,76890,14290,14130,14100,76190,76430,76690,14130,14130,27930,27240,27700,76116,14130,76570,27380,27120,14290,14290,27160,14100,76970,76190,27160,27700,76190,76430,76690,76640,76760,76690,27440,76210,27930,76190,27930,50270,14600,27910,76890,14290,14600,27250,27950,50330,76760,27240,14130,76116,27700,27120,27120,14600,76640,14130,76190,27120,27160,14100,50330,27250,76750,76430,14290,27930,27390,14130,76690,76210,27220,27240,27390,27180,27390,27600,14100,27850,76760,76750,76970,27240,76430,76190,14100,76690,27120,76640,14130,27390,76890,14290,27240,27390,76430,76890,14290,27930,76760,76690,27940,27910,27250,27240,76210,27440,14130,76690,27950,76640,76430,14600,14100,76116,76760,76430,27920,27920,76690,76210,76116,76640,27120,27220,27120,76690,76430,76210,76640,27160,27910,76890,76640,27950,14140,27790,14130,27910,27440,76690,76210,76560,76690,76760,76890,76640,76116,27240,76190,76116,27160,27940,27120,14100,76750,76430,14130,14340,27120,14100,76750,14600,76210,76210,76640,27390,27700,76780,14130,14290,76640,76850,14130,76890,27440,14130,27700,76700,14600,76640,14290,27250,27220,27120,14140,76780,14140,76690,27950,27950,27390,27440,27240,27510,27220,27700,14100,76560,76750,27240,27120,27240,76760,76750,76850,14290,27160,14130,27700,76640,76890,76690,76750,76760,76560,27250,27220,76110,76850,76780,22870,14130,61470,14140,14140,76760,27120,27240,76110,14600,76110,14800,76560,27950,61550,27950,14340,76560,61550,76430,76890,27240,27160,27480,27220,27250,76890,76640,76700,76110,76700,76430,27150,14390,14100,76750,14130,27950,76890,27390,50110,27120,14800,76430,76890,76680,76850,27120) AND fami_id='5' AND cate_id='88' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='14' AND wish_id<>'407829' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=539701 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 539701 AND W.type_id = 1) OR (W.util_id != 539701 AND W.type_id = 2)) AND (`post_util_id` = 539701 OR `dest_util_id` = 539701) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 539701
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=313063 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 313063 AND W.type_id = 1) OR (W.util_id != 313063 AND W.type_id = 2)) AND (`post_util_id` = 313063 OR `dest_util_id` = 313063) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 313063
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=433958 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 433958 AND W.type_id = 1) OR (W.util_id != 433958 AND W.type_id = 2)) AND (`post_util_id` = 433958 OR `dest_util_id` = 433958) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 433958
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=149821 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 149821 AND W.type_id = 1) OR (W.util_id != 149821 AND W.type_id = 2)) AND (`post_util_id` = 149821 OR `dest_util_id` = 149821) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 149821
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254192 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254192 AND W.type_id = 1) OR (W.util_id != 254192 AND W.type_id = 2)) AND (`post_util_id` = 254192 OR `dest_util_id` = 254192) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 254192
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196819 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196819 AND W.type_id = 1) OR (W.util_id != 196819 AND W.type_id = 2)) AND (`post_util_id` = 196819 OR `dest_util_id` = 196819) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 196819
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=88469 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 88469 AND W.type_id = 1) OR (W.util_id != 88469 AND W.type_id = 2)) AND (`post_util_id` = 88469 OR `dest_util_id` = 88469) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 88469
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=372897 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 372897 AND W.type_id = 1) OR (W.util_id != 372897 AND W.type_id = 2)) AND (`post_util_id` = 372897 OR `dest_util_id` = 372897) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 372897
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 14
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
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

Contactez-nous