Réserver
Description de l'annonce
Loue robe de mariée très belle. #robe de mariee
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Loue robe de mariée très belle. #robe de mariee
Annonces similaires
Tout voirLouer une robe entre particuliers ou proposer une robe en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
605€
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='415316'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'robe-de-mariee' 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='91'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='236916' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 236916
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 = 415316
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=830 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='415316'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='415316' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 236916 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=236916 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 = 236916 AND W.type_id = 1) OR (W.util_id <> 236916 AND W.type_id = 2)) AND (M.post_util_id = 236916 OR M.dest_util_id = 236916) 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='236916' 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 = '415316'
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='236916' AND wish_id<>'415316' 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='94220'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.7337758163378 AND ville_longitude_deg<3.0995641836622 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 ('94220','94160','94140','94700','94200','94205','94410','94270','94340','94300','94400','94800','94130','94000','94600','93170','93100','94320','94250','94120','94340','94100','94110','94210','94170','94231','94230','94232','94238','94234','94235','94236','94237','94239','94240','94233','75012','75013','75002','75000','75011','75010','75009','75008','75001','75019','75003','75015','75020','75006','75116','75005','75004','75007','75017','75014','75016','75018','92120','94500','94380','93110','94550','93230','93260','93310','94310','94390','94430','94360','93130','94460','92240','92340','92170','92220','94150','93360','94290','93330','93500','93000','94190','93250','94350','92320','93140','94380','94370','94260','94470','92330','94880','94880','94490','92260','94450','92130','94420','93400','91320','94480','92140','91200','93220','92160','93120','93300','91560','93160','92350','91550','93320','93340','93460','92290','92100','92110','91330','94510','92190','92360','93350','91270','93700','93150','91230','92200','91370','92300','94440','91300','93210','93200','77420','77340','94440','92600','93450','92390','91800','91420','93370','92800','92150','77184','77185','93190','93390','93440','91210','92210','92400','93240','91260','92250','77500','93270','92230','91380','91160','92270','94440','92310','92370','94520','94520','77186','91570','92410','77181','93470','92700','77170','91120','93600','91860','93430','95140','95500','93800','91170','93410','91160','93380','91800','77680','78140','92380','77150','91430','91390','91600','95360','77200','92500','77177','91360','92420','92430','91140','77360','95880','91360','92000','77181','77150','77090','91430','77183','78220','91160','95400','91000','91130','91480','95500','91350','91450','93420','91480','78350','77330','95410','95100','95218','95210','91160','78800','93290','95170','77270','95870','77600','78170','77380','91140','77400','78420','77410','95230','91700','95200','91400','95400','91000','91090','95110','95350','95500','91450','91700','77135','78000','77170','77400','78400','95500','77600','77600','77164','95160','91700','91250','78150','77173','78380','91400','78290','77400','78530','78350','95120','91620','95700','78150','95580','95580','91240','91080','95720','91070','95440','78360','91440','77600','95190','95600','78500','77127','91310','77400','78430','91250','95350','95130','91620','91280','91310','78560','91310','77400','78117','91220','91220','91190','77166','77290','91940','78110','77400','95530','77600','77166','95720','91090','95680','77400','95460','95240','95130','91460','77600','78600','91100','77410','91190','78870','77410','91940','95390','95380','95330','91250','78230','77220','78117','77144','78160','78600','95370','95320','91310','77410','78750','91190','91940','78210','78590','77990','95720','95380','77550','95190','91100','78100','78620','78280','95570','77410','77410','77170','95570','78112','77144','77700','77220','78330','78590','91640','77111','77990','91180','77700','77220','78114','95570','95250','95380','95220','77290','77220','91400','78470','95380','77410','91540','91540','91540','95850','95720','78960','95190','77450','91810','77174','95560','95150','95550','91290','77176','77550','95380','77450','78470','91250','91830','77390','78180','95840','91290','95560','77220','91630','77111','77230','95480','77230','77550','91680','77230','95560','91630','77700','78450','78390','78860','77700','78240','91640','77550','95270','78700','91540','95850','95270','77230','95740','77410','78300','77700','91340','91520','78460','95570','91710','95470','91630','95670','77176','91630','77174','95560','78260','77410','91470','77410','91470','78240','77450','91470','78470','78190','95840','77230','77240','77610','91680','95590','77230','77240','91640','77450','77240','91750','78570','95270','95270','95470','91630','77390','77450','95270','78955','77230','78340','77230','77950','77450','95270','95470','91830','77610','78450','95540','77450','77610','77230','95610','91770','91470','77390','77580','77230','77450','91610','77860','77410','91640','91650','91470','77165','78780','77390','78460','77310','95470','91790','78720','77950','95430','91650','77950','95270','95270','77310','95270','78810','91750','78570','78630','95430','95630','77165','77165','77860','60128','77610','77230','78670','78670','77165','95000','91760','95310','77950','91530','78720','78370','78320','91730','77390','78990','95590','91850','91650','77390','95300','78320','78720','91510','77310','91510','95000','95760','77350','77100','77860','95270','77230','77610','77280','77350','95270','91590','77124','78510','95270','91750','95280','77580','78810','78540','77580','78830','91730','91910','77390','60128','95290','60560','78320','77610','77100','77124','78121','60330','95300','77610','77950','95590','60520','77580','95620','77230','77350','91730','77000','77000','91470','95260','77163','78480','77390','78850','77163','95260','91530','95490','77165','78720','60950','78310','91590','60260','91580','77190','60580','95660','77580','78310','77390','91590','78630','77100','95300','77950','77122','95000','77124','95520','78830','77163','78640','91530','77390','78640','77390','78760','78580','77720','60520','77930','60330','91580','95340','77000','95180','77115','77390','77124','95800','77580','91890','60520','78640','77930','78130','95650','95300','91590','95690','95650','91840','60820','77470','91580','77190','78920','95650','77178','78690','91410','95820','91590','77930','78740','77000','91580','78690','78720','95340','77115','91530','91580','77390','78580','77580','91590','77720','77540','95690','77580','78640','77515','77178','78650','77720','77580','78490','60330','77930','77515','78740','77910','60270','60230','77910','77930','91580','60950','78124','77165','77165','91490','78730','78730','77470','78610','91590','78124','77540','77470','78410','95690','95810','95340','78490','78490','77470','77470','77139','95450','78130','95690','77720','60530','77930','91590','95810','60950','60330','77720','77820','91410','78580','91820','95650','95650','77590','77131','78490','78650','77515','78250','60500','60460','91490','91490','95450','78125','91820','60500','78250','77470','77910','78580','77630','77540','77580','91410','77540','77580','95450','60440','78490','78126','60300','60300','60530','91880','60300','60300','78610','78410','95810','78120','91150','78250','77515','78770','77910','77139','60530','77470','77630','78490','78490','77590','77720','95810','78250','60440','78770','60300','95830','91720','60340','60340','78770','60740','78410','60300','78250','77139','95450','77131','60440','95810','60540','60540','78730','60530','77820','77590','95830','78490','78410','77120','78410','78490','60300','77540','78770','77120','77515','60460','60300','78770','77540','77120','95450','60530','91150','60440','78610','91410','77139','60440','77440','91870','77580','95450','77630','78820','77720','78680','77660','91720','60540','78730','91490','77540','91410','78120','78770','60300','95450','95810','60300','60300','91150','78120','77120','77720','60530','95640','77720','60540','77820','77920','77440','78940','91150','78580','78490','77440','78250','60530','60110','77720','95450','78970','60810','60110','77660','95810','78770','78730','60660','60160','77850','77440','78440','91490','77370','95450','60540','95640','91720','95640','60440','78890','77120','78930','78440','95450','91150','78610','95640','95640','60810','77370','91410','78930','77640','60810','95640','77120','91720','95450','91410','77133','78660','60700','78440','77370','77870','91780','91780','78440','95450','77139') AND fami_id='5' AND cate_id='91' AND type_id='1' AND ssrubr_id='830' AND wish_id<>'415316' 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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549784 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 = 549784 AND W.type_id = 1) OR (W.util_id <> 549784 AND W.type_id = 2)) AND (M.post_util_id = 549784 OR M.dest_util_id = 549784) 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 = 549784
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549573 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 = 549573 AND W.type_id = 1) OR (W.util_id <> 549573 AND W.type_id = 2)) AND (M.post_util_id = 549573 OR M.dest_util_id = 549573) 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 = 549573
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='830' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 549573
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=548551 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 = 548551 AND W.type_id = 1) OR (W.util_id <> 548551 AND W.type_id = 2)) AND (M.post_util_id = 548551 OR M.dest_util_id = 548551) 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 = 548551
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546326 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 = 546326 AND W.type_id = 1) OR (W.util_id <> 546326 AND W.type_id = 2)) AND (M.post_util_id = 546326 OR M.dest_util_id = 546326) 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 = 546326
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546399 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 = 546399 AND W.type_id = 1) OR (W.util_id <> 546399 AND W.type_id = 2)) AND (M.post_util_id = 546399 OR M.dest_util_id = 546399) 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 = 546399
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540263 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 = 540263 AND W.type_id = 1) OR (W.util_id <> 540263 AND W.type_id = 2)) AND (M.post_util_id = 540263 OR M.dest_util_id = 540263) 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 = 540263
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541744 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 = 541744 AND W.type_id = 1) OR (W.util_id <> 541744 AND W.type_id = 2)) AND (M.post_util_id = 541744 OR M.dest_util_id = 541744) 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 = 541744
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=456570 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 = 456570 AND W.type_id = 1) OR (W.util_id <> 456570 AND W.type_id = 2)) AND (M.post_util_id = 456570 OR M.dest_util_id = 456570) 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 = 456570
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='830' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=526821 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 = 526821 AND W.type_id = 1) OR (W.util_id <> 526821 AND W.type_id = 2)) AND (M.post_util_id = 526821 OR M.dest_util_id = 526821) 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 = 526821
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 830
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