|
Url_it url2_it , ( 0 + 3*( 0 + 2.5 * IF (REPLACE(societes.keyword_en, ".", "") LIKE "%cai%", 1, 0) ) + 8*( 0 + 2.5 * IF (REPLACE(societes.nom, ".", "") LIKE "%cai%", 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
|
|
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 + 3*( 0 + 2.5 * IF (REPLACE(societes.keyword_fr, ".", "") LIKE "%cai%", 1, 0) ) + 8*( 0 + 2.5 * IF (REPLACE(societes.nom, ".", "") LIKE "%cai%", 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
|
|
SELECT SQL_CALC_FOUND_ROWS societes.* , sCategories.id id2 , sCategories.Libelle_it lib2 , sCategories.Url_it url2 , categories.id id1 , categories.Libelle_it lib1 , categories.Url_it 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 + 3*( 0 + 2.5 * IF (REPLACE(societes.keyword_it, ".", "") LIKE "%cai%", 1, 0) ) + 8*( 0 + 2.5 * IF (REPLACE(societes.nom, ".", "") LIKE "%cai%", 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
|