Cherche barres de toit C4 berline II
Prix
20€/semaine
-15kgqu'à l'achat
Description
Cherche location ou vente de barres de toit pour une voiture Citroën C4 berline 2016. #barres de toit
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Bousbecque (59166) · publié depuis 3 mois ou +
Discuter
Prix
20€/semaine
-15kgqu'à l'achat
Cherche location ou vente de barres de toit pour une voiture Citroën C4 berline 2016. #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.
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 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='257762'
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 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='35698' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 35698
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 = 257762
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=870 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 35698 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='257762'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='257762' 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=35698 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 = 35698 AND W.type_id = 1) OR (W.util_id <> 35698 AND W.type_id = 2)) AND (M.post_util_id = 35698 OR M.dest_util_id = 35698) 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='35698' 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 = '257762'
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='35698' AND wish_id<>'257762' 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='59166'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.317039197041 AND ville_latitude_deg<51.216360802959 AND ville_longitude_deg>2.3723735889292 AND ville_longitude_deg<3.7942864110708 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 ('59166','59117','08940','59250','59223','59126','08930','59560','08940','59960','07780','07780','08930','08560','59200','59910','08930','59890','59420','07781','07784','08980','07700','59560','08890','59100','59118','07784','08560','08980','08980','59890','59491','59493','59650','59655','59520','08511','08880','07712','59237','59700','07700','08902','08510','59236','59150','08501','08560','59170','59290','59350','08880','59840','08510','59110','08957','08501','59130','08980','08902','59840','08510','59116','08880','59370','08890','59390','08953','08500','59390','07730','59000','59800','59777','59160','59350','59115','07782','59390','59510','59160','07783','08980','07730','08902','07711','07730','59930','59840','08952','59510','59390','08900','08900','59260','59280','08520','59320','07730','08860','59120','59320','08800','07730','08510','08950','59320','08956','59780','08950','07730','59790','08530','08550','08870','59193','08900','08920','08840','59850','59152','59280','59320','08840','08800','59320','07520','08531','59320','59320','07740','59320','07730','08920','08587','08554','08900','08531','07740','08870','08800','59152','59152','08870','59320','59155','59810','59139','08587','59211','59152','08920','59139','08908','08770','07742','08951','59262','08540','08587','59830','08904','08791','07743','59134','62840','08552','08958','59780','59134','07520','59175','07522','59175','59181','07522','08970','08710','08906','08583','07743','59273','59263','07760','08551','08800','08792','59780','08840','07522','08920','08570','08954','08904','08830','08553','59830','59273','59113','08582','07522','08850','59249','08780','59134','08710','59270','07503','08760','59147','59136','59830','08650','08570','08640','08580','59830','59147','59249','07542','08830','59830','07760','08710','59270','62840','59710','07760','07501','59710','07540','08650','59830','07502','59242','62840','59272','08970','59147','59134','07760','59270','59299','59270','07504','59184','59830','59940','59242','59251','59134','08851','08790','59551','59710','07500','08573','59112','07750','08740','08793','59133','09690','07610','08650','08647','59480','07543','59242','08581','07506','59274','07500','59133','08720','08570','08647','59112','08640','08610','08610','08610','62840','08572','59551','08581','07548','59710','59239','59940','59270','07750','08720','07618','08810','07540','08600','59496','08570','59185','07750','08740','08640','08610','07760','07611','59270','62840','59270','07904','09870','07500','59253','07521','09690','08700','08720','08647','07536','07540','59310','59221','09690','09690','07750','08640','08750','59496','09790','07531','59239','07620','07750','59261','62138','08600','59235','62820','59310','59246','62136','08720','59940','59270','08972','09790','07642','59232','62220','09870','59310','07620','08600','07910','62136','59480','09771','07540','07760','08600','62410','62136','08972','62138','08680','08600','08820','07910','08600','08647','62138','08647','09790','08600','07533','07910','59310','07641','07532','62136','07620','07620','07910','07640','59114','09790','59190','08978','62590','59190','62138','09700','09690','07910','07910','09800','08600','62149','09770','09770','08700','59310','09800','07530','07621','08691','07624','08700','07620','09790','07910','62138','09790','09700','08600','59660','59310','08750','59310','62149','59283','07643','59114','08700','62880','59190','59162','08600','07912','62410','09772','09800','09870','07623','07640','59690','59310','09681','62410','59310','62880','62880','08972','08690','59470','62149','09600','07620','09700','62880','62410','59226','08680','62710','07534','07912','62400','62350','08480','08600','07538','08690','08691','59310','08600','59283','62790','62141','07622','08755','59114','62440','08020','08600','62119','08690','07911','59122','08691','08210','09700','62400','07534','07911','09700','07910','07640','59670','09680','59148','07911','62640','62149','59158','09800','09750','09800','09800','59114','08630','59870','62740','59286','07906','08600','09700','59950','08690','59194','59190','08211','62970','09700','08691','59158','62149','07911','59230','09700','08600','09800','59158','09880','62950','08020','62660','08600','09660','62232','09750','07911','59190','09680','59670','59230','09700','62350','62980','08020','62218','62221','62113','62113','59226','09700','09700','07604','59470','07901','62110','62350','09700','08630','59670','08630','08691','59190','59870','08470','07604','59470','62980','08630','59128','62350','08480','08680','62400','62420','59194','59178','62300','07604','62750','62350','07604','09880','09680','08630','62350','59230','59178','09700','07900','07900','09800','62920','62113','62430','09688','07911','62232','62232','08210','08433','09700','07890','59870','59158','59670','59870','59670','59190','07604','59230','08433','08630','59122','09800','59670','59122','09850','62920','59553','59119','59553','59870','07904','08470','59122','09750','07608','08630','62670','62160','59167','62232','62290','09890','08630','08630','09667','62300','59178','59670','62131','62131','09667','62680','59146','59189','07903','07602','08480','09667','62232','59870','08433','08210','09880','09850','09636','08470','62131','09850','62320','08620','62320','59380','07601','09800','59178','08020','62210','08490','09890','59199','59500','08460','09810','59450','07812','62320','59870','59230','59190','08730','08490','59670','59553','62920','08630','62350','08460','62800','62199','62320','59380','09660','62490','59182','59670','62114','62196','59173','08730','09890','62160','59470','59199','59189','07911','07904','62330','62490','09630','62143','62620','07903','09831','09800','08620','08670','08630','62122','59670','09630','09630','09630','07890','59189','07971','59552','59490','07600','07971','08460','08490','09890','08433','07880','09881','59187','59552','09890','07812','59287','59470','59122','08620','09660','62530','09850','62580','59490','59287','59182','07812','08470','09630','07903','08460','09660','09840','07972','07890','62580','59179','09630','59176','59380','09630','09850','08490','59173','59176','07971','07972','09630','62160','09910','59171','59285','59470','09810','59380','07603','62330','09830','08200','62122','08432','62190','62580','59171','09820','09630','09660','09660','08670','62190','07971','62580','08660','59670','59169','62620','59970','59173','07812','62112','08730','62580','08200','09630','09660','59670','09890','07812','62117','59169','62580','62620','62940','07804','08434','09630','62157','59173','62490','62153','08400','59171','62172','09850','09630','07812','09840','08434','08310','08431','62580','09910','07862','62700','59165','62120','62490','62530','62580','09820','59580','62540','59380','07801','08490','62540','59135','59254','59163','62620','62190','08670','62153','07803') 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<>'257762' 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=358266 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 = 358266 AND W.type_id = 1) OR (W.util_id <> 358266 AND W.type_id = 2)) AND (M.post_util_id = 358266 OR M.dest_util_id = 358266) 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 = 358266
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=325587 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 = 325587 AND W.type_id = 1) OR (W.util_id <> 325587 AND W.type_id = 2)) AND (M.post_util_id = 325587 OR M.dest_util_id = 325587) 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 = 325587
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=357096 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 = 357096 AND W.type_id = 1) OR (W.util_id <> 357096 AND W.type_id = 2)) AND (M.post_util_id = 357096 OR M.dest_util_id = 357096) 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 = 357096
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 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