-60kg
qu'à l'achat
-30% qu'en magasin
Description de l'annonce
Loue échelle escamotable 8m
Pas de livraison
Bailleul
#Echelle
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-60kg
qu'à l'achat
-30% qu'en magasin
Loue échelle escamotable 8m
Pas de livraison
Bailleul
#Echelle
Louer une echelle entre particuliers ou proposer une echelle en location.
Poster une annonce
-60kg
qu'à l'achat
-30% qu'en magasin
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
-60kg
qu'à l'achat
-30% qu'en magasin
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
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='443506'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='echelle' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='65'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'echelle' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('59' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='149648' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 149648
SELECT util_cp FROM utilisateur WHERE util_id=149648 LIMIT 1
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 = 443506
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=65 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 149648 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='443506'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='443506' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=149648 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=149648 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 = 149648 AND W.type_id = 1) OR (W.util_id <> 149648 AND W.type_id = 2)) AND (M.post_util_id = 149648 OR M.dest_util_id = 149648) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '443506'
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='149648' AND wish_id<>'443506' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59181'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.7*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.250339197041 AND ville_latitude_deg<51.149660802959 AND ville_longitude_deg>2.0733852598863 AND ville_longitude_deg<3.4932747401137 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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('59181','59850','59193','59940','59270','62840','08950','62840','59270','07783','59280','08951','07782','62840','08952','59270','59930','59270','59940','08950','59280','08958','59116','59253','08956','59940','59232','59270','59236','08957','59270','59270','08954','59134','62136','59249','08953','59249','59890','59299','08970','07784','59660','62840','59840','59560','59320','59190','59840','62136','62136','08900','59320','59190','59320','59160','59320','07784','62136','08902','59270','59134','59190','59134','62840','59320','62350','59480','59237','59890','59134','59840','59320','59114','08902','59134','07781','59211','07780','07780','59320','62400','62149','08908','59136','08970','59274','59190','62350','08902','59114','59320','59114','59560','08900','59130','62138','59480','62400','59184','08980','59190','62350','59496','59350','59118','62350','59120','59320','62350','62232','62350','62149','59272','08900','59496','08940','59520','59190','59117','08900','62138','62138','62149','62138','08906','59110','59114','59670','59139','08978','08980','59147','62920','62138','59263','62920','59350','59777','59160','59000','59800','59112','62400','59126','59190','59250','59223','59700','59189','62660','59221','59147','59251','62232','62232','59670','08640','59910','59166','08904','59185','62149','62149','62350','59139','08972','59189','62113','62113','59670','62330','59147','62410','59173','62232','08980','62113','59370','59189','59155','59670','59670','59175','08980','08940','62920','59190','59470','59670','59112','62232','62410','59113','08904','62410','62980','62410','62980','08640','62131','62131','59420','59670','62199','59133','08972','59175','59790','59260','62330','59493','59491','59650','59655','62131','62290','62122','08920','08640','62196','62190','62190','59200','59173','59670','08920','08920','59170','59290','08640','08930','59133','59960','62670','62880','08972','62620','59810','62880','62880','59470','62122','59100','59173','59670','08920','59173','62120','62157','59122','62220','08647','62880','08890','59470','59670','59551','62190','62750','08980','08691','62120','62160','59710','08930','08647','08650','62540','62120','62114','62190','08890','62440','62151','59239','62540','59510','08560','59670','62820','62120','08647','62120','62530','62700','62590','62620','62940','59173','08880','59470','59285','62710','59273','62120','62190','62300','59261','59510','59670','59262','62120','62160','59470','62620','07700','62218','62221','08930','08840','62120','08647','59150','59390','07712','62120','59239','59551','62120','59390','08560','62190','62190','62120','59273','59710','59830','62740','59710','62620','59380','08647','59122','59152','62120','62120','59152','62640','62800','62260','59390','62300','62143','08880','08691','62120','08691','62120','08690','59152','59390','59470','62430','62160','62470','07700','59710','62260','59152','62145','62420','62172','59780','62120','08511','59380','62460','62260','59242','62119','08840','62470','62530','62120','59115','59162','62150','62260','62120','08650','62110','62550','59246','08600','59122','62150','08690','62210','59285','62150','08560','08691','59830','62190','08510','59242','62550','62680','59285','08691','59830','62150','08600','08650','07730','08880','59380','08501','07730','07730','62530','59122','62120','62141','62150','62950','08510','08840','59780','62550','62550','62500','62960','62960','59470','08600','59283','62460','08690','62575','62580','59380','62153','59235','62550','62145','62690','59780','62510','08600','62129','08501','07730','62153','07520','62970','62150','62129','62144','08800','59242','62550','62150','62550','62790','59310','59830','62320','08510','59470','59830','08630','08630','62320','62550','08800','59143','08690','62575','62320','59283','62320','07711','59380','62550','08630','59470','59950','62150','08500','07522','07730','08600','59470','62550','62580','62690','59830','59380','08800','08600','07730','08610','59143','08600','07522','62580','62145','08600','62570','62145','59470','62580','62129','62960','07522','62460','08830','07730','62690','62500','59830','59286','62150','62144','62550','59310','08860','59380','59128','62127','62129','08600','08870','59380','62690','08600','08630','08610','62570','08870','59122','08510','62690','62490','62219','62127','08520','62580','62580','62550','62960','62580','07740','62500','59143','08630','62580','08630','59492','59380','07522','08610','07502','62144','07520','62500','08800','59380','62580','59630','08600','08830','07740','62490','59310','59470','62134','62960','59553','62570','59553','62570','07743','59194','62130','62580','62144','08870','62690','62550','07610','08630','62129','08630','59143','62690','08587','59310','59553','08600','62690','08530','59310','62223','07742','08610','08630','07504','59284','08550','59310','62690','59229','59143','62580','62690','62219','07611','07743','62690','07503','08770','08531','07501','08680','62580','08587','62500','08554','59148','08600','62127','62960','62500','62550','08531','62960','08600','62490','59500','59380','62144','62129','62550','59194','08850','62380','62690','08630','07506','59119','08587','59143','62910','62130','62223','62380','62223','07618','59254','62127','62134','59310','62690','62134','62380','59229','62130','08600','62960','62161','62161','62490','59495','62910','07500','59552','59552','08630','08660','59630','62500','62380','08540','59310','62130','62127','62134','08552','62560','08791','07540','59380','07542','59450','62127','07500','62690','62117','62130','62134','07760','59380','59143','08583','62127','59870','08710','59167','62223','62223','59310','62223','62223','62380','07620','62134','62910','59630','62560','08670','62690','62500','62112','62161','62118','08851','08810','08600','59180','08760','08551','62161','62560','62130','59123','59630','07500','59169','62118','62118','08792','59187','62127','08680','08620','07760','59310','59690','62134','62123','62134','07624','62380','59210','62380','62380','62500','08433','62910','08582','62310','62127','62123','62118','07620','62123','08780','59870','08570','62127','62690','62380','62490','08660','62310','07548','62000','62123','62118','62910','08820','08553','59123','62000','62223','62310','62112','62130','08710','07521','59146','62134','59226','08670','59287','59182','62134','62130','08740','07543','08480','62310','62134','07621','62123','62560','07536','62127','07620','62560','62118','07620','08580','62130','07540','08670','59287','59182','08433','62810','62130','07760','07760','08570','59630','08710','62310','62130','08680','59230','08433','07904','07623','08620','08620','62560','59870','07642','59870','08750','62130','07641','59169','62127','62217','62217','62217','62910','62370','62130','62217','62490','62810','59169','62310','08740','62500','62810','08470','07620','59640','59279','59430','59240','59140','59279','62127','62134','59230','62310','59151','62810','62310','62310','62490','59176','07531','59178','62118','62123','62127','62380','07620','59870','62123','62134','07640','62890','62380','62890','07750','62560','62130','59630','59176','62130','07540','62490','62810','62156','62123','62130','08470','59490','62310','07760','62134','59760','62890','62134','59178','62127','08790','62130') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='65' AND wish_id<>'443506' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=545384 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 = 545384 AND W.type_id = 1) OR (W.util_id <> 545384 AND W.type_id = 2)) AND (M.post_util_id = 545384 OR M.dest_util_id = 545384) 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 = 545384
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490749 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 = 490749 AND W.type_id = 1) OR (W.util_id <> 490749 AND W.type_id = 2)) AND (M.post_util_id = 490749 OR M.dest_util_id = 490749) 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 = 490749
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540593 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 = 540593 AND W.type_id = 1) OR (W.util_id <> 540593 AND W.type_id = 2)) AND (M.post_util_id = 540593 OR M.dest_util_id = 540593) 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 = 540593
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=29270 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 = 29270 AND W.type_id = 1) OR (W.util_id <> 29270 AND W.type_id = 2)) AND (M.post_util_id = 29270 OR M.dest_util_id = 29270) 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 = 29270
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=231055 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 = 231055 AND W.type_id = 1) OR (W.util_id <> 231055 AND W.type_id = 2)) AND (M.post_util_id = 231055 OR M.dest_util_id = 231055) 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 = 231055
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434780 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 = 434780 AND W.type_id = 1) OR (W.util_id <> 434780 AND W.type_id = 2)) AND (M.post_util_id = 434780 OR M.dest_util_id = 434780) 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 = 434780
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 434780
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451101 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 = 451101 AND W.type_id = 1) OR (W.util_id <> 451101 AND W.type_id = 2)) AND (M.post_util_id = 451101 OR M.dest_util_id = 451101) 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 = 451101
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309234 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 = 309234 AND W.type_id = 1) OR (W.util_id <> 309234 AND W.type_id = 2)) AND (M.post_util_id = 309234 OR M.dest_util_id = 309234) 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 = 309234
SELECT ssrubr_slug, ssrubr_title, 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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339897 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 = 339897 AND W.type_id = 1) OR (W.util_id <> 339897 AND W.type_id = 2)) AND (M.post_util_id = 339897 OR M.dest_util_id = 339897) 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 = 339897
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 65
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 65
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 WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous