Prix
Faire offre
Description
Je recherche un 9 places du 17 juillet au 1er août 2019 #minibus
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Camon (80450) · publié depuis 3 mois ou +
Discuter
Prix
Faire offre
Je recherche un 9 places du 17 juillet au 1er août 2019 #minibus
-6500kg
qu'à l'achat
Annonces similaires
Tout voirLouer un minibus entre particuliers ou proposer un minibus 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='271517'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='minibus' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='863'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'minibus' 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='81'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('80' 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='56082' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 56082
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 = 271517
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=863 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 56082 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='271517'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='271517' 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=56082 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 = 56082 AND W.type_id = 1) OR (W.util_id <> 56082 AND W.type_id = 2)) AND (M.post_util_id = 56082 OR M.dest_util_id = 56082) 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='56082' 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 = '271517'
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='56082' AND wish_id<>'271517' 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='80450'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.433639197041 AND ville_latitude_deg<50.332960802959 AND ville_longitude_deg>1.685467310737 AND ville_longitude_deg<3.081192689263 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 ('80450','80440','80450','80440','80330','80330','80440','80800','80800','80800','80380','80136','80260','80115','80440','80000','80080','80090','80680','80260','80115','80800','80260','80260','80380','80110','80260','80260','80800','80680','80480','80800','80440','80110','80480','80260','80480','80480','80380','80110','80260','80110','80800','80260','80800','80110','80800','80250','80260','80250','80440','80730','80730','80470','80260','80250','80680','80260','80480','80730','80110','80480','80260','80260','80800','80800','80800','80260','80260','80113','80800','80470','80250','80110','80680','80260','80680','80470','80720','80260','80160','80110','80720','80470','80160','80800','80110','80110','80560','80560','80260','80250','80250','80260','80113','80800','80470','80160','80110','80110','80800','80540','80540','80800','80310','80160','80160','80160','80260','80300','80300','80110','80480','80250','80260','80250','80300','80170','80300','80720','80560','80160','80160','80300','80110','80540','80540','80170','80300','80260','80110','80310','80310','80300','80170','80110','80300','80800','80560','80250','80160','80340','80260','80110','80670','80560','80160','80110','80300','80110','80300','80800','80540','80650','80670','80110','80160','80310','80300','80540','80310','80340','80540','80250','80250','80170','80250','80160','80540','80131','80600','80118','80310','80300','80500','80560','80134','80540','80250','80250','80560','80290','80310','80670','80500','80500','80340','80250','80250','80600','80300','80560','80121','80670','80560','80560','80710','80131','80560','80160','80500','80300','80810','80310','80250','80670','80160','80160','80250','80131','80540','80250','80170','80310','80850','80300','80610','80300','80160','80670','60120','80170','80500','80250','80630','80560','80310','80340','80340','80710','60120','60120','80560','60120','80500','80310','80170','80670','80300','80170','80340','80540','80160','80160','80170','80560','80310','80310','80500','80610','80910','80560','80500','80290','80560','80160','80500','80780','80750','80600','60120','60120','62760','80540','80420','80420','80910','62760','80300','80340','80500','80500','62760','80500','80340','80340','80300','80500','80170','80560','80160','80300','80170','60120','80560','80500','80290','80290','80500','80560','80560','80600','62760','80300','60120','60120','80620','80160','80500','80560','60120','80750','60120','80340','80290','62760','60120','80160','80170','60120','62760','80340','80290','80320','80300','80560','80620','80560','80540','80500','80340','80200','80500','80540','80320','80600','60120','60120','80500','80690','80300','80300','80160','80340','80300','80300','80300','80170','60360','80500','80500','80270','62111','80560','60120','80170','80700','80600','80600','62760','60120','80200','80540','80620','80500','80600','80830','80300','80360','80890','60120','80290','80620','80370','60120','80700','80980','80290','80830','80700','80620','60420','80160','80290','80320','62760','80370','80620','80290','80200','80640','80700','80500','80160','80700','80270','80690','80700','80300','80700','60120','80370','62111','80340','80600','62760','62760','80270','60120','62760','60210','80320','80370','80270','60360','60120','80320','60120','80600','62760','62450','80300','80290','80510','60360','80620','80200','60360','80500','80700','60210','80270','80360','62111','80500','80600','62760','62760','80300','80270','60360','80700','80620','60120','80600','60120','80360','80290','80320','62111','80126','80320','80510','60210','80700','80700','80700','80690','80300','80290','60420','60420','80600','80700','60120','80640','80200','60120','60120','80690','80690','80500','80200','80360','80320','80320','80270','80200','80370','80370','62111','80500','80270','60480','80640','80360','80360','80370','62760','60420','80500','80200','60210','80700','60420','62116','80700','60210','80290','60420','80270','80300','80700','80640','80200','80320','80300','80600','62760','60480','60480','80200','80620','80370','62450','60420','80500','80510','60120','80620','60360','80690','80600','60210','60120','80320','60480','60420','80360','80290','80290','80700','80600','80300','62111','60480','80600','80270','80200','62116','60480','80590','80190','60420','62158','60360','80500','80140','80360','80700','80600','62158','80700','62111','80510','80360','80320','62158','60420','80700','80590','80600','80135','80290','80490','80200','80700','80290','80700','80370','62111','60360','80135','62121','80640','80190','80590','80320','80140','80600','80200','60130','62810','60130','80360','60480','80600','62270','60480','60130','80370','80490','60360','80370','80360','80700','80370','80370','60480','62158','60420','80370','62158','80690','60420','80370','80590','62450','60360','80580','80700','80200','80700','80135','80140','80200','80580','62450','80360','60210','60360','80500','80700','80700','80270','80270','62121','80200','80200','80190','60210','62116','80190','62810','62158','60490','60480','60420','60420','62111','80135','62810','60490','60480','80132','62450','80370','60210','60480','60130','80700','62450','80590','80190','80200','80490','80700','80190','80590','80700','80190','62810','80140','80140','80140','62123','62116','60360','60490','80430','80370','60360','80200','80200','62810','62121','80370','80132','62450','62450','60480','80700','62116','80580','60210','62116','60490','80360','60490','80190','80590','80190','80190','62450','62390','80270','80290','62123','62390','60130','62121','80140','80430','62810','60210','60310','80490','80590','80200','60480','60130','62158','60480','62123','62450','80580','60420','60480','60210','60210','60310','80370','80200','60310','62810','62450','60210','60310','62390','60420','80590','80140','80135','60480','60130','80490','80360','80190','60360','60210','60490','80200','80430','80140','60360','60690','80430','62270','80140','80200','80135','62450','80190','80190','80200','62270','80580','62450','60210','80580','62450','80140','62810','60480','80150','62121','62121','80190','62121','80490','60130','62270','80190','60130','62270','80140','60130','62123','62173','62390','62810','60420','80190','80190','60480','60490','60130','62810','60310','80140','80430','62270','80132','62450','80140','80150','62121','80200','80490','62175','62123','80760','62270','60210','60310','60690','60690','60310','60220','62390','62123','62123','60310','80430','60210','60490','60130','60310','60490','80200','80400','60480','60420','80140','80190','80360','62175','80150','60420','60490','80400','80190','60310','80150','62173','60860','62450','62450','80430','80200','62270','60510','60210','80132','60210','62124','80132','80140','60220','62173','80930','80400','80590','62270','62810','80140','62810','62175','60130','60130','62810','62159','80200','80400','62810','80140','80240','60860','80430','62810','80400','60190','62121','60112','62450','60690','62124','80400','62810','60130','80132','80150','62175','62390','80430','60510','60510','60490','60860','62270','60490','80150','60510','62121','80140','80140','80200','80135','80430','60860','80132','62124','80200','62270','62810','62390','62123','60220','80400','60420','80150','80140','60210','62390','62390','80360','80132','80100','60112','60220','80400','62173','60220','60960','60480','60310','80240','60130','62270','60210','62270','60130','60310','80140','62810','80140','60310','60640','62270','62270','80150','60220','62123','80140','80140','60130','60130','62810','62217','62124','60510','60190','80140','62270','62128','80400','60380','80430','80400','60690','60310','60112','62810','62124','80240','62128','62159','62123','76390','60190','60220','60690','60510','62810','60310','60190','60310','80132','62390','80400','80150','62175','60510','80150','80132','60490','60860','80140','80200','76340','80140','80140','62270','62810','60510','60190','62390','80200','62270','80240','76390','62270','62124','62130','62130','62127','60640','80360','80140','62128','60130','80132','62124','80400','62127','60220','60480','60310','80150','62390','62127','62124','80240','80240','76390','60380','60510','60220','62123','62123','80240','80150','60510','60130','62127','80870','80140','62217','80240','80200','60310','80400','76390','60860','62124','62270','62124','60640','60490','62123','62123','80240','60220','62270','62690','60640','62390','60190','62128','80240','60380','80140','62270','80400','80400','62123','60220','80140','80140','60220','60157','60490','60380','60310','60190') AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='863' AND wish_id<>'271517' 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='863' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=343143 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 = 343143 AND W.type_id = 1) OR (W.util_id <> 343143 AND W.type_id = 2)) AND (M.post_util_id = 343143 OR M.dest_util_id = 343143) 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 = 343143
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='863' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=176487 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 = 176487 AND W.type_id = 1) OR (W.util_id <> 176487 AND W.type_id = 2)) AND (M.post_util_id = 176487 OR M.dest_util_id = 176487) 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 = 176487
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='863' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=219283 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 = 219283 AND W.type_id = 1) OR (W.util_id <> 219283 AND W.type_id = 2)) AND (M.post_util_id = 219283 OR M.dest_util_id = 219283) 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 = 219283
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='863' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=85780 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 = 85780 AND W.type_id = 1) OR (W.util_id <> 85780 AND W.type_id = 2)) AND (M.post_util_id = 85780 OR M.dest_util_id = 85780) 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 = 85780
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='863' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=50797 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 = 50797 AND W.type_id = 1) OR (W.util_id <> 50797 AND W.type_id = 2)) AND (M.post_util_id = 50797 OR M.dest_util_id = 50797) 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 = 50797
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