Discuter
Description de l'annonce
Cherche à louer pour les 2 premières semaines de juillet barre de toit mazda cx3 #barres de toit
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Cherche à louer pour les 2 premières semaines de juillet barre de toit mazda cx3 #barres de toit
Annonces similaires
Tout voirLouer des barres de toit entre particuliers ou proposer des barres de toit en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
80€
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='505833'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='barres-de-toit' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='870'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'barres-de-toit' 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='227'
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='344112' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 344112
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 = 505833
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=870 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='505833'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='505833' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 344112 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=344112 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 = 344112 AND W.type_id = 1) OR (W.util_id <> 344112 AND W.type_id = 2)) AND (M.post_util_id = 344112 OR M.dest_util_id = 344112) 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='344112' 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 = '505833'
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='344112' AND wish_id<>'505833' 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='62150'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.45*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.45*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.53333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.000339197041 AND ville_latitude_deg<50.899660802959 AND ville_longitude_deg>1.8271431645938 AND ville_longitude_deg<3.2395168354062 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 ('62150','62150','62150','62460','62150','62460','62620','62700','62150','62620','62940','62150','62470','62150','62127','62540','62620','62470','62150','62127','62150','62460','62620','62260','62196','62122','62690','62540','62122','62130','62260','62690','62199','62690','62550','62530','62131','62550','62232','62550','62127','62131','62131','62550','62530','62690','62232','62690','62157','62690','62920','62530','62127','62550','62172','62290','62151','62114','62113','62130','62127','62232','62232','62127','62260','62690','62690','62550','62400','62690','62127','62690','62670','62550','62130','62550','62920','62690','62160','62127','62690','62550','62660','62690','62113','62113','62130','62550','62160','62127','62920','62690','62260','62144','62190','62127','62550','62980','62190','62190','62144','62550','62144','62130','62149','62130','62550','62160','62190','62232','62400','62980','62130','62190','62144','62690','62350','62130','62153','62550','62127','62149','62690','62350','62130','62190','62120','62190','62127','62143','62550','62127','62130','62400','62127','62190','62144','62134','62134','62134','62810','62810','62350','62810','62130','62800','62127','62149','62130','62153','62960','62960','62123','62130','62120','62130','62120','62123','62123','62750','62960','62130','62149','62130','62130','62810','62123','62580','62149','62130','62810','62350','62270','62350','62810','62330','62810','62136','62161','62161','62134','62134','62810','62270','62120','62161','62138','62130','62810','62330','62350','62134','62130','62136','62130','62120','62270','62161','62810','62130','62580','62138','62134','62134','62138','62350','62410','62134','62300','62120','62120','62136','62810','62120','62134','62810','62123','62960','59480','62130','62130','62223','62130','62145','62810','62123','62145','62134','62300','62136','62223','62410','62130','59660','62840','62580','62120','62210','62270','62123','62270','62960','62580','62810','62810','62134','62120','62123','62138','62134','62810','62123','62000','62270','62270','62410','59189','62130','62130','62145','62840','62134','62130','62223','62960','59496','62130','62120','62223','59253','62270','62134','62880','62221','62218','62810','62310','62430','62223','62130','62580','59940','59940','62270','62810','62158','62680','62130','62270','59189','62810','62138','62130','62120','59189','62310','62880','62880','62960','59480','62960','62270','62270','62310','62580','62810','62123','62223','59496','62580','62410','62770','62123','62123','62145','62000','62310','59221','62120','59134','62320','62810','62270','62580','62440','62158','59274','62270','62840','62770','62420','62217','62217','62173','62158','62310','62580','62123','62770','62217','62123','59134','59249','62770','62270','62217','62320','62223','62580','62310','62880','62740','62270','62120','62310','62770','62120','62840','62310','59190','62158','59249','62560','62173','62270','62580','62158','62158','80600','62173','59185','62770','62320','62320','80600','62310','62270','59184','62710','62310','62640','62129','59173','62810','62129','62110','62217','62310','59232','62123','59134','62270','62310','59940','80600','62173','62223','62310','59272','59173','62770','62580','62120','62770','80600','59190','62760','62310','62770','59112','62770','62560','62129','62158','62390','62118','62770','62129','62270','62217','62310','62111','62560','59136','62120','62270','62310','62310','59270','62270','62217','62840','62270','59173','62118','62310','62220','59251','59134','62490','62490','59270','62111','62770','62770','62770','62175','62129','80600','62129','59112','62770','62760','62760','62760','59190','59190','62560','80600','62175','59134','62760','59190','62118','62310','62590','62119','62116','62310','62380','62111','62770','62950','62175','62128','62760','62111','62120','62175','62390','62128','62760','59147','59133','62128','62128','59320','62120','59173','62118','62575','59181','62390','62175','62390','62118','59147','62490','62770','62380','59280','62128','62760','62760','62111','59173','80600','59270','59190','59147','62128','62770','59320','59320','59211','59190','62140','62390','62560','62118','62121','62390','62116','62140','62570','62570','59193','62310','80600','62128','59270','62310','62820','62970','62490','59270','62116','62390','62560','62560','59850','62390','62118','59133','62575','59320','62140','62760','59190','59114','62380','59162','62141','59263','62140','62140','59553','62760','59261','80600','62760','80600','59320','62121','59280','62140','62156','62560','62111','59320','62380','62156','62510','62121','62560','62111','62140','62116','62128','62570','62760','80370','80600','62140','62140','62140','62117','59930','80600','62310','80600','59239','59320','59950','59320','62390','59840','59320','59239','62156','62390','59128','62390','59113','59670','80560','80560','62570','80560','80600','62116','62380','62128','59670','62111','80560','59139','80370','62128','59551','59553','59553','59670','59114','80600','59270','62760','62128','62560','62760','62111','62140','62990','62790','59160','62219','62156','62490','07783','62156','62140','62219','62760','62121','62390','62140','59552','62380','62380','62140','62490','62140','80560','59175','59116','62560','59120','62112','62500','59270','62156','62500','62390','62390','80600','62116','59500','59114','59283','59840','62990','80560','59283','08950','59670','59114','80560','59286','62140','80560','62990','07782','59551','08951','62182','62140','59670','80560','59552','80370','62650','59139','62121','80370','62500','62140','62112','59670','80560','80600','62380','62380','59270','80150','59175','62140','62140','59169','80600','62121','59710','62140','62490','59670','62121','62380','62159','62128','62128','62490','62990','59246','62650','62650','62990','59155','08958','80370','62182','59299','62500','80560','62500','59840','80370','62156','62390','59259','59670','59236','59143','80370','62390','62500','62121','80600','62121','62121','08952','80560','62990','62990','62990','59151','59285','80630','80300','08954','62650','08950','62650','80300','62128','59710','59130','59670','80300','80600','80300','62860','59710','80150','62380','59237','59119','62182','62650','62450','62182','62380','62650','62500','80370','62500','59450','08956','59310','80560','59670','80560','59670','59194','62380','80750','80560','80300','62144','59187','59169','59000','59800','59160','59350','59777','80560','62860','62500','59350','80150','59670','62650','62650','59890','62990','62140','59151','80600','62450','80300','59790','59285','62650','59710','08957','80370','62860','62990','62380','59143','59110','80370','59235','80750','62450','59810','59273','62860','62860','08970','62380','80150','80370','59194','80150','59151','59890','59560','62450','59143','07784','80560','62159','62910','59285','80560','80560','62159','62140','59169','62450','80370','80300','62380','59118','08953','62990','80150','80370','62860','62380','62450','62990','59470','62860','62860','59287','62910','62650','59260','80560','80300','59520','62500','59470','80370','62450','80300','59242','62910','80670','62450','59167','62650','59169','59470','62380','07784','62860','59700','59242','62870','80670','08978','59370','80370','80370','80370','62124','62450','80300','59148','62650','62140','62450','62450','08900','59182','59287','80560','80300','62650','59273','80370','62124','80560','62910','80150','59151','62380','80620','62860','62860','62650','08970','62860','62860','59143','80260','59262','59151','62990','59310','59182','62990','80150','80300','59169','62380','62890','62170','59310','62910','08902','62870','80620','62870','62380','62450','07780','07780','80150','62870','62240','80370','62860','80150','80300','80150','62240','59143','80300','80620','59470','62124','80620','80300','07781','59830','62860','59470','59470','59470','59830','80260','62170','80300','59176','08902','59470','59910','59143','62450','62910','80360','62650','80260','80150','80150','62124','59146','59560','59234','80150','62450','80150','80300','62147','62450','80300','59242','80360','59265','80260','08908','62890','62650','62170','62170','59470','62170','59310','80260','62124','08972','62240','62870','80150','59176','62124','62147','59470','59170','59290','80670','59870','59223','59250','59126','59152','59152') AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='870' AND wish_id<>'505833' 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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=426355 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 = 426355 AND W.type_id = 1) OR (W.util_id <> 426355 AND W.type_id = 2)) AND (M.post_util_id = 426355 OR M.dest_util_id = 426355) 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 = 426355
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=418656 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 = 418656 AND W.type_id = 1) OR (W.util_id <> 418656 AND W.type_id = 2)) AND (M.post_util_id = 418656 OR M.dest_util_id = 418656) 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 = 418656
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411154 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 = 411154 AND W.type_id = 1) OR (W.util_id <> 411154 AND W.type_id = 2)) AND (M.post_util_id = 411154 OR M.dest_util_id = 411154) 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 = 411154
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=199384 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 = 199384 AND W.type_id = 1) OR (W.util_id <> 199384 AND W.type_id = 2)) AND (M.post_util_id = 199384 OR M.dest_util_id = 199384) 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 = 199384
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=386754 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 = 386754 AND W.type_id = 1) OR (W.util_id <> 386754 AND W.type_id = 2)) AND (M.post_util_id = 386754 OR M.dest_util_id = 386754) 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 = 386754
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326494 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 = 326494 AND W.type_id = 1) OR (W.util_id <> 326494 AND W.type_id = 2)) AND (M.post_util_id = 326494 OR M.dest_util_id = 326494) 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 = 326494
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326162 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 = 326162 AND W.type_id = 1) OR (W.util_id <> 326162 AND W.type_id = 2)) AND (M.post_util_id = 326162 OR M.dest_util_id = 326162) 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 = 326162
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=268679 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 = 268679 AND W.type_id = 1) OR (W.util_id <> 268679 AND W.type_id = 2)) AND (M.post_util_id = 268679 OR M.dest_util_id = 268679) 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 = 268679
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=267369 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 = 267369 AND W.type_id = 1) OR (W.util_id <> 267369 AND W.type_id = 2)) AND (M.post_util_id = 267369 OR M.dest_util_id = 267369) 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 = 267369
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='870' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=256776 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 = 256776 AND W.type_id = 1) OR (W.util_id <> 256776 AND W.type_id = 2)) AND (M.post_util_id = 256776 OR M.dest_util_id = 256776) 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 = 256776
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 870
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