笔记

select DISTINCT category.`Code` from provincepricingcategory category
join partsgroup cgroup on category.GroupCode=cgroup.code and cgroup.Category=2
join partsgroup pgroup on cgroup.parentCode=pgroup.code and pgroup.Category=1
join sparepart part on part.groupcode=pgroup.groupcode and part.sparebrandcode=cgroup.groupcode
and part .createtime > '2016-05-30'
where category.ModifyTime > '2016-05-30' and ModifyTime < '2016-06-05 20:00:00' and GroupType=2

 

 

select * from pricingcategory where groupcode='25186390'

select * from enterprisepartscost where productcode='25186390'

select * from sparepart where productcode='25186390' select * from enterprisepartscost_u where productcode='25186390' select * from partssaleprice where productcode='25186390'

select * from p1001 where productcode='25186390' select * from hks.epc_parts_detailed   where  materialcode ='25186390' select

select * from provincepricingcategory where groupcode = 'MI-175/65R14-XM2' and customertypeid = 15 and corpcode = 1010

select GroupCode,customertypeid,corpcode,CreateTime,COUNT(1) from provincepricingcategory GROUP BY GroupCode,customertypeid,corpcode,CreateTime having COUNT(1)>1

select * from provincepricingcategory where GroupCode ='MI-185/60R15-XM1'

select GroupCode,category,COUNT(1) from partsgroup GROUP BY GroupCode,category having COUNT(1) >1

 

select * from schedulelog

 and category.groupcode='p002999999'

select DISTINCT category.`Code` from provincepricingcategory category join partsgroup cgroup on category.GroupCode=cgroup.code and cgroup.Category=2 join partsgroup pgroup on cgroup.parentCode=pgroup.code and pgroup.Category=1 join sparepart part on part.groupcode=pgroup.groupcode and part.sparebrandcode=cgroup.groupcode and part .createtime > '2016-05-30' where category.createtime > '2016-05-30' and category.ModifyTime < '2016-06-05 20:00:00' and GroupType=2 and category.groupcode='p002999999'

 

select * from provincepricingcategory category join sparepart part on category.groupcode=part.productcode where category.ModifyTime > '2016-05-30' and category.ModifyTime < '2016-06-05 20:00:00' and GroupType=3 and part .createtime > '2016-05-30'

select * from provincepricingcategory category join sparepart part on category.groupcode=part.productcode where category.createtime > '2016-05-30' and category.createtime < '2016-06-05 20:00:00' and GroupType=3 and part .createtime > '2016-05-30'

 

select DISTINCT category.Id from provincepricingcategory category join partsgroup cgroup on category.GroupCode=cgroup.code and cgroup.Category=2 join partsgroup pgroup on cgroup.parentCode=pgroup.code and pgroup.Category=1 join sparepart part on part.groupcode=pgroup.groupcode and part.sparebrandcode=cgroup.groupcode and part .createtime > '2016-05-30' where category.ModifyTime > '2016-05-30' and ModifyTime < '2016-06-08 20:00:00' and GroupType=2 and category.id<600000  order by category.Id

and category.groupcode='p002999999' select DISTINCT category.Id from provincepricingcategory category

 

update provincepricingcategory category join partsgroup cgroup on category.GroupCode=cgroup.code and cgroup.Category=2 join partsgroup pgroup on cgroup.parentCode=pgroup.code and pgroup.Category=1 join sparepart part on part.groupcode=pgroup.groupcode and part.sparebrandcode=cgroup.groupcode and part .createtime > '2016-05-30' set category.modifytime=now() where category.ModifyTime > '2016-05-30' and ModifyTime < '2016-06-08 20:00:00' and GroupType=2 and category.id<600000  order by category.Id

23238 select * from schedulelog

select * from provincepricingcategory where modifytime> '2016-06-10 14:00'