Résultats de recherche

Tous les résultats :

"cuisine"

Détails

    LES AMIS DE JOëL GARAULT

Joel Garault restaurant Monaco cuisine

Adresse:30, boulevard Princesse Charlotte 98000 Monaco

Liens utiles:

  Vie associative / Amicales

Détails

    THC - TOTAL HOME CONTROL

Thc Domotique Audiovisuel home cinema video

hifi

Adresse:8 avenue de l' Annonciade 98000 Monaco

Tél +377 97 70 70 42

Liens utiles:

  Commerces - Shopping / Electro-Ménager - Audiovisuel

Détails

    TV + SERVICES

Tv audiovisuel plasma tnt multimedia

home cinéma antennes paraboles télé

Adresse:37 bis rue Plati 98000 Monaco

Tél +377 93 15 93 98

Liens utiles:

  Commerces - Shopping / Electro-Ménager - Audiovisuel

SELECT SQL_CALC_FOUND_ROWS societes.* , sCategories.id id2 , sCategories.Libelle_fr lib2 , sCategories.Url_fr url2 , categories.id id1 , categories.Libelle_fr lib1 , categories.Url_fr url1 , categories.icon icon , categories.Libelle_fr lib1_fr , categories.Url_fr url1_fr , categories.Libelle_en lib1_en , categories.Url_en url1_en , categories.Libelle_it lib1_it , categories.Url_it url1_it , sCategories.Libelle_fr lib2_fr , sCategories.Url_fr url2_fr , sCategories.Libelle_en lib2_en , sCategories.Url_en url2_en , sCategories.Libelle_it lib2_it , sCategories.Url_it url2_it , ( 0 + 8*(MATCH (societes.nom) AGAINST ("cuisine" IN BOOLEAN MODE)) + 3*1.5*(MATCH (societes.keyword_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 1.5*1.5*(MATCH (sCategories.Libelle_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 1*1.5*(MATCH (sCategories.Alias_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 8*( 0 + 1 * IF (REPLACE(societes.nom, ".", "") LIKE "%cuisine%", 1, 0) ) ) AS score FROM societes JOIN sCategories ON (societes.id_biz_2=sCategories.id) JOIN categories ON (sCategories.id_biz_1=categories.id) WHERE 1 AND societes.actif=1 AND societes.id<>4023 AND ( 0 + 8*(MATCH (societes.nom) AGAINST ("cuisine" IN BOOLEAN MODE)) + 3*1.5*(MATCH (societes.keyword_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 1.5*1.5*(MATCH (sCategories.Libelle_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 1*1.5*(MATCH (sCategories.Alias_fr) AGAINST ("cuisine" IN BOOLEAN MODE)) + 8*( 0 + 1 * IF (REPLACE(societes.nom, ".", "") LIKE "%cuisine%", 1, 0) ) ) >0 ORDER BY IF (societes.nom="cuisine", 1, 0) DESC, IF (societes.client>0,1,0) DESC , score DESC , IF (societes.client>0,1+RAND(),0) DESC, societes.nom LIMIT 0, 35