SET NAMES 'utf8', sql_mode = '', SESSION group_concat_max_len = 3000

SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev2.mpdev.finleo.ru' OR storefronts.url = 'www.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' OR storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' OR storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev2.mpdev.finleo.ru' DESC, storefronts.url = 'www.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru' DESC, storefronts.url LIKE 'dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www.dev2.mpdev.finleo.ru/%' DESC, storefronts.url LIKE 'www_.dev2.mpdev.finleo.ru/%' desc 

SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'

SET time_zone = '+03:00'

SELECT url FROM cscart_bitrix

SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'spectehnika'

SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'spectehnika'

SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'gruzovoy-transport'

SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'gruzovoy-transport'

SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'samosvaly'

SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'samosvaly'

SELECT city_id, city, link FROM cscart_custom_city WHERE link = 'samosval'

SELECT `brand_id` FROM `cscart_brands` WHERE `link` = 'samosval'

SELECT type FROM cscart_seo_names WHERE name = 'samosval' 

SELECT `hash` FROM `hash_filters` WHERE `link` = 'samosval'

SELECT `link`, `company_id` FROM `price_list` WHERE `link` = 'samosval'

SELECT * FROM cscart_seo_names WHERE name = 'samosval'  

SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

SELECT object_id, name FROM cscart_seo_names WHERE name IN ('spectehnika', 'gruzovoy-transport', 'samosvaly') AND type = 'c' AND lang_code = 'ru' 

SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9047 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ru' 

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 506 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 568 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru' 

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 575 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ru'