Réserver
Description de l'annonce
Bonjour
Je cherche à louer un appareil me permettant de nettoyer un tapis de salon de grande dimension.
#shampouineuse
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Bonjour
Je cherche à louer un appareil me permettant de nettoyer un tapis de salon de grande dimension.
#shampouineuse
Annonces similaires
Tout voirLouer une shampouineuse entre particuliers ou proposer une shampouineuse en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
25€
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='531403'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='shampouineuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='747'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'shampouineuse' 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='110'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='380483' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 380483
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 = 531403
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=747 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='531403'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='531403' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 380483 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 380483 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 = 380483 AND W.type_id = 1) OR (W.util_id != 380483 AND W.type_id = 2)) AND (`post_util_id` = 380483 OR `dest_util_id` = 380483) 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='380483' 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 = '531403'
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='380483' AND wish_id<>'531403' 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='59990'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>2.8624652035945 AND ville_longitude_deg<4.2708747964055 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 (59990,59990,59269,59990,59990,59300,59144,59300,59269,59770,59300,59990,59530,59269,59880,59530,59125,59144,59233,59213,59174,59990,59144,59213,59530,59410,59144,59860,59264,59213,59213,59224,59494,59990,59227,59243,59121,59144,59224,59192,59530,59195,59144,59213,59530,59213,59121,59590,59494,59220,59530,59530,59195,59920,59530,59530,59570,59220,59135,59278,59730,59970,59530,59144,59255,59144,59530,59227,59227,59154,59294,59530,59570,59198,59570,59970,59218,59218,59135,59570,59220,59282,59730,59218,59282,59570,59570,59163,59970,59163,59218,59296,59293,59171,59570,59156,59188,59124,59570,59730,59530,59163,59730,59530,59230,59188,59111,59570,59172,59730,59530,59570,59199,59178,59188,59199,59171,59178,59730,59288,59570,59111,59129,59292,59222,59171,59111,59158,59230,59222,59215,59570,59172,59550,59550,59222,59179,59214,59230,59271,59870,59870,59141,59178,59570,59277,59226,59360,59490,59111,59178,59230,59295,59138,59295,59252,59570,59870,59141,59138,59158,59145,59252,59141,59230,59145,59360,59158,59158,59580,59550,59540,59870,59580,59138,59870,59217,59217,59252,59620,59161,59540,59490,59540,59217,59360,59165,59540,59138,59400,59226,59620,59161,59360,59360,59550,59157,59330,59330,59360,59247,59310,59690,59157,59550,59750,59234,59161,59980,59176,59400,59870,59310,59554,59247,59550,59146,59870,59161,59620,59554,59176,59217,59400,59234,59225,59310,59265,59330,59980,59550,59620,59330,59247,59980,59360,59268,59600,59234,59310,59400,59182,59191,59400,59554,59360,59554,59620,59360,59265,59169,59600,59225,59191,59287,59182,59600,59440,59440,59310,59720,59265,59400,59980,59980,59330,59330,59400,59167,59265,59600,59400,59550,59191,59169,59151,02110,59360,59360,59440,02110,59287,59148,59310,59127,59244,59310,62860,59310,59330,59265,59244,59600,59440,59267,59194,59554,59440,59151,59131,59244,59238,59554,02450,59680,59360,59310,59600,59169,59600,59440,59127,59187,59281,59600,59258,59137,59450,59194,59119,62860,59127,59440,59400,59258,59169,02450,62860,59680,59151,02110,59241,02630,59830,02110,02110,62860,59680,59159,59680,59267,59550,02110,59440,02170,02450,59440,59440,59600,62860,59680,59151,59168,59245,59127,59242,59127,02450,59235,59310,59680,59830,59830,59440,59258,59159,59440,59216,59169,59151,59440,59740,59552,59830,59500,59242,59286,59216,59216,62860,59740,02110,62860,62860,59283,62112,59830,62112,62490,59164,02170,59142,59552,59400,02630,62860,59780,59242,59830,59283,59553,59553,62860,59680,02510,02110,59246,62147,62790,59128,59740,62860,59710,59680,62490,59460,02110,59440,59740,62490,02170,02420,59266,59259,59950,62860,59740,62860,59780,59710,02630,59267,59710,59149,02510,62117,59177,02510,02170,59553,59219,59740,59219,59266,59273,62156,02450,02450,59551,59177,62141,02110,59159,59740,62860,59152,62147,59830,59273,02260,59231,59740,62860,62490,62970,59162,62156,59152,59266,59152,02120,59219,62147,62182,59262,59239,02110,02110,02510,02170,62490,02420,59177,59152,02420,62490,62182,62156,59740,02420,59710,02110,59239,59231,02450,59261,59149,02230,59740,59780,02120,02120,62118,02110,02110,02120,59551,62950,59740,62147,02260,62820,62156,59297,02260,59740,02620,62119,02110,59810,62860,59231,62118,02420,59740,62147,59390,02110,62860,62490,62147,62156,59149,59510,62156,62590,02420,59133,59610,02420,59175,62490,62124,62182,02260,59510,59212,59390,62156,59790,62182,59113,59175,02110,62147,59260,59390,59155,62118,02420,62110,62580,62118,02120,59132,02120,02120,62220,59115,02120,02420,59390,02120,62320,62320,02110,02110,62640,80740,02420,80740,59133,62124,59132,02120,59139,62124,62128,02420,02420,62710,02120,02260,02420,02260,62128,62159,62124,62118,62118,02260,02110,59147,02120,02120,02120,02120,62320,62740,80122,59112,02420,62124,02120,62124,80360,02100,62128,62580,62128,62118,62420,59370,62580,59147,02260,62580,59263,59290,59170,02420,02110,59139,80240,62124,62124,62880,62124,62320,02260,02420,62128,59132,02110,62128,80240,59132,02100,02120,02100,80240,59610,59150,62440,02120,02260,59147,80112,02420,59251,59777,59350,59160,59800,59000,62580) AND fami_id='5' AND cate_id='110' AND type_id='1' AND ssrubr_id='747' AND wish_id<>'531403' 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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=362077 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 = 362077 AND W.type_id = 1) OR (W.util_id != 362077 AND W.type_id = 2)) AND (`post_util_id` = 362077 OR `dest_util_id` = 362077) 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 = 362077
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=340150 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 = 340150 AND W.type_id = 1) OR (W.util_id != 340150 AND W.type_id = 2)) AND (`post_util_id` = 340150 OR `dest_util_id` = 340150) 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 = 340150
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369470 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 = 369470 AND W.type_id = 1) OR (W.util_id != 369470 AND W.type_id = 2)) AND (`post_util_id` = 369470 OR `dest_util_id` = 369470) 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 = 369470
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=450612 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 = 450612 AND W.type_id = 1) OR (W.util_id != 450612 AND W.type_id = 2)) AND (`post_util_id` = 450612 OR `dest_util_id` = 450612) 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 = 450612
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=472636 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 = 472636 AND W.type_id = 1) OR (W.util_id != 472636 AND W.type_id = 2)) AND (`post_util_id` = 472636 OR `dest_util_id` = 472636) 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 = 472636
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=269924 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 = 269924 AND W.type_id = 1) OR (W.util_id != 269924 AND W.type_id = 2)) AND (`post_util_id` = 269924 OR `dest_util_id` = 269924) 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 = 269924
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=439712 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 = 439712 AND W.type_id = 1) OR (W.util_id != 439712 AND W.type_id = 2)) AND (`post_util_id` = 439712 OR `dest_util_id` = 439712) 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 = 439712
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392438 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 = 392438 AND W.type_id = 1) OR (W.util_id != 392438 AND W.type_id = 2)) AND (`post_util_id` = 392438 OR `dest_util_id` = 392438) 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 = 392438
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=246638 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 = 246638 AND W.type_id = 1) OR (W.util_id != 246638 AND W.type_id = 2)) AND (`post_util_id` = 246638 OR `dest_util_id` = 246638) 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 = 246638
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544458 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 = 544458 AND W.type_id = 1) OR (W.util_id != 544458 AND W.type_id = 2)) AND (`post_util_id` = 544458 OR `dest_util_id` = 544458) 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 = 544458
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 747
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