Discuter
Description de l'annonce
Bonjour je voudrais louer un aspirateur vapeur dans les plus bref délais merci. #nettoyeur vapeur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour je voudrais louer un aspirateur vapeur dans les plus bref délais merci. #nettoyeur vapeur
Annonces similaires
Tout voirLouer un nettoyeur vapeur entre particuliers ou proposer un nettoyeur vapeur 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.
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='420945'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='nettoyeur-vapeur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='983'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'nettoyeur-vapeur' 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='243753' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 243753
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 = 420945
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=983 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='420945'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='420945' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 243753 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=243753 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 = 243753 AND W.type_id = 1) OR (W.util_id <> 243753 AND W.type_id = 2)) AND (M.post_util_id = 243753 OR M.dest_util_id = 243753) 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='243753' 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 = '420945'
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='243753' AND wish_id<>'420945' 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='62540'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.050339197041 AND ville_latitude_deg<50.949660802959 AND ville_longitude_deg>1.8097358452443 AND ville_longitude_deg<3.2236041547557 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 ('62540','62540','62122','62470','62700','62260','62460','62157','62470','62122','62260','62199','62151','62920','62150','62150','62550','62196','62620','62940','62460','62232','62620','62260','62550','62232','62620','62150','62150','62190','62232','62232','62550','62131','62920','62920','62131','62131','62550','62550','62190','62460','62190','62190','62550','62620','62260','62400','62350','62190','62150','62150','62550','62550','62190','62190','62120','62232','62150','62350','62113','62550','62290','62530','62130','62150','62127','62127','62550','62350','62150','62660','62550','62190','62400','62550','62550','62120','62127','62120','62400','62550','62113','62113','62960','62960','62114','62690','62330','62350','62690','62530','62350','62670','62330','62690','62120','62130','62130','62172','62550','62134','62149','62980','62530','62120','62130','62960','62350','62127','62690','62350','62690','62127','62690','62149','62120','62120','62120','62980','62130','62127','62134','62136','62160','62160','62145','62130','62149','62134','62160','62149','62690','62120','62127','62690','62145','62136','62120','59660','62690','59189','62127','62149','62690','62960','62136','62130','62134','62127','62690','62130','62136','62134','62690','62144','62120','62144','62130','62690','59189','62690','62127','62134','62145','62130','62143','62130','62138','59189','62130','62144','62134','62960','62130','62153','62138','62134','62134','62750','62120','59253','59940','62800','62138','62840','62120','62127','62144','62960','59480','62134','62127','62690','59940','62130','62130','62127','62130','62127','62690','62960','62840','62153','62134','62145','62130','62130','62144','62134','62410','62960','62130','62127','62134','62120','62580','62130','59190','62810','62810','62810','62130','62138','62310','62410','62134','62120','62130','59496','59173','62810','62123','62840','62134','62130','62300','62270','62270','62123','62123','62129','62130','59480','62300','62310','62310','62410','59173','59232','62123','62310','62310','62130','62129','62130','62130','62810','59190','62810','62120','62270','62161','62161','62840','62580','62810','62810','62810','62120','62161','62560','59134','59940','62129','62810','62138','62130','59249','59496','62210','62880','59173','62270','62161','62130','62130','62310','59274','59270','62810','62223','62310','59134','62129','62221','62218','62130','62130','62580','62410','59221','62310','62560','59249','59190','62770','62130','62580','62810','62310','62310','62880','62880','62223','59270','62270','62123','59190','62270','62270','62810','62129','62770','62430','59190','62120','62123','62560','62129','62680','62310','59173','62310','62120','62310','59134','62770','62123','62310','62310','59184','62575','62440','62270','62270','62223','62380','62810','62810','62840','62770','62270','62580','62000','62770','59173','62810','62270','62123','59190','62123','62310','59185','62310','62560','59190','62223','62270','62880','62270','62420','62810','62223','59272','62380','62580','62580','59134','59270','62770','62320','62270','62570','59181','59136','62770','62740','59270','62570','62310','59190','62810','62310','59112','59114','62770','62560','62575','62810','62158','62580','62223','62710','62580','62320','59270','62810','59134','62640','62000','62270','62510','62270','62270','62810','62123','59280','59251','62770','62580','62310','62380','62110','62770','62560','59320','62123','62123','59193','62320','62320','62570','62270','62217','62217','62560','59670','62770','59850','59670','62158','62223','62270','59670','62380','59112','62220','62580','62173','62158','59114','62570','62770','62217','59320','59320','62770','62123','59147','62217','62380','62390','62560','62123','59211','62219','59270','62219','62770','62770','62580','80600','59280','62770','59133','62310','62560','62770','59147','62310','62590','62810','62500','62158','59114','62173','59670','62158','59147','62140','80600','62270','62217','62500','62270','62173','59670','59114','62158','59320','62223','62119','59670','62380','62380','59930','59320','59270','80600','62490','80600','62118','62500','62270','62950','59670','62123','62140','62173','59270','62490','07783','59320','59840','62770','62560','62270','59263','62217','62380','08951','59320','62118','08950','62760','59670','62380','59133','62310','62820','62560','59320','62158','59143','62500','62111','62390','62500','59285','59299','62500','62217','62380','59160','62390','59320','59116','07782','62140','62118','08958','62140','59670','62140','62140','62490','80600','62390','80600','62390','62650','59139','62970','59261','62140','62390','62175','62990','62140','59840','62111','08954','59113','62390','59162','59670','62760','62760','62500','59670','62128','62118','62760','62760','62175','62128','62140','62141','59670','62175','08952','62500','08950','62760','62116','62118','59120','62650','62990','59285','59239','62140','62760','62111','62380','62128','59551','59239','80600','62175','62380','62140','62490','62990','62118','62390','62500','62111','62128','59236','62128','62650','59143','80600','62175','08956','62140','59553','59175','62128','62650','59139','62140','62380','59840','59143','59950','62390','59285','62118','62760','62760','62990','62111','62140','62650','62910','08970','62140','59470','59128','62380','62390','62121','62140','62650','62128','59175','62790','59470','62116','59237','62650','62140','62380','59553','59553','08957','59155','62117','59470','59551','59890','59130','80600','62116','62910','62910','62390','62156','80370','62650','59710','62990','62500','62990','62990','59283','62990','08978','80600','62156','80600','62380','62760','59283','62140','80370','62760','62140','62140','08953','62390','62128','62760','80600','62121','59286','62380','07784','59560','59350','62650','59552','62650','80600','62390','62390','62156','62910','59246','59143','59000','59800','59160','59350','59777','80600','62760','62111','62121','59500','59890','62116','62111','62140','62490','62490','08900','62380','08970','62156','62112','80600','62910','59110','62128','80150','62156','59552','62128','62128','59710','62890','59710','07784','80560','80560','59470','59143','80560','62650','59790','62380','59470','59470','62116','59118','62380','62390','62760','62111','80560','62990','62112','62390','62156','59470','59470','62760','62380','80370','62990','59169','62760','59143','80370','62121','08902','59810','62111','59520','62144','62650','62910','59710','62990','59310','80370','80600','62490','62490','80150','80600','62650','59273','59470','62182','59470','59700','80560','62650','59260','59119','62240','62890','08972','80600','80560','80370','59470','62116','80370','62990','59194','59370','80560','80560','62140','07780','07780','59235','07781','59143','80560','80560','08908','59151','62240','59259','62650','62121','59450','08902','62156','62128','62128','80370','62182','80600','62121','62159','59187','80150','62121','62850','80150','62140','62240','62860','59470','59242','62170','59560','59169','59242','62870','59194','62990','80630','59380','80560','62650','59273','62121','62121','62182','62650','62990','62890','62182','62121','59630','62128','59122','80370','62850','62240','59910','59151','59380','59262','80560','08900','08902','62860','62240','80150','62850','80300','80600','08900','08972','80750','80150','62140','62170','62890','80300','62870','80370','62890','80300','80300','62450','59223','59250','59126','08972','62850','08906','80370','08980','59167','80370','62870','59151','59287','59148','62860','62860','59117','80150','59169','59830','62890','62890','80370','80560','62890','59380','59122','80560','80150','80560','08940','62370','59380','80750','62860','59310','62240','59170','59290','08640','80300','62170','80600','80560','62870','59169','59491','59493','59650','59655','59830','62850','62170','62170','59310','59380','62370','62450','62860','62650','62240','59420','08900','59182','59287','80300','62890','59380','62860','59630','62450','80370','59510','62890','08640','62650','59152','59152','59630','62860','08640','62159','59242','62850','80370','80370','62159','59182','62240','59166','62450','59284','80370','62450','62830') AND fami_id='5' AND cate_id='110' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='983' AND wish_id<>'420945' 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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=538919 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 = 538919 AND W.type_id = 1) OR (W.util_id <> 538919 AND W.type_id = 2)) AND (M.post_util_id = 538919 OR M.dest_util_id = 538919) 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 = 538919
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=456854 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 = 456854 AND W.type_id = 1) OR (W.util_id <> 456854 AND W.type_id = 2)) AND (M.post_util_id = 456854 OR M.dest_util_id = 456854) 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 = 456854
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=454848 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 = 454848 AND W.type_id = 1) OR (W.util_id <> 454848 AND W.type_id = 2)) AND (M.post_util_id = 454848 OR M.dest_util_id = 454848) 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 = 454848
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434841 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 = 434841 AND W.type_id = 1) OR (W.util_id <> 434841 AND W.type_id = 2)) AND (M.post_util_id = 434841 OR M.dest_util_id = 434841) 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 = 434841
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=376109 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 = 376109 AND W.type_id = 1) OR (W.util_id <> 376109 AND W.type_id = 2)) AND (M.post_util_id = 376109 OR M.dest_util_id = 376109) 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 = 376109
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=284208 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 = 284208 AND W.type_id = 1) OR (W.util_id <> 284208 AND W.type_id = 2)) AND (M.post_util_id = 284208 OR M.dest_util_id = 284208) 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 = 284208
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=279704 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 = 279704 AND W.type_id = 1) OR (W.util_id <> 279704 AND W.type_id = 2)) AND (M.post_util_id = 279704 OR M.dest_util_id = 279704) 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 = 279704
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=216055 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 = 216055 AND W.type_id = 1) OR (W.util_id <> 216055 AND W.type_id = 2)) AND (M.post_util_id = 216055 OR M.dest_util_id = 216055) 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 = 216055
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=167273 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 = 167273 AND W.type_id = 1) OR (W.util_id <> 167273 AND W.type_id = 2)) AND (M.post_util_id = 167273 OR M.dest_util_id = 167273) 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 = 167273
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=90615 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 = 90615 AND W.type_id = 1) OR (W.util_id <> 90615 AND W.type_id = 2)) AND (M.post_util_id = 90615 OR M.dest_util_id = 90615) 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 = 90615
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 983
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