select * from car_hit_Update_setting where setTime>= 1810 and setTime<= 2010 order by no ;
2,20:10
update `truck` set hit=hit+2 where state <> '판매완료' and fileupload<>'' and big_category='렉카/셀프로더' and ( member_id<>'ydltmdrhs' and member_id<>'yeksu' and member_id<>'ohs0713' and member_id<>'didgustn3456' and member_id<>'xoen' and member_id<>'zib105' and member_id<>'skc0287' and member_id<>'rkh3033' and member_id<>'om442cotv' and member_id<>'cnryghks1600' and member_id<>'sooi5001' and member_id<>'choism53' and member_id<>'mega' and member_id<>'kjss6600' and member_id<>'jjsjjs8' and member_id<>'ht6565' and member_id<>'aas147as' and member_id<>'gjrkdcjf' and member_id<>'kevin0304' and member_id<>'wsmi2179' and member_id<>'maengho85' and member_id<>'jiniclub' and member_id<>'yhkim1007' and member_id<>'sktnsqo' and member_id<>'KSJ75014' and member_id<>'nsi0805' and member_id<>'sk4995' and member_id<>'jhs9959' and member_id<>'lykll9642' and member_id<>'abc1191' and member_id<>'mss3207' and member_id<>'guseo5456' and member_id<>'kjh70191' and member_id<>'goory79' and member_id<>'gkh033' and member_id<>'cwcarss' and member_id<>'diemin6' and member_id<>'dyct1029' and member_id<>'top7856' and member_id<>'wnsqltlf' and member_id<>'mcl486486' and member_id<>'rrrrrimm' and member_id<>'sung3s' and member_id<>'cnh3005' and member_id<>'attlas76' and member_id<>'bk3747' and member_id<>'hjs1520' and member_id<>'dunhill002' and member_id<>'yong5906' and member_id<>'rockme22' and member_id<>'wjhs777' and member_id<>'kimmg6323' and member_id<>'k741227' and member_id<>'rkdthgml89' and member_id<>'kjdcar' and member_id<>'hl3qbs' and member_id<>'pjin109' and member_id<>'firstyoum' and member_id<>'jaegab0416' and member_id<>'hong7253' and member_id<>'57432' and member_id<>'modool' and member_id<>'dudgh1706' and member_id<>'vipno1' and member_id<>'kjk7175' and member_id<>'leesm9669' and member_id<>'vlwjdrlf' and member_id<>'su0621' and member_id<>'jtl1293' and member_id<>'whdydgus77' and member_id<>'silverjins' and member_id<>'kyw8052' and member_id<>'maduan' and member_id<>'jsoo0804' and member_id<>'sms0222' and member_id<>'jwlee5656' and member_id<>'do7968' and member_id<>'musso10' and member_id<>'vision0964' and member_id<>'vkdnjelffj' and member_id<>'JOJOCH123' and member_id<>'eoqkr5960' and member_id<>'jamsejin' and member_id<>'eecjin' and member_id<>'lhg0557' and member_id<>'baram30c' and member_id<>'speedguma' and member_id<>'trajet03' and member_id<>'jjs590525' and member_id<>'h1j2y3' and member_id<>'skj8243' and member_id<>'eok10' and member_id<>'ww9876' and member_id<>'jinuy2760' and member_id<>'tjj090775' and member_id<>'bc2644' and member_id<>'slap12' and member_id<>'ysj1842' and member_id<>'jooy' and member_id<>'h1j2y32000' and member_id<>'aaa440' and member_id<>'h1j2y300' and member_id<>'mkh2' and member_id<>'chu067' and member_id<>'prk651')