^"SELECT DISTINCT `g`.`id` FROM `brg_goods` `g` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND ( `g`.`model_base` LIKE '6205%' ) AND ( LOCATE('2RS', g.model_base)>0 ) AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='6205' ) ORDER BY `g`.`id` ASC"
^"SELECT DISTINCT `g`.`id` FROM `brg_goods` `g` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND ( `g`.`spec_desc` LIKE '5026|%' ) AND ( LOCATE('2RS', g.model_base)>0 ) AND ( REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='5026' ) ORDER BY `g`.`id` ASC"
^"SELECT g.id,g.shop_category_id,g.brand_id,g.title,g.simple_desc,g.model_base,g.inventory,g.images,g.original_price,g.max_original_price,g.min_original_price,g.price,g.min_price,g.max_price,g.buy_max_number,g.buy_min_number,g.photo_count,g.sales_count,g.access_count,g.is_exist_many_spec,g.model,g.model_base,length(g.model) as goodslen FROM `brg_brand` `b` INNER JOIN `brg_goods` `g` ON `g`.`brand_id`=`b`.`id` WHERE `g`.`id` IN ('107099','475645','494529','604219','710596','718451','752847','1115179','1621108','1621744','1622066','1622763','1624332','1624333','1698241','1755056','1802253','1802255','1813663','107095','107110','351951','352131','353081','376558','377084','381059','385892','385893','385894','385895','385897','385899','385900','385903','415814','424300','479416','512668','520409','521091','521326','524504','524940','527555','536933','541419','555198','573129','610069','610574','610575','625436','625671','652610','652858','688202','694569','708750','722760','779757','804420','809437','981868','1189198','1189272','1189383','1630389','1646779','1652274','1654898','1660966','1667961','1667962','1696678','1698237','1698238','1698239','1707277','1721517','1721518','1728629','1736337','1755063','1755064','1755065','1755066','1755067','1756903','1781154','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793240','1793241','1793242','1793243','1800270','1802263','1802899','1813666','1813671','1813672') ORDER BY `goodslen` ASC,`g`.`min_price` ASC,`b`.`sort` ASC,`g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` DESC LIMIT 0,18"
^"SELECT `b`.`id`,`b`.`name`,`b`.`logo` FROM `brg_brand` `b` INNER JOIN `brg_goods` `g` ON `g`.`brand_id`=`b`.`id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND ( `g`.`model_base` LIKE '6205%' AND `b`.`is_enable` = '1' ) AND ( LOCATE('2RS', g.model_base)>0 ) AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='6205' ) GROUP BY `g`.`brand_id` ORDER BY b.sort asc"
^"SELECT DISTINCT(gct.name),gct.id FROM `brg_goods` `g` INNER JOIN `brg_goods_category` `gct` ON `g`.`shop_category_id`=`gct`.`id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('107099','475645','494529','604219','710596','718451','752847','1115179','1621108','1621744','1622066','1622763','1624332','1624333','1698241','1755056','1802253','1802255','1813663','107095','107110','351951','352131','353081','376558','377084','381059','385892','385893','385894','385895','385897','385899','385900','385903','415814','424300','479416','512668','520409','521091','521326','524504','524940','527555','536933','541419','555198','573129','610069','610574','610575','625436','625671','652610','652858','688202','694569','708750','722760','779757','804420','809437','981868','1189198','1189272','1189383','1630389','1646779','1652274','1654898','1660966','1667961','1667962','1696678','1698237','1698238','1698239','1707277','1721517','1721518','1728629','1736337','1755063','1755064','1755065','1755066','1755067','1756903','1781154','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793240','1793241','1793242','1793243','1800270','1802263','1802899','1813666','1813671','1813672') ORDER BY gct.id asc"
^"SELECT DISTINCT(gptc.name),gptc.value,Length(gptc.name) as namelen FROM `brg_goods` `g` INNER JOIN `brg_goods_params_template_config` `gptc` ON `g`.`brand_id`=`gptc`.`brand_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('107099','475645','494529','604219','710596','718451','752847','1115179','1621108','1621744','1622066','1622763','1624332','1624333','1698241','1755056','1802253','1802255','1813663','107095','107110','351951','352131','353081','376558','377084','381059','385892','385893','385894','385895','385897','385899','385900','385903','415814','424300','479416','512668','520409','521091','521326','524504','524940','527555','536933','541419','555198','573129','610069','610574','610575','625436','625671','652610','652858','688202','694569','708750','722760','779757','804420','809437','981868','1189198','1189272','1189383','1630389','1646779','1652274','1654898','1660966','1667961','1667962','1696678','1698237','1698238','1698239','1707277','1721517','1721518','1728629','1736337','1755063','1755064','1755065','1755066','1755067','1756903','1781154','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793240','1793241','1793242','1793243','1800270','1802263','1802899','1813666','1813671','1813672') AND ( g.suffix LIKE concat('%', gptc.NAME, '%') and Length(gptc.name)>1 ) ORDER BY (gptc.name='2RS') desc,namelen asc"
^"SELECT gsb.region as value,count(gsb.region) as count FROM `brg_goods_region` `gr` INNER JOIN `brg_goods_spec_base` `gsb` ON `gr`.`name`=`gsb`.`region` INNER JOIN `brg_goods` `g` ON `g`.`id`=`gsb`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND ( `g`.`model_base` LIKE '6205%' ) AND ( LOCATE('2RS', g.model_base)>0 ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
