Réserver
Description de l'annonce
Aspirateur laveur pour rideaux tapis canapé.... #shampouineuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Aspirateur laveur pour rideaux tapis canapé.... #shampouineuse
Autres annonces du voisin
Tout voirAnnonces 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é
15€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='631298'
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='62'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='486873' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 486873
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 631298
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=747 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='631298'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='631298' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 486873 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=486873 LIMIT 1
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486873 AND W.type_id = 1) OR (W.util_id <> 486873 AND W.type_id = 2)) AND (M.post_util_id = 486873 OR M.dest_util_id = 486873) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='486873' 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 = '631298'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='486873' AND wish_id<>'631298' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='1092' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486873 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 486873
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='1017' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 486873
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='62760'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.1167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.1167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.667039197041 AND ville_latitude_deg<50.566360802959 AND ville_longitude_deg>1.7487411304044 AND ville_longitude_deg<3.1512588695956 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('62760','62760','62760','80560','62760','62760','80560','80560','62760','80560','80560','62760','80600','62760','62760','80600','80600','62760','80560','80600','62760','62760','62760','80560','62760','80560','80560','80560','80600','80560','80560','80630','80600','62111','80560','80600','62760','80560','62111','80560','80600','62158','80560','62158','62760','80600','80560','80560','80560','80560','80260','62158','80600','80260','80560','80600','80260','80300','62158','80560','80260','80300','62810','62111','62810','62810','80300','62111','62111','80560','80560','80600','62158','62111','80600','62158','62810','62810','80260','80260','80300','80600','80600','62111','80750','62111','80670','80300','80260','80260','62270','62810','62810','80260','80600','62158','80300','80750','80600','80260','80600','80300','80600','62123','80670','80300','80300','62123','80300','62810','62810','80260','80260','80600','62810','80260','80300','80670','80800','80600','62111','62123','80260','62123','80300','62270','62116','62116','80670','80300','62270','80260','80670','62123','62810','62810','62810','80260','62810','80370','80260','80800','62810','62810','80300','62270','80300','62123','62123','80800','80260','80300','62116','80670','80300','80300','62270','62810','80113','62116','80260','62173','80370','80300','80370','80370','80620','80300','80260','80113','80115','80670','62810','62270','62123','80260','62270','80115','62116','62270','62810','62810','80300','62270','62810','80370','80800','62116','80650','62390','62173','80370','80300','80300','80370','62270','62121','80810','80300','80370','80850','62810','80260','62123','80260','62173','80300','80300','80300','62175','62127','80800','62127','80300','62127','62270','62270','80260','62127','80800','80370','80620','80300','62123','62130','62270','62390','62690','62123','80300','80300','62390','62175','62130','62270','80800','80800','62390','62270','62270','62123','62123','80370','62121','62121','80780','80370','80370','62121','80310','62173','62217','80800','62270','62123','62690','80136','80800','62127','62123','80800','62127','80800','62175','62121','80620','62450','62450','80300','80800','62130','80800','80620','62121','80300','62690','80370','62175','80610','80370','62161','62130','62270','62127','80800','62127','62127','80300','80440','62450','62390','80620','80620','62450','80610','62270','62161','80470','62130','62130','80340','80000','80080','80090','62130','80450','62270','80620','62450','80800','62000','62690','80370','62690','80450','80800','62390','62270','62270','62390','80730','80730','80470','80300','80370','62121','80360','80360','62130','80800','62175','62144','62121','62121','62450','80370','62450','80370','62128','62127','62390','62121','62690','80620','62127','80470','80340','80340','80440','62217','62217','62130','62690','62217','80310','62130','80380','80310','80310','80360','62128','62690','80420','80420','62161','62161','80620','80470','62690','62450','62450','80340','80330','80330','80370','62159','80360','62217','62690','62690','80310','80360','80690','62390','80800','80340','62130','62130','62128','80620','80360','62130','62130','62144','80480','80340','80380','62127','80380','80690','80690','80150','80690','62770','62390','62390','62217','80440','80360','62000','62130','62390','62128','62450','62223','62690','80150','80310','62130','62690','80470','80170','62128','62130','80720','62223','62223','80730','80340','80135','62450','62450','62217','80360','80150','62130','62690','80310','80310','80360','62450','80830','62450','80360','80480','80480','80830','80340','80690','62270','62144','80340','80121','62127','80440','62130','62127','80360','62130','62144','62130','62127','62690','80170','62130','80360','62450','80135','80135','62390','62223','62128','80340','62450','62130','80690','80110','62130','62128','80480','80170','62223','62150','80720','80890','80150','80680','62770','62770','62223','62128','80340','62130','62159','62130','80110','80110','62150','80110','80131','62450','62770','62690','80110','62128','80340','62223','62390','80310','62390','62223','80200','80150','62128','62128','62130','62150','80110','62450','80131','62128','62580','80310','80480','80540','80980','80540','62124','80150','80135','62130','62144','80510','80150','80360','62770','80131','80135','62124','62150','80680','80310','62530','62124','62140','62150','80720','62128','80150','80310','80510','80480','62140','62153','62460','80110','80110','62150','62130','80440','80340','62130','62128','80135','62124','62550','80360','62770','62159','62770','80540','80540','62130','62580','62390','80540','80200','80200','62118','80150','80310','80200','62130','62134','62530','80170','80150','62150','80200','80200','62770','62153','80340','80200','62130','62172','62770','62770','62182','62124','80510','80360','80200','62124','62118','80132','62140','62550','62460','80200','80150','80680','62580','80440','80690','62140','62580','80160','62770','62182','62150','80540','80250','80540','80480','62156','62150','62134','80250','80110','80270','62118','62124','62580','80110','62160','62550','80250','62140','80680','80510','62140','62118','62124','80540','80320','62580','80270','80540','80132','62124','62620','80110','80150','80170','62580','62134','62156','80200','62770','62860','80580','62124','80540','62134','62620','80680','62770','62118','62550','80250','80110','80110','80150','80150','62460','80150','62580','80360','62147','80132','62156','80135','80270','80160','80160','80160','62550','62770','62143','62860','62124','80490','62156','62134','62530','80160','80760','62140','62140','80200','62160','62620','62940','62140','62140','80110','80200','80200','62770','80200','80540','62800','62140','62140','62580','80320','80580','62134','80200','80132','62147','80132','62124','62134','62114','62140','80170','62580','80170','80320','80118','62182','80540','80132','80150','80110','62470','80580','62550','62470','62770','80160','62550','62140','62118','62134','62550','80150','80160','80580','62134','62124','62700','80540','80250','62550','80250','80110','62134','80270','62156','80360','62140','62580','62182','62147','62210','80320','80132','62490','62134','80170','62140','80110','80580','80170','80320','62118','80270','62580','80134','80270','62160','80200','80160','62310','80200','62300','80170','80200','80710','62770','62620','80240','80200','80710','62156','62860','62260','62550','62260','80110','80270','80290','62320','80250','62670','62540','80110','80150','62156','62770','80150','80490','80640','80200','62860','80320','80270','80160','62140','62680','62310','62490','80170','80200','80250','80240','80580','80170','62290','80200','62140','80170','62320','62134','80240','80490','80360','62131','62140','62196','62140','62750','80132','80100','62144','80910','80240','62860','62147','80270','62860','80320','80132','80540','62124','62310','80150','80170','62310','80290','80250','62320','62320','62300','62260','80110','80150','62134','62131','62131','62430','62550','62540','80320','80320','80540','62550','80320','80320','59259','80240','62550','62122','80500','62860','62134','62490','62310','62310','62980','80160','80910','80150','80160','80700','80500','80500','62490','80200','80160','62147','62860','62122','80132','62113','62147','80200','80320','62980','62490','80132','62199','80290','80270','80700','62134','62232','62140','80200','80200','80490','80240','80240','62310','62221','62218','62232','80700','80150','80640','80700','62113','62113','80140','80200','62140','62420','62151','62860','62860','80290','80490','62260','62157','62860','80250','80250','80490','80122','80500','62990','62149','80700','62860','62140','62550','80500','62140','62310','62550','80250','80132','80320','80132','80150','62870','62117','62490','80490','80240','62920','80270','62490','62147','62149','62310','80160','62960','80500','62490','80270','80270','62660','80240','59267','80132','80500','80290','59159','80200','59400','80132','80160','80700','62310','62232','62232','80200','80160','80160','80250','80250','80500','62110','62870','62860','62400','62112','59231','80140','80500','80200','62310','80140','62190','62190','80250','80140','80200','80190','80250','80250','62310','62740','62410','59151','80700','62960','80700','80500','80190','62190','80240','80250','62960','62960','80132','80500','80112','80150','59151','62310','62960','80700','80160','80500','59231','62880','62440','59553','80120','62112','62410','80190','80190','80640','80500','80160','80700','80150','62640','62860','62860','80970','80160','80860','62149','80140','62920','80640','80640','62990','62870','62960','62880','62880','62310','62410','62860','80126','80290','80140','59151','62310','80140','80290','60120','80700','62870','59552','80140','80240') AND fami_id='5' AND cate_id='110' AND type_id='1' AND ssrubr_id='747' AND wish_id<>'631298' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC 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=546645 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546645 AND W.type_id = 1) OR (W.util_id <> 546645 AND W.type_id = 2)) AND (M.post_util_id = 546645 OR M.dest_util_id = 546645) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 546645
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=234562 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 234562 AND W.type_id = 1) OR (W.util_id <> 234562 AND W.type_id = 2)) AND (M.post_util_id = 234562 OR M.dest_util_id = 234562) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 234562
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=468814 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 468814 AND W.type_id = 1) OR (W.util_id <> 468814 AND W.type_id = 2)) AND (M.post_util_id = 468814 OR M.dest_util_id = 468814) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 468814
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=459060 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 459060 AND W.type_id = 1) OR (W.util_id <> 459060 AND W.type_id = 2)) AND (M.post_util_id = 459060 OR M.dest_util_id = 459060) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 459060
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=445314 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 445314 AND W.type_id = 1) OR (W.util_id <> 445314 AND W.type_id = 2)) AND (M.post_util_id = 445314 OR M.dest_util_id = 445314) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 445314
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=426952 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 426952 AND W.type_id = 1) OR (W.util_id <> 426952 AND W.type_id = 2)) AND (M.post_util_id = 426952 OR M.dest_util_id = 426952) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 426952
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=287343 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 287343 AND W.type_id = 1) OR (W.util_id <> 287343 AND W.type_id = 2)) AND (M.post_util_id = 287343 OR M.dest_util_id = 287343) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 287343
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=420126 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 420126 AND W.type_id = 1) OR (W.util_id <> 420126 AND W.type_id = 2)) AND (M.post_util_id = 420126 OR M.dest_util_id = 420126) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 420126
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=414945 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 414945 AND W.type_id = 1) OR (W.util_id <> 414945 AND W.type_id = 2)) AND (M.post_util_id = 414945 OR M.dest_util_id = 414945) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 414945
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=414565 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 414565 AND W.type_id = 1) OR (W.util_id <> 414565 AND W.type_id = 2)) AND (M.post_util_id = 414565 OR M.dest_util_id = 414565) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 414565
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 747
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 AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous