select * from `class_fields` LEFT JOIN `class_fields_lang` on `class_fields`.`id` = `class_fields_lang`.`id` where `lang_id` = 'ru' and `active` = 1 and `quick_search` = 1 and ( `fieldset` REGEXP '\\b103,105,107\\b' or `fieldset` = 0 ) order by `order_no`;
# city subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]
# https://city.site.com/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^user/$ st.php?crt_dealer=%1 [L,QSA]
if(isset($_GET['crt_city']) && $_GET['crt_city'] && !$city) {
global $config_live_site;
header("Location:"."https://".$crt_city.".site.com"."/user/"); exit(0);
}
# city subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]
# https://city.site.com/search/
#RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
#RewriteRule ^$ list.php?crt_city=%1 [L,QSA]
# https://city.site.com/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^$ st.php?crt_dealer=%1 [L,QSA]
# https://city.site.com/search/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^search/$ list.php?crt_city=%1 [L,QSA]
# subdomain
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) st.php?crt_dealer=%2 [nc,qsa]
# subdomain 2
RewriteCond %{HTTP_HOST} !www.site.com$ [NC]
RewriteCond %{HTTP_HOST} ^(www.)?([a-z0-9-_]+).site.com [NC]
RewriteRule (.*) list.php?crt_city=%2 [NC,QSA]
RewriteRule ^search/?$ list.php [nc,qsa]
RewriteRule ^search/([^/]+)(?:/?([^/]*)/?([^/]*)/?)? /list.php?category_slug=$1&oblast_slug=$2®ion_slug=$3 [L,QSA]
RewriteCond %{REQUEST_URI} ^(.*)(/list.html)(.*)$ [NC]
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule (.*) ./list.php?$1 [QSA]
# https://city.site.com/search/
RewriteCond %{HTTP_HOST} ^(?>www\.|)([\w-]+)\.site\.com$ [NC]
RewriteRule ^search/$ list.php?crt_city=%1 [L,QSA]
$array_x=$db->fetchAssocList($get_list_cat);
$j=0;
foreach($array_x as $fa) {
if($j) $str_found .= ",".$fa['id'];
else $str_found .= $fa['id'];
$j++;
}
$where.= " and ( ".TABLE_A.".category_id in( $str_found ) )";
REGEXP '\[\[:<:\]\]103,104, 105, 106, 107\[\[:>:\]\]'
это работает в типе varchar, в int не хочет