DROP TABLE IF EXISTS `totalproduct_5a8ceb27c1b3c` /* generated by server */
DROP TABLE IF EXISTS `init_5a8ceb27c1b69` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8ceb27c258a` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8ceb27c2499` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8ceb27c258d` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8ceb27c249b` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8ceb27c24a2` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8ceb27c233e` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8ceb27c2341` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8ceb27c2343` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8ceb27c2344` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8ceb27c2348` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8ceb27c2346` /* generated by server */
DROP TABLE IF EXISTS `final_5a8ceb27c2472` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8ceb26f0297` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8ceb26f029e` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;DROP TABLE IF EXISTS producttemp_5a8ceb27c1b38;;

    				DROP TABLE IF EXISTS product_null_5a8ceb27c24a0;;

    				CREATE TEMPORARY TABLE product_null_5a8ceb27c24a0  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8ceb26f0297` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8ceb26f029e` (
DROP TABLE IF EXISTS `producttemp_5a8ceb27c1b38` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8ceb26f029e`,`tmp_tbl_oldprdt5a8ceb26f0297`,`tmp_tbl_5a8ceb26f02a4`
DROP TABLE IF EXISTS `totalproduct_5a8ceb27c1b3c` /* generated by server */
DROP TABLE IF EXISTS `init_5a8ceb27c1b69` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8ceb27c1b6b` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8ceb27c2119` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8ceb27c211b` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8ceb27c1b6d` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8ceb27c2492` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8ceb27c2494` /* generated by server */
DROP TABLE IF EXISTS `final_5a8ceb27c2472` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8ceb27c2494` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8ceb27c2492` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8ceb27c1b69` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8ceb27c252a` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8ceb27c252e` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8ceb27c2530` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8ceb27c2472` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8ceb27c258a` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8ceb27c2499` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8ceb27c258d` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8ceb27c2499` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8ceb27c249b` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8ceb27c24a2` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8ceb27c24a0` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8ceb27c24a0  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8ceb27bff4d` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8ceb27c2499` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8ceb27c249b` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8ceb27c24a2` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8ceb27c24a2`,`latest2_5a8ceb27c249b`,`update_price_5a8ceb27c2499`,`lastest_bal_5a8ceb27bff4d`,`product_null_5a8ceb27c24a0`,`latest_5a8ceb27c258d`,`bal_cost_5a8ceb27c258a`,`final_5a8ceb27c2472`,`tmp_latest_bal_bal_5a8ceb27c2530`,`tmp_latest_bal_date_5a8ceb27c252e`,`_temptable25a8ceb27c252a`,`init_5a8ceb27c1b69`,`initv_5a8ceb27c1b6d`,`initialtablebycomp25a8ceb27c211b`,`initialtablebycomp5a8ceb27c2119`,`initpd_5a8ceb27c1b6b`,`totalproduct_5a8ceb27c1b3c`,`producttemp_5a8ceb27c1b38`,`tmp_tbl_olddate5a8ceb26f029e`,`tmp_tbl_oldprdt5a8ceb26f0297`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d10b20` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb2d10b20 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d30f75` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb2d30f75 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d30f75`,`tmp_non_replicate_shorttext_5a8ceb2d10b20`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d62484` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb2d62484 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d6f14c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb2d6f14c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb2d6f14c`,`tmp_non_replicate_shorttext_5a8ceb2d62484`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb351e784` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb351e784 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb351e784`
DROP TABLE IF EXISTS `tmp_tbl1_sn_5a8ceb36ccc28` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl2_sn_5a8ceb36ccc2c` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl3_sn_5a8ceb36ccc2e` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl2_sn_5a8ceb36ccc2c 	

CREATE TEMPORARY TABLE tmp_tbl1_sn_5a8ceb36ccc28 	(INDEX(dt_serial))

DROP TABLE IF EXISTS `tmp_tbl_final_sn_5a8ceb36ccc30` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl_final_sn_5a8ceb36ccc30

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3750375` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3750375 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3759520` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3759520 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb375ba88` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb375ba88 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb37614a0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb37614a0 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3764c32` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3764c32 (INDEX(st_id))

DROP TABLE IF EXISTS `tmp_targetglobalsetting`,`tmp_sourceglobalsetting`,`tmp_finalglobalsetting` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_finalglobalsetting`,`tmp_sourceglobalsetting`,`tmp_targetglobalsetting`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3764c32`,`tmp_non_replicate_shorttext_5a8ceb37614a0`,`tmp_non_replicate_shorttext_5a8ceb375ba88`,`tmp_non_replicate_shorttext_5a8ceb3759520`,`tmp_non_replicate_shorttext_5a8ceb3750375`,`tmp_tbl_final_sn_5a8ceb36ccc30`,`tmp_tbl1_sn_5a8ceb36ccc28`,`tmp_tbl2_sn_5a8ceb36ccc2c`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb386ef57` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb386ef57 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb387c2bf` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb387c2bf (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb387c2bf`,`tmp_non_replicate_shorttext_5a8ceb386ef57`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb38aa876` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb38aa876 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb38aa876`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb38de09c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb38de09c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb38de09c`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb393f66f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb393f66f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb393f66f`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3a1b967` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3a1b967 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3a26335` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3a26335 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3a26335`,`tmp_non_replicate_shorttext_5a8ceb3a1b967`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3d7194d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3d7194d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3e54f5c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3e54f5c (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8ceb3e86233` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ea5a8d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ea5a8d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ea8b4d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ea8b4d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3eb1484` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3eb1484 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3eb4b78` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3eb4b78 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3eb78d5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3eb78d5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ebb885` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ebb885 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ebe91e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ebe91e (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ec1956` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ec1956 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ec570a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ec570a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ec8b21` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ec8b21 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ecc822` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ecc822 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ed01e6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ed01e6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ed90aa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3ed90aa (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3f03c57` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3ed90aa`,`tmp_non_replicate_shorttext_5a8ceb3ed01e6`,`tmp_non_replicate_shorttext_5a8ceb3ecc822`,`tmp_non_replicate_shorttext_5a8ceb3ec8b21`,`tmp_non_replicate_shorttext_5a8ceb3ec570a`,`tmp_non_replicate_shorttext_5a8ceb3ec1956`,`tmp_non_replicate_shorttext_5a8ceb3ebe91e`,`tmp_non_replicate_shorttext_5a8ceb3ebb885`,`tmp_non_replicate_shorttext_5a8ceb3eb78d5`,`tmp_non_replicate_shorttext_5a8ceb3eb4b78`,`tmp_non_replicate_shorttext_5a8ceb3eb1484`,`tmp_non_replicate_shorttext_5a8ceb3ea8b4d`,`tmp_non_replicate_shorttext_5a8ceb3ea5a8d`,`temp_5a8ceb3e86233`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8ceb3e54f5c`
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3f03c57 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3f03c57`,`tmp_non_replicate_shorttext_5a8ceb3d7194d`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3f8e810` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb3f8e810 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb3f8e810`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb52d85a8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb52d85a8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb52e5592` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb52e5592 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb52e5592`,`tmp_non_replicate_shorttext_5a8ceb52d85a8`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5431548` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5431548 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb543befe` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb543befe (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb543befe`,`tmp_non_replicate_shorttext_5a8ceb5431548`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb553cbaa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb553cbaa (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb55465e1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb55465e1 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb55465e1`,`tmp_non_replicate_shorttext_5a8ceb553cbaa`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb57720b3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb57720b3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb577bf0f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb577bf0f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb577bf0f`,`tmp_non_replicate_shorttext_5a8ceb57720b3`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5a1e636` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5a1e636 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5a28205` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5a28205 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5a28205`,`tmp_non_replicate_shorttext_5a8ceb5a1e636`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5e22a11` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5e22a11 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5e2ce68` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5e2ce68 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5e2ce68`,`tmp_non_replicate_shorttext_5a8ceb5e22a11`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5f92ba3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5f92ba3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5f9ba4b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb5f9ba4b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb5f9ba4b`,`tmp_non_replicate_shorttext_5a8ceb5f92ba3`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6055719` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6055719 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb605dda2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb605dda2 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb605dda2`,`tmp_non_replicate_shorttext_5a8ceb6055719`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb661aa55` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb661aa55 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb66251a9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb66251a9 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb66251a9`,`tmp_non_replicate_shorttext_5a8ceb661aa55`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb675881b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb675881b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6761d95` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6761d95 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6761d95`,`tmp_non_replicate_shorttext_5a8ceb675881b`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb68b995a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb68b995a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb68c3d4e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb68c3d4e (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb68c3d4e`,`tmp_non_replicate_shorttext_5a8ceb68b995a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6a5339a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6a5339a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6a5decd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6a5decd (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6a5decd`,`tmp_non_replicate_shorttext_5a8ceb6a5339a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6c30b14` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6c30b14 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6c3bbec` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6c3bbec (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6c3bbec`,`tmp_non_replicate_shorttext_5a8ceb6c30b14`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6f7f827` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6f7f827 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6f89914` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb6f89914 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb6f89914`,`tmp_non_replicate_shorttext_5a8ceb6f7f827`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7154a41` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb7154a41 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb715dc96` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb715dc96 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb715dc96`,`tmp_non_replicate_shorttext_5a8ceb7154a41`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7287235` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb7287235 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7290e62` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb7290e62 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7290e62`,`tmp_non_replicate_shorttext_5a8ceb7287235`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7524853` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb7524853 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb752e8f6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb752e8f6 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb752e8f6`,`tmp_non_replicate_shorttext_5a8ceb7524853`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb7737b98` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb7737b98 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb77417b3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb77417b3 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb77417b3`,`tmp_non_replicate_shorttext_5a8ceb7737b98`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb78cd1f1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb78cd1f1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb78d6c90` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceb78d6c90 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceb78d6c90`,`tmp_non_replicate_shorttext_5a8ceb78cd1f1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb3e9113` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebb3e9113 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb3f3ffd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebb3f3ffd (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb3f3ffd`,`tmp_non_replicate_shorttext_5a8cebb3e9113`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb66426a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebb66426a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb66e47c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebb66e47c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb66e47c`,`tmp_non_replicate_shorttext_5a8cebb66426a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb733ceb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebb733ceb (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebb733ceb`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebbfb40a2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebbfb40a2 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebbfb40a2`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebdfd6153` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebdfd6153 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebe19b999` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebe19b999 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebe19b999`,`tmp_non_replicate_shorttext_5a8cebdfd6153`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebe3d4858` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebe3d4858 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebe3dfd47` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cebe3dfd47 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cebe3dfd47`,`tmp_non_replicate_shorttext_5a8cebe3d4858`
DROP TABLE IF EXISTS `tmp_tbl_5a8cec0082afe` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cec0082afe SELECT * FROM bill_detail where dt_transno=93518 and dt_type1='SN' and dt_type2='RN' and dt_transeqno>0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cec0082af2 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cec010385d` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec0103885` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec0103faa` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec0103ed1` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec0103fad` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cec0103ed3` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec0103ed8` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cec0103d81` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cec0103d84` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cec0103d85` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cec0103d87` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cec0103d8b` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cec0103d89` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec0103ea9` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec0082af2` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec0082af9` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;DROP TABLE IF EXISTS producttemp_5a8cec0103859;;

    				DROP TABLE IF EXISTS product_null_5a8cec0103ed7;;

    				CREATE TEMPORARY TABLE product_null_5a8cec0103ed7  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec0082af2` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec0082af9` (
DROP TABLE IF EXISTS `producttemp_5a8cec0103859` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cec0082af9`,`tmp_tbl_oldprdt5a8cec0082af2`,`tmp_tbl_5a8cec0082afe`
DROP TABLE IF EXISTS `totalproduct_5a8cec010385d` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec0103885` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8cec0103887` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cec0103c1c` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cec0103c1f` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cec0103889` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cec0103ec9` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cec0103ecb` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec0103ea9` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cec0103ecb` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cec0103ec9` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cec0103885` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8cec0103f52` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cec0103f55` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cec0103f57` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cec0103ea9` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec0103faa` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec0103ed1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec022808a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec022808a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0233b64` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec0103fad` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0233b64 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec0103ed1` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0233b64`,`tmp_non_replicate_shorttext_5a8cec022808a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0253d3c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0253d3c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0260b19` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0260b19 (INDEX(st_id))

DROP TABLE IF EXISTS `latest2_5a8cec0103ed3` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec0103ed8` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cec0103ed7` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cec0103ed7  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cec0101ba6` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec0103ed1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cec0103ed3` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cec0103ed8` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cec0103ed8`,`latest2_5a8cec0103ed3`,`update_price_5a8cec0103ed1`,`lastest_bal_5a8cec0101ba6`,`product_null_5a8cec0103ed7`,`latest_5a8cec0103fad`,`bal_cost_5a8cec0103faa`,`final_5a8cec0103ea9`,`tmp_latest_bal_bal_5a8cec0103f57`,`tmp_latest_bal_date_5a8cec0103f55`,`_temptable25a8cec0103f52`,`init_5a8cec0103885`,`initv_5a8cec0103889`,`initialtablebycomp25a8cec0103c1f`,`initialtablebycomp5a8cec0103c1c`,`initpd_5a8cec0103887`,`totalproduct_5a8cec010385d`,`producttemp_5a8cec0103859`,`tmp_tbl_olddate5a8cec0082af9`,`tmp_tbl_oldprdt5a8cec0082af2`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0260b19`,`tmp_non_replicate_shorttext_5a8cec0253d3c`
DROP TABLE IF EXISTS `tmp_tbl1_sn_5a8cec07b11bb` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl2_sn_5a8cec07b11bf` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl3_sn_5a8cec07b11c1` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl2_sn_5a8cec07b11bf 	

CREATE TEMPORARY TABLE tmp_tbl1_sn_5a8cec07b11bb 	(INDEX(dt_serial))

DROP TABLE IF EXISTS `tmp_tbl_final_sn_5a8cec07b11c3` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl_final_sn_5a8cec07b11c3

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec080ab1b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec080ab1b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0811f5b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0811f5b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0815173` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0815173 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec081bfac` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec081bfac (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec08204dd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec08204dd (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec08204dd`,`tmp_non_replicate_shorttext_5a8cec081bfac`,`tmp_non_replicate_shorttext_5a8cec0815173`,`tmp_non_replicate_shorttext_5a8cec0811f5b`,`tmp_non_replicate_shorttext_5a8cec080ab1b`,`tmp_tbl_final_sn_5a8cec07b11c3`,`tmp_tbl1_sn_5a8cec07b11bb`,`tmp_tbl2_sn_5a8cec07b11bf`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0d57919` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0d57919 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cec0d8a711` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dac1db` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dac1db (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0daf9ae` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0daf9ae (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0db42b6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0db42b6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0db789b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0db789b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dba69e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dba69e (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dbe56a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dbe56a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dc19ea` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dc19ea (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dc4c44` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dc4c44 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dc805f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dc805f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dcbb43` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dcbb43 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dcf51a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dcf51a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dd2a88` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dd2a88 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dd5a26` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec0dd5a26 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec0dd5a26`,`tmp_non_replicate_shorttext_5a8cec0dd2a88`,`tmp_non_replicate_shorttext_5a8cec0dcf51a`,`tmp_non_replicate_shorttext_5a8cec0dcbb43`,`tmp_non_replicate_shorttext_5a8cec0dc805f`,`tmp_non_replicate_shorttext_5a8cec0dc4c44`,`tmp_non_replicate_shorttext_5a8cec0dc19ea`,`tmp_non_replicate_shorttext_5a8cec0dbe56a`,`tmp_non_replicate_shorttext_5a8cec0dba69e`,`tmp_non_replicate_shorttext_5a8cec0db789b`,`tmp_non_replicate_shorttext_5a8cec0db42b6`,`tmp_non_replicate_shorttext_5a8cec0daf9ae`,`tmp_non_replicate_shorttext_5a8cec0dac1db`,`temp_5a8cec0d8a711`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cec0d57919`
DROP TABLE IF EXISTS `tmp_tbl_5a8cec132f2ca` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cec132f2ca SELECT * FROM bill_detail where dt_transno=42614 and dt_type1='SN' and dt_type2='DN' and dt_transeqno>0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cec132f2bc 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cec1735759` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec1735784` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec1735e9a` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec1735d96` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec1735e9d` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cec1735d98` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec1735d9d` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cec1735c54` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cec1735c57` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cec1735c59` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cec1735c5b` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cec1735c5f` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cec1735c5d` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec1735d6c` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec132f2bc` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_oldprdt5a8cec132f2bc values  (\'19830\') , (\'27116\') , (\'31801\') , (\'31218\') , (\'16404\') , (\'27848\') , (\'34718\') , (\'31226\') , (\'31800\') , (\'26990\') , (\'28831\') , (\'38627\') , (\'38626\') , (\'38179\') , (\'31215\') , (\'41972\') , (\'41963\') , (\'41284\') , (\'31289\') , (\'35682\') , (\'37920\') , (\'30072\') , (\'9926\') , (\'33996\') , (\'31288\') , (\'37786\') , (\'34803\') , (\'34802\') , (\'35688\') , (\'41519\') , (\'34191\') , (\'34194\') , (\'20422\') , (\'3355\') , (\'3356\') , (\'3358\') , (\'41589\') , (\'34268\') , (\'42103\') , (\'37126\') , (\'33791\') , (\'34192\') , (\'41495\') , (\'41274\') , (\'34193\') , (\'11158\') , (\'41498\') , (\'41331\') , (\'41590\') , (\'41332\') , (\'34190\') , (\'41984\') , (\'41734\') , (\'41291\') , (\'26125\') , (\'32439\') , (\'18268\') , (\'12515\') , (\'40688\') , (\'34170\') , (\'38563\') , (\'40497\') , (\'40689\') , (\'20871\') , (\'7756\') , (\'32448\') , (\'38482\') , (\'10035\') , (\'18397\') , (\'31578\') , (\'7525\') , (\'31581\') , (\'41908\') , (\'10061\') , (\'11121\') , (\'38908\') , (\'33790\') , (\'42102\') , (\'42101\') , (\'42097\') , (\'42099\') , (\'42098\') , (\'42107\') , (\'42104\') , (\'42106\') , (\'42100\') , (\'38889\') , (\'41232\') , (\'42028\') , (\'40228\') , (\'42075\') , (\'40103\') , (\'39892\') , (\'39893\') , (\'40227\') , (\'42077\') , (\'42078\') , (\'40118\') , (\'22055\') , (\'34004\') , (\'34001\') , (\'31252\') , (\'42084\') , (\'39889\') , (\'34009\') , (\'34000\') , (\'42085\') , (\'39888\') , (\'39891\') , (\'36284\') , (\'42076\') , (\'40226\') , (\'42086\') , (\'42087\') , (\'39890\') , (\'34006\') , (\'42018\') , (\'34003\') , (\'10673\') , (\'42120\') , (\'40904\') , (\'36354\') , (\'37085\') , (\'41347\') , (\'30892\') , (\'38598\') , (\'37643\') , (\'35679\') , (\'34834\') , (\'38568\') , (\'42105\') , (\'41365\') , (\'37644\') , (\'23145\') , (\'37114\') , (\'38887\') , (\'38590\') , (\'38589\') , (\'24807\') , (\'40514\') , (\'24809\') , (\'30625\') , (\'38044\') , (\'36528\') , (\'39435\') , (\'38586\') , (\'39403\') , (\'7772\') , (\'37337\') , (\'42014\') , (\'23863\') , (\'10766\') , (\'7066\') , (\'7067\') , (\'32852\') , (\'7472\') , (\'41345\') , (\'41257\') , (\'11712\') , (\'14387\') , (\'40535\') , (\'18176\') , (\'40135\') , (\'7065\') , (\'32851\') , (\'26513\') , (\'26514\') , (\'26516\') , (\'26515\') , (\'19831\') , (\'38969\') , (\'16405\') , (\'17572\') , (\'30293\') , (\'41779\') , (\'28830\') , (\'21345\') , (\'26991\') , (\'12222\') , (\'10646\') , (\'38888\') , (\'38886\') , (\'10057\') , (\'10614\') , (\'36150\') , (\'7704\') , (\'7706\') , (\'40549\') , (\'42012\') , (\'36276\') , (\'36418\') , (\'34717\') , (\'21730\') , (\'22060\') , (\'41971\') , (\'41905\') , (\'41903\') , (\'18457\') , (\'7711\') , (\'22868\') , (\'23500\') , (\'37773\') , (\'29227\') , (\'37775\') , (\'39981\') , (\'40658\') , (\'41953\') , (\'41909\') , (\'41965\') , (\'41947\') , (\'40668\') , (\'40863\') , (\'40663\') , (\'40661\') , (\'39928\') , (\'41020\') , (\'40350\') , (\'2\') , (\'42216\') , (\'38233\') , (\'38227\') , (\'38232\') , (\'38229\') , (\'41927\') , (\'37486\') , (\'37485\') , (\'37484\') , (\'41922\') , (\'39088\') , (\'37292\') , (\'7178\') , (\'34866\') , (\'32340\') , (\'21227\') , (\'42019\') , (\'23488\') , (\'40734\') , (\'23979\') , (\'21234\') , (\'33849\') , (\'15850\') , (\'23901\') , (\'40667\') , (\'40664\') , (\'40660\') , (\'40666\') , (\'40665\') , (\'40662\') , (\'40547\') , (\'38020\') , (\'36658\') , (\'41566\') , (\'13603\') , (\'39943\') , (\'41577\') , (\'13691\') , (\'38221\') , (\'36419\') , (\'30016\') , (\'36661\') , (\'39414\') , (\'36420\') , (\'17003\') , (\'36403\') , (\'23848\') , (\'9826\') , (\'9763\') , (\'36344\') , (\'41686\') , (\'36326\') , (\'41548\') , (\'31216\') , (\'31222\') , (\'6053\') , (\'38016\') , (\'34719\') , (\'34720\') , (\'40733\') , (\'36637\') , (\'36529\') , (\'40970\') , (\'36526\') , (\'40732\') , (\'40731\') , (\'31217\') , (\'41687\') , (\'41394\') , (\'41395\') , (\'41397\') , (\'17731\') , (\'41419\') , (\'41396\') , (\'26579\') , (\'41393\') , (\'17732\') , (\'6351\') , (\'42222\') , (\'42220\') , (\'31869\') , (\'28560\') , (\'40727\') , (\'13703\') , (\'41574\') , (\'41350\') , (\'41576\') , (\'41578\') , (\'41565\') , (\'41735\') , (\'41308\') , (\'36653\') , (\'38391\') , (\'32997\') , (\'29726\') , (\'34670\') , (\'34671\') , (\'34672\') , (\'41167\') , (\'41721\') , (\'34961\') , (\'41707\') , (\'41885\') , (\'41611\') , (\'40967\') , (\'41941\') , (\'41982\') , (\'41706\') , (\'41925\') , (\'41614\') , (\'41958\') , (\'41921\') , (\'41946\') , (\'41164\') , (\'41945\') , (\'41937\') , (\'41940\') , (\'41966\') , (\'41969\') , (\'41938\') , (\'41934\') , (\'41935\') , (\'41883\') , (\'41956\') , (\'41964\') , (\'41884\') , (\'41968\') , (\'41970\') , (\'41942\') , (\'41904\') , (\'41939\') , (\'41944\') , (\'41943\') , (\'41983\') , (\'41907\') , (\'41981\') , (\'41931\') , (\'41955\') , (\'41923\') , (\'41933\') , (\'41949\') , (\'41932\') , (\'41928\') , (\'41924\') ;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec132f2c3` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_olddate5a8cec132f2c3 values  (\'2018-01-18\') ;;DROP TABLE IF EXISTS producttemp_5a8cec1735756;;

    				DROP TABLE IF EXISTS product_null_5a8cec1735d9b;;

    				CREATE TEMPORARY TABLE product_null_5a8cec1735d9b  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec132f2bc` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec132f2c3` (
DROP TABLE IF EXISTS `producttemp_5a8cec1735756` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cec1735759` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cec132f2c3`,`tmp_tbl_oldprdt5a8cec132f2bc`,`tmp_tbl_5a8cec132f2ca`
DROP TABLE IF EXISTS `init_5a8cec1735784` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec182e2bb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec182e2bb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec183a993` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec183a993 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec183a993`,`tmp_non_replicate_shorttext_5a8cec182e2bb`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec186af1a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec186af1a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec186af1a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1aca779` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec1aca779 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1b2f36a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec1b2f36a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1b3fc1d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec1b3fc1d (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1b3fc1d`,`tmp_non_replicate_shorttext_5a8cec1b2f36a`
DROP TABLE IF EXISTS `initpd_5a8cec1735787` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1aca779`
DROP TABLE IF EXISTS `initialtablebycomp5a8cec1735aeb` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cec1735aed` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cec1735789` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cec1735d8d` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cec1735d90` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec1735d6c` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cec1735d90` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cec1735d8d` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cec1735784` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1f76c09` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec1f76c09 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec1f76c09`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec224b850` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec224b850 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec22550ed` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec22550ed (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec22550ed`,`tmp_non_replicate_shorttext_5a8cec224b850`
DROP TABLE IF EXISTS `_temptable25a8cec1735e33` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cec1735e37` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec254f75d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec254f75d (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec254f75d`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec266a02a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec266a02a (INDEX(st_id))

CREATE TEMPORARY TABLE tmp_non_replicate_price_category_5a8cec267f307 (INDEX(list_id))

CREATE TEMPORARY TABLE tmp_non_replicate_product_5a8cec267f30a (INDEX(prdt_no))

CREATE TEMPORARY TABLE tmp_non_replicate_join_5a8cec267f30c (INDEX(list_id,prdt_no))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_join_5a8cec267f30c`,`tmp_non_replicate_product_5a8cec267f30a`,`tmp_non_replicate_price_category_5a8cec267f307`,`tmp_non_replicate_shorttext_5a8cec266a02a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec362be29` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec362be29 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_assem5a8cec36a31ea` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `temp_assem5a8cec36a31ea`,`tmp_non_replicate_shorttext_5a8cec362be29`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec36efc7f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec36efc7f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec36efc7f`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec37b8077` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec37b8077 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec37b8077`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec38562aa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec38562aa (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec38562aa`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3ab8ef7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec3ab8ef7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3ac245f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec3ac245f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3ac245f`,`tmp_non_replicate_shorttext_5a8cec3ab8ef7`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3d08583` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec3d08583 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3d1102b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec3d1102b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec3d1102b`,`tmp_non_replicate_shorttext_5a8cec3d08583`
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cec1735e39` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cec1735d6c` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec1735e9a` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec1735d96` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec55dfce5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec55dfce5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec55e9c2d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec55e9c2d (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec55e9c2d`,`tmp_non_replicate_shorttext_5a8cec55dfce5`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec575e373` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec575e373 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec57671ca` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec57671ca (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec57671ca`,`tmp_non_replicate_shorttext_5a8cec575e373`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5b4933a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5b4933a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5b4933a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5b7c58c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5b7c58c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5b7c58c`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5bcaddb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5bcaddb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5e15d3a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5e15d3a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5e1fb07` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5e1fb07 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5e1fb07`,`tmp_non_replicate_shorttext_5a8cec5e15d3a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5eef8a6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5eef8a6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5f0573a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec5f0573a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec5f0573a`,`tmp_non_replicate_shorttext_5a8cec5eef8a6`
DROP TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8cec60b7351` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8cec60b7351 (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60c262b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60c262b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60c5540` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60c5540 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60c7341` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60c7341 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60c905b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60c905b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60cac7b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60cac7b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60ccd97` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60ccd97 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60ce868` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60ce868 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60d092a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60d092a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60d284d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60d284d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60d4c1a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60d4c1a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8cec60db3ce` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8cec60db3ce (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u115=/ver5.08.03/merchandising/merc_price_checker.php=pasarayaahboy*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60e9f67` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60e9f67 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60ec2c8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60ec2c8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60ee960` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60ee960 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec60f35ec` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec60f35ec (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6105d21` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6105d21 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6108cfe` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6108cfe (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec610a76f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec610a76f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec610cb60` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec610cb60 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec610eee6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec610eee6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6111740` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6111740 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6112da7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6112da7 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6112da7`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6111740`,`tmp_non_replicate_shorttext_5a8cec610eee6`,`tmp_non_replicate_shorttext_5a8cec610cb60`,`tmp_non_replicate_shorttext_5a8cec610a76f`,`tmp_non_replicate_shorttext_5a8cec6108cfe`,`tmp_non_replicate_shorttext_5a8cec6105d21`,`tmp_non_replicate_shorttext_5a8cec60f35ec`,`tmp_non_replicate_shorttext_5a8cec60ee960`,`tmp_non_replicate_shorttext_5a8cec60ec2c8`,`tmp_non_replicate_shorttext_5a8cec60e9f67`,`tmp_non_replicate_5a8cec60db3ce`,`temp_lvl_1`,`temp_lvl_2`,`temp_lvl_3`,`temp_lvl_4`,`temp_lvl_5`,`temp_lvl_6`,`temp_lvl_7`,`tmp_non_replicate_shorttext_5a8cec60d4c1a`,`tmp_non_replicate_shorttext_5a8cec60d284d`,`tmp_non_replicate_shorttext_5a8cec60d092a`,`tmp_non_replicate_shorttext_5a8cec60ce868`,`tmp_non_replicate_shorttext_5a8cec60ccd97`,`tmp_non_replicate_shorttext_5a8cec60cac7b`,`tmp_non_replicate_shorttext_5a8cec60c905b`,`tmp_non_replicate_shorttext_5a8cec60c7341`,`tmp_non_replicate_shorttext_5a8cec60c5540`,`tmp_non_replicate_shorttext_5a8cec60c262b`,`tmp_non_replicate_5a8cec60b7351`,`tmp_non_replicate_shorttext_5a8cec5bcaddb`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec615df35` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec61619b9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec615df35 (INDEX(st_id))

CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec61619b9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6166d42` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6166d42 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6166d42`,`tmp_non_replicate_shorttext_5a8cec615df35`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec61619b9`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec62dfc95` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec62dfc95 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec62e838b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec62e838b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec62e838b`,`tmp_non_replicate_shorttext_5a8cec62dfc95`
DROP TABLE IF EXISTS `latest_5a8cec1735e9d` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec1735d96` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6a97d58` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6a97d58 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6aa210a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6aa210a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6aa210a`,`tmp_non_replicate_shorttext_5a8cec6a97d58`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6bee528` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6bee528 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cec6c28be0` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d11997` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d11997 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d197c5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d197c5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d1e72f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d1e72f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d22141` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d22141 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d25477` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d25477 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d28772` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d28772 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d2b0e0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d2b0e0 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d2d9bb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d2d9bb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d3053b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d3053b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d33289` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d33289 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d3655d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d3655d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d39275` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d39275 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d3bbb9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec6d3bbb9 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec6d3bbb9`,`tmp_non_replicate_shorttext_5a8cec6d39275`,`tmp_non_replicate_shorttext_5a8cec6d3655d`,`tmp_non_replicate_shorttext_5a8cec6d33289`,`tmp_non_replicate_shorttext_5a8cec6d3053b`,`tmp_non_replicate_shorttext_5a8cec6d2d9bb`,`tmp_non_replicate_shorttext_5a8cec6d2b0e0`,`tmp_non_replicate_shorttext_5a8cec6d28772`,`tmp_non_replicate_shorttext_5a8cec6d25477`,`tmp_non_replicate_shorttext_5a8cec6d22141`,`tmp_non_replicate_shorttext_5a8cec6d1e72f`,`tmp_non_replicate_shorttext_5a8cec6d197c5`,`tmp_non_replicate_shorttext_5a8cec6d11997`,`temp_5a8cec6c28be0`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cec6bee528`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec7071da6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec7071da6 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec7071da6`
DROP TABLE IF EXISTS `latest2_5a8cec1735d98` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec1735d9d` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cec1735d9b` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cec1735d9b  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cec1733821` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec1735d96` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl_5a8cec73c0c99` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cec73c0c99 SELECT * FROM bill_detail where dt_transno=42892 and dt_type1='SN' and dt_type2='DN' and dt_transeqno>0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cec73c0c8e 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec75efd99` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec75efd99 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cec75efd99`
DROP TABLE IF EXISTS `tmp_tbl_5a8cec84e6358` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cec84e6358 SELECT * FROM bill_detail where dt_transno=92581 and dt_type1='SN' and dt_type2='RN' and dt_transeqno>0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cec84e634c 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec859e2f6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec859e2f6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec85a791a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec85a791a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cec1735d98` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec85a791a`,`tmp_non_replicate_shorttext_5a8cec859e2f6`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec880e8a9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec880e8a9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8817e74` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8817e74 (INDEX(st_id))

DROP TABLE IF EXISTS `totalproduct_5a8cec881e3d7` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec881e3fb` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec881ea9e` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec881e9c8` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec881eaa1` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cec881e9ca` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec881e9d1` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cec881e894` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cec881e896` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cec881e898` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cec881e89a` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cec881e89d` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cec881e89b` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec881e9a2` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec84e634c` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_oldprdt5a8cec84e634c values  (\'42122\') , (\'42123\') , (\'42124\') , (\'42125\') , (\'42126\') , (\'42127\') , (\'42128\') , (\'42129\') , (\'42130\') , (\'42131\') , (\'42153\') , (\'42154\') , (\'42155\') , (\'42156\') , (\'42157\') , (\'42158\') ;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec84e6352` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_olddate5a8cec84e6352 values  (\'2018-02-01\') ;;DROP TABLE IF EXISTS producttemp_5a8cec881e3d4;;

    				DROP TABLE IF EXISTS product_null_5a8cec881e9cf;;

    				CREATE TEMPORARY TABLE product_null_5a8cec881e9cf  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec84e634c` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec84e6352` (
DROP TABLE IF EXISTS `producttemp_5a8cec881e3d4` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cec1735d9d` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cec881e3d7` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec881e3fb` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8817e74`,`tmp_non_replicate_shorttext_5a8cec880e8a9`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cec84e6352`,`tmp_tbl_oldprdt5a8cec84e634c`,`tmp_tbl_5a8cec84e6358`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec88b3169` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec88b3169 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec88c59ed` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec88c59ed (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec88c59ed`,`tmp_non_replicate_shorttext_5a8cec88b3169`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec890b258` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec890b258 (INDEX(st_id))

DROP TABLE IF EXISTS `totalproduct_5a8cec89573ba` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec89573df` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec8957aac` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec89579c0` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec8957aaf` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cec89579c2` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec89579c8` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cec8957888` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cec895788b` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cec895788d` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cec895788f` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cec8957892` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cec8957890` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec8957999` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec73c0c8e` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_oldprdt5a8cec73c0c8e values  (\'42624\') , (\'42625\') , (\'42626\') , (\'32763\') , (\'21730\') , (\'36418\') , (\'19833\') , (\'19832\') , (\'7798\') , (\'31038\') , (\'31039\') , (\'26990\') , (\'26991\') , (\'36276\') , (\'37010\') , (\'39789\') , (\'42078\') , (\'6047\') , (\'6039\') , (\'6053\') , (\'6036\') , (\'34001\') , (\'6032\') , (\'38250\') , (\'36284\') , (\'42084\') , (\'42086\') , (\'42085\') , (\'37386\') , (\'38249\') , (\'41148\') , (\'41149\') , (\'33422\') , (\'35444\') , (\'40690\') , (\'41871\') , (\'39427\') , (\'35138\') , (\'7756\') , (\'20871\') , (\'36233\') , (\'38892\') , (\'38880\') , (\'41942\') , (\'41741\') , (\'36312\') , (\'36313\') , (\'38356\') , (\'41498\') , (\'38881\') , (\'23145\') , (\'38193\') , (\'38283\') , (\'39414\') , (\'23134\') , (\'30892\') , (\'36653\') , (\'42518\') , (\'42504\') , (\'42362\') , (\'42364\') , (\'42398\') , (\'42388\') , (\'38941\') , (\'38884\') , (\'42344\') , (\'42410\') , (\'42392\') , (\'36665\') , (\'42399\') , (\'34521\') , (\'42414\') , (\'42368\') , (\'42372\') , (\'42319\') , (\'42341\') , (\'42439\') , (\'42411\') , (\'42403\') , (\'38891\') , (\'42407\') , (\'42416\') , (\'37337\') , (\'42395\') , (\'42400\') , (\'38937\') , (\'39750\') , (\'41249\') , (\'42391\') , (\'42393\') , (\'42464\') , (\'42466\') , (\'42448\') , (\'42449\') , (\'42457\') , (\'42458\') , (\'42459\') , (\'42463\') , (\'42467\') , (\'42461\') , (\'42460\') , (\'42465\') , (\'42462\') , (\'41921\') , (\'33742\') , (\'34719\') , (\'13374\') , (\'42529\') , (\'42517\') , (\'42527\') , (\'42528\') , (\'42521\') , (\'39436\') , (\'41934\') , (\'33739\') , (\'33740\') , (\'17050\') , (\'29345\') , (\'38305\') , (\'42531\') , (\'38304\') , (\'34299\') , (\'41547\') , (\'41331\') , (\'33741\') , (\'42061\') , (\'42533\') , (\'42524\') , (\'34193\') , (\'41721\') , (\'38308\') , (\'42526\') , (\'42532\') , (\'42511\') , (\'42510\') , (\'42505\') , (\'42506\') , (\'42530\') , (\'38309\') , (\'38306\') , (\'42514\') , (\'41624\') , (\'34190\') , (\'35311\') , (\'41903\') , (\'39019\') , (\'41905\') , (\'40599\') , (\'40597\') , (\'35313\') , (\'41236\') , (\'41237\') , (\'36909\') , (\'38888\') , (\'40596\') , (\'37115\') , (\'41927\') , (\'42523\') , (\'39889\') , (\'41947\') , (\'31670\') , (\'24110\') , (\'37091\') , (\'39437\') , (\'41931\') , (\'32506\') , (\'42507\') , (\'38307\') , (\'42515\') , (\'41614\') , (\'39438\') , (\'31225\') , (\'41972\') , (\'32787\') , (\'38814\') , (\'38812\') , (\'38627\') , (\'41695\') , (\'38327\') , (\'34695\') , (\'41708\') , (\'41696\') , (\'41699\') , (\'34672\') , (\'38624\') , (\'42509\') , (\'42501\') , (\'42503\') , (\'42500\') , (\'42508\') , (\'42513\') , (\'7715\') , (\'15850\') , (\'40666\') , (\'40863\') , (\'40665\') , (\'40668\') , (\'40663\') , (\'40658\') , (\'7712\') , (\'19264\') , (\'23208\') , (\'42088\') , (\'36319\') , (\'36308\') , (\'36310\') , (\'41480\') , (\'36314\') , (\'42519\') , (\'37607\') , (\'36952\') , (\'36328\') , (\'36957\') , (\'36302\') , (\'42404\') , (\'42389\') , (\'42405\') , (\'36942\') , (\'37640\') , (\'36941\') ;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec73c0c94` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_olddate5a8cec73c0c94 values  (\'2018-02-21\') ;;DROP TABLE IF EXISTS producttemp_5a8cec89573b7;;

    				DROP TABLE IF EXISTS product_null_5a8cec89579c6;;

    				CREATE TEMPORARY TABLE product_null_5a8cec89579c6  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cec73c0c8e` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cec73c0c94` (
DROP TABLE IF EXISTS `producttemp_5a8cec89573b7` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cec89573ba` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cec89573df` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec890b258`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8a774b7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8a774b7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8a8140f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8a8140f (INDEX(st_id))

DROP TABLE IF EXISTS `initpd_5a8cec881e3fd` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cec881e74c` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cec881e74f` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cec881e3ff` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cec881e9c2` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8a8140f`,`tmp_non_replicate_shorttext_5a8cec8a774b7`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cec73c0c94`,`tmp_tbl_oldprdt5a8cec73c0c8e`,`tmp_tbl_5a8cec73c0c99`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8bc7278` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8cec89573e1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8bc7278 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8bd6ae5` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cec8957723` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8bd6ae5 (INDEX(st_id))

DROP TABLE IF EXISTS `initialtablebycomp25a8cec8957726` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8bd6ae5`,`tmp_non_replicate_shorttext_5a8cec8bc7278`
DROP TABLE IF EXISTS `initv_5a8cec89573e3` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cec89579b8` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cec881e9c3` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec881e9a2` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cec881e9c3` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cec881e9c2` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cec881e3fb` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8cac724` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8cac724 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8cb7980` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8cb7980 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8cb7980`,`tmp_non_replicate_shorttext_5a8cec8cac724`
DROP TABLE IF EXISTS `init_balstoreorder5a8cec89579ba` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cec8957999` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cec89579ba` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cec89579b8` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8f74567` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec8f74567 (INDEX(st_id))

DROP TABLE IF EXISTS `_temptable25a8cec881ea47` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cec881ea4b` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cec89573df` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cec881ea4c` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cec881e9a2` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cec1735d9d`,`latest2_5a8cec1735d98`,`update_price_5a8cec1735d96`,`lastest_bal_5a8cec1733821`,`product_null_5a8cec1735d9b`,`latest_5a8cec1735e9d`,`bal_cost_5a8cec1735e9a`,`final_5a8cec1735d6c`,`tmp_latest_bal_bal_5a8cec1735e39`,`tmp_latest_bal_date_5a8cec1735e37`,`_temptable25a8cec1735e33`,`init_5a8cec1735784`,`initv_5a8cec1735789`,`initialtablebycomp25a8cec1735aed`,`initialtablebycomp5a8cec1735aeb`,`initpd_5a8cec1735787`,`totalproduct_5a8cec1735759`,`producttemp_5a8cec1735756`,`tmp_tbl_olddate5a8cec132f2c3`,`tmp_tbl_oldprdt5a8cec132f2bc`
DROP TABLE IF EXISTS `_temptable25a8cec8957a4e` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cec881ea9e` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cec8957a52` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec881e9c8` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec8f74567`
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cec8957a53` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cec8957999` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9136cea` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9136cea (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9136cea`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9180906` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9180906 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9180906`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec932d6f9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec932d6f9 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cec935fff1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec98f3cff` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec98f3cff (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cec9935c3b` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a096c3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a096c3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a0ce69` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a0ce69 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a10a7a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a10a7a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a141c5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a141c5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a17ffe` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a17ffe (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a1caf7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a1caf7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a204d6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a204d6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a24f36` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a24f36 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a2954d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a2954d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a2d46d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a2d46d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a30c54` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a30c54 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a33d6f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a33d6f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a36f1c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9a36f1c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9a36f1c`,`tmp_non_replicate_shorttext_5a8cec9a33d6f`,`tmp_non_replicate_shorttext_5a8cec9a30c54`,`tmp_non_replicate_shorttext_5a8cec9a2d46d`,`tmp_non_replicate_shorttext_5a8cec9a2954d`,`tmp_non_replicate_shorttext_5a8cec9a24f36`,`tmp_non_replicate_shorttext_5a8cec9a204d6`,`tmp_non_replicate_shorttext_5a8cec9a1caf7`,`tmp_non_replicate_shorttext_5a8cec9a17ffe`,`tmp_non_replicate_shorttext_5a8cec9a141c5`,`tmp_non_replicate_shorttext_5a8cec9a10a7a`,`tmp_non_replicate_shorttext_5a8cec9a0ce69`,`tmp_non_replicate_shorttext_5a8cec9a096c3`,`temp_5a8cec9935c3b`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cec98f3cff`
DROP TABLE IF EXISTS `latest_5a8cec881eaa1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec881e9c8` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d01b53` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d01b53 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d0480d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d0480d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d0763b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d0763b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d0a0ce` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d0a0ce (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d0cd04` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d0cd04 (INDEX(st_id))

DROP TABLE IF EXISTS `bal_cost_5a8cec8957aac` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d10a1e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d10a1e (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d14149` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d14149 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d1886d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d1886d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d1c857` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d1c857 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d1f182` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d1f182 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d239cf` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d239cf (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d284ab` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d284ab (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d2be00` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cec9d2be00 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cec9d2be00`,`tmp_non_replicate_shorttext_5a8cec9d284ab`,`tmp_non_replicate_shorttext_5a8cec9d239cf`,`tmp_non_replicate_shorttext_5a8cec9d1f182`,`tmp_non_replicate_shorttext_5a8cec9d1c857`,`tmp_non_replicate_shorttext_5a8cec9d1886d`,`tmp_non_replicate_shorttext_5a8cec9d14149`,`tmp_non_replicate_shorttext_5a8cec9d10a1e`,`tmp_non_replicate_shorttext_5a8cec9d0cd04`,`tmp_non_replicate_shorttext_5a8cec9d0a0ce`,`tmp_non_replicate_shorttext_5a8cec9d0763b`,`tmp_non_replicate_shorttext_5a8cec9d0480d`,`tmp_non_replicate_shorttext_5a8cec9d01b53`,`temp_5a8cec935fff1`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cec932d6f9`
DROP TABLE IF EXISTS `latest2_5a8cec881e9ca` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec881e9d1` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cec881e9cf` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cec881e9cf  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cec881c8bb` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec881e9c8` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cec89579c0` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cec8957aaf` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl_5a8cecb30cff3` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cecb30cff3 SELECT * FROM bill_detail where dt_transno=92572 and dt_type1='SN' and dt_type2='RN' and dt_transeqno>0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cecb30cfe6 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u367=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cec881e9ca` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cec881e9d1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec89579c0` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cec881e9d1`,`latest2_5a8cec881e9ca`,`update_price_5a8cec881e9c8`,`lastest_bal_5a8cec881c8bb`,`product_null_5a8cec881e9cf`,`latest_5a8cec881eaa1`,`bal_cost_5a8cec881ea9e`,`final_5a8cec881e9a2`,`tmp_latest_bal_bal_5a8cec881ea4c`,`tmp_latest_bal_date_5a8cec881ea4b`,`_temptable25a8cec881ea47`,`init_5a8cec881e3fb`,`initv_5a8cec881e3ff`,`initialtablebycomp25a8cec881e74f`,`initialtablebycomp5a8cec881e74c`,`initpd_5a8cec881e3fd`,`totalproduct_5a8cec881e3d7`,`producttemp_5a8cec881e3d4`,`tmp_tbl_olddate5a8cec84e6352`,`tmp_tbl_oldprdt5a8cec84e634c`
DROP TABLE IF EXISTS `latest2_5a8cec89579c2` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cec89579c8` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cec89579c6` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cec89579c6  (INDEX (prdt_null))

DROP TABLE IF EXISTS `totalproduct_5a8cecb634647` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cecb634669` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cecb634d99` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cecb634cc3` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cecb634d9c` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cecb634cc5` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cecb634ccb` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cecb634b86` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cecb634b89` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cecb634b8a` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cecb634b8c` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cecb634b90` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cecb634b8e` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cecb634c9c` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cecb30cfe6` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_oldprdt5a8cecb30cfe6 values  (\'42122\') , (\'42123\') , (\'42124\') , (\'42125\') , (\'42126\') , (\'42127\') , (\'42128\') , (\'41914\') , (\'42130\') , (\'42131\') , (\'42153\') , (\'42154\') , (\'42155\') , (\'42156\') , (\'42157\') , (\'42158\') ;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cecb30cfed` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_olddate5a8cecb30cfed values  (\'2018-02-01\') ;;DROP TABLE IF EXISTS producttemp_5a8cecb634644;;

    				DROP TABLE IF EXISTS product_null_5a8cecb634cc9;;

    				CREATE TEMPORARY TABLE product_null_5a8cecb634cc9  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cecb30cfe6` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cecb30cfed` (
DROP TABLE IF EXISTS `producttemp_5a8cecb634644` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cecb30cfed`,`tmp_tbl_oldprdt5a8cecb30cfe6`,`tmp_tbl_5a8cecb30cff3`
DROP TABLE IF EXISTS `totalproduct_5a8cecb634647` /* generated by server */
DROP TABLE IF EXISTS `lastest_bal_5a8cec8955642` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cecb634669` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cec89579c0` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecb69bb7f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecb69bb7f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecb6a6975` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecb6a6975 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecb6a6975`,`tmp_non_replicate_shorttext_5a8cecb69bb7f`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecb6d1bf0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecb6d1bf0 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cec89579c2` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cec89579c8` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cec89579c8`,`latest2_5a8cec89579c2`,`update_price_5a8cec89579c0`,`lastest_bal_5a8cec8955642`,`product_null_5a8cec89579c6`,`latest_5a8cec8957aaf`,`bal_cost_5a8cec8957aac`,`final_5a8cec8957999`,`tmp_latest_bal_bal_5a8cec8957a53`,`tmp_latest_bal_date_5a8cec8957a52`,`_temptable25a8cec8957a4e`,`init_5a8cec89573df`,`initv_5a8cec89573e3`,`initialtablebycomp25a8cec8957726`,`initialtablebycomp5a8cec8957723`,`initpd_5a8cec89573e1`,`totalproduct_5a8cec89573ba`,`producttemp_5a8cec89573b7`,`tmp_tbl_olddate5a8cec73c0c94`,`tmp_tbl_oldprdt5a8cec73c0c8e`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecb6d1bf0`
DROP TABLE IF EXISTS `initpd_5a8cecb63466b` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cecb634a3c` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cecb634a3e` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cecb63466d` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cecb634cbc` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cecb634cbe` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cecb634c9c` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cecb634cbe` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cecb634cbc` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cecb634669` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8cecb634d43` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cecb634d47` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cecb634d48` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cecb634c9c` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cecb634d99` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cecb634cc3` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbd57c84` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbd57c84 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbd6193a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbd6193a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbd6193a`,`tmp_non_replicate_shorttext_5a8cecbd57c84`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbe8fab7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbe8fab7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbe99a92` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbe99a92 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbe99a92`,`tmp_non_replicate_shorttext_5a8cecbe8fab7`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbf93c05` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbf93c05 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbf9cef4` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecbf9cef4 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecbf9cef4`,`tmp_non_replicate_shorttext_5a8cecbf93c05`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc06a32c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc06a32c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc0743cd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc0743cd (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc0743cd`,`tmp_non_replicate_shorttext_5a8cecc06a32c`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc335e53` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc335e53 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc34003b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc34003b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc34003b`,`tmp_non_replicate_shorttext_5a8cecc335e53`
DROP TABLE IF EXISTS `latest_5a8cecb634d9c` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cecb634cc3` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc56e849` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc56e849 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc57843f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc57843f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc57843f`,`tmp_non_replicate_shorttext_5a8cecc56e849`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc79dd0b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc79dd0b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc7a75ac` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc7a75ac (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc7a75ac`,`tmp_non_replicate_shorttext_5a8cecc79dd0b`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc86a9d7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc86a9d7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc874683` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc874683 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc874683`,`tmp_non_replicate_shorttext_5a8cecc86a9d7`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc93b220` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc93b220 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc94463b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecc94463b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecc94463b`,`tmp_non_replicate_shorttext_5a8cecc93b220`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccb0d76f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceccb0d76f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccb16bdb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceccb16bdb (INDEX(st_id))

DROP TABLE IF EXISTS `latest2_5a8cecb634cc5` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cecb634ccb` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cecb634cc9` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cecb634cc9  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cecb633400` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccb16bdb`,`tmp_non_replicate_shorttext_5a8ceccb0d76f`
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cecb634cc3` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccd15200` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceccd15200 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccd15200`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccd6c2e5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceccd6c2e5 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceccd6c2e5`
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cecb634cc5` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cecb634ccb` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cecb634ccb`,`latest2_5a8cecb634cc5`,`update_price_5a8cecb634cc3`,`lastest_bal_5a8cecb633400`,`product_null_5a8cecb634cc9`,`latest_5a8cecb634d9c`,`bal_cost_5a8cecb634d99`,`final_5a8cecb634c9c`,`tmp_latest_bal_bal_5a8cecb634d48`,`tmp_latest_bal_date_5a8cecb634d47`,`_temptable25a8cecb634d43`,`init_5a8cecb634669`,`initv_5a8cecb63466d`,`initialtablebycomp25a8cecb634a3e`,`initialtablebycomp5a8cecb634a3c`,`initpd_5a8cecb63466b`,`totalproduct_5a8cecb634647`,`producttemp_5a8cecb634644`,`tmp_tbl_olddate5a8cecb30cfed`,`tmp_tbl_oldprdt5a8cecb30cfe6`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecdc986e1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecdc986e1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecdca1e86` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecdca1e86 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecdca1e86`,`tmp_non_replicate_shorttext_5a8cecdc986e1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecdfbfc64` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecdfbfc64 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecdfbfc64`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfc2651d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecfc2651d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfc2ff58` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecfc2ff58 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfc2ff58`,`tmp_non_replicate_shorttext_5a8cecfc2651d`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfcd17e1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecfcd17e1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfcdb67f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecfcdb67f (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecfcdb67f`,`tmp_non_replicate_shorttext_5a8cecfcd17e1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecff064f1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecff064f1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecff106b0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cecff106b0 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cecff106b0`,`tmp_non_replicate_shorttext_5a8cecff064f1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced00a61cb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced00a61cb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced00afa72` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced00afa72 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced00afa72`,`tmp_non_replicate_shorttext_5a8ced00a61cb`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced23a02f2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced23a02f2 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced23a02f2`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced23e0e4d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced23e0e4d (INDEX(st_id))

DROP TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8ced2985f05` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8ced2985f05 (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29941d2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29941d2 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced2999048` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced2999048 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced299c9ac` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced299c9ac (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced299fcac` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced299fcac (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29a2ae6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29a2ae6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29a69f3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29a69f3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29aa3b5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29aa3b5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29ad83c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29ad83c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29b07a2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29b07a2 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29b3fc6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29b3fc6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8ced29bcc1d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8ced29bcc1d (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29cc682` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29cc682 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29d79fe` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29d79fe (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29e015a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29e015a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29e276f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29e276f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29e5a49` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29e5a49 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29e94b3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29e94b3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29ec518` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29ec518 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29ef9f4` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29ef9f4 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced29f2948` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced29f2948 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced2a02404` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced2a02404 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced2a02404`,`tmp_non_replicate_shorttext_5a8ced29f2948`,`tmp_non_replicate_shorttext_5a8ced29ef9f4`,`tmp_non_replicate_shorttext_5a8ced29ec518`,`tmp_non_replicate_shorttext_5a8ced29e94b3`,`tmp_non_replicate_shorttext_5a8ced29e5a49`,`tmp_non_replicate_shorttext_5a8ced29e276f`,`tmp_non_replicate_shorttext_5a8ced29e015a`,`tmp_non_replicate_shorttext_5a8ced29d79fe`,`tmp_non_replicate_shorttext_5a8ced29cc682`,`tmp_non_replicate_5a8ced29bcc1d`,`temp_lvl_1`,`temp_lvl_2`,`temp_lvl_3`,`temp_lvl_4`,`temp_lvl_5`,`temp_lvl_6`,`temp_lvl_7`,`tmp_non_replicate_shorttext_5a8ced29b3fc6`,`tmp_non_replicate_shorttext_5a8ced29b07a2`,`tmp_non_replicate_shorttext_5a8ced29ad83c`,`tmp_non_replicate_shorttext_5a8ced29aa3b5`,`tmp_non_replicate_shorttext_5a8ced29a69f3`,`tmp_non_replicate_shorttext_5a8ced29a2ae6`,`tmp_non_replicate_shorttext_5a8ced299fcac`,`tmp_non_replicate_shorttext_5a8ced299c9ac`,`tmp_non_replicate_shorttext_5a8ced2999048`,`tmp_non_replicate_shorttext_5a8ced29941d2`,`tmp_non_replicate_5a8ced2985f05`,`tmp_non_replicate_shorttext_5a8ced23e0e4d`
DROP TABLE IF EXISTS `tmp_targetglobalsetting`,`tmp_sourceglobalsetting`,`tmp_finalglobalsetting` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_finalglobalsetting`,`tmp_sourceglobalsetting`,`tmp_targetglobalsetting`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced38222fa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced38222fa (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8ced385d894` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3910c8e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3910c8e (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced391de59` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced391de59 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced391de59`,`tmp_non_replicate_shorttext_5a8ced3910c8e`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced394bd9b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced394bd9b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced394bd9b`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced39a8dd4` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced39a8dd4 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced39a8dd4`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced39cfbd7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced39cfbd7 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced39cfbd7`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3db6468` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3db6468 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dbace3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dbace3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dbf135` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dbf135 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dc1de3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dc1de3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dc4e2a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dc4e2a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dc83de` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dc83de (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dcb06d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dcb06d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dd882a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dd882a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3ddb563` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3ddb563 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3dde7a6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3dde7a6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3de2077` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3de2077 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3de6038` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3de6038 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3de98f9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced3de98f9 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced3de98f9`,`tmp_non_replicate_shorttext_5a8ced3de6038`,`tmp_non_replicate_shorttext_5a8ced3de2077`,`tmp_non_replicate_shorttext_5a8ced3dde7a6`,`tmp_non_replicate_shorttext_5a8ced3ddb563`,`tmp_non_replicate_shorttext_5a8ced3dd882a`,`tmp_non_replicate_shorttext_5a8ced3dcb06d`,`tmp_non_replicate_shorttext_5a8ced3dc83de`,`tmp_non_replicate_shorttext_5a8ced3dc4e2a`,`tmp_non_replicate_shorttext_5a8ced3dc1de3`,`tmp_non_replicate_shorttext_5a8ced3dbf135`,`tmp_non_replicate_shorttext_5a8ced3dbace3`,`tmp_non_replicate_shorttext_5a8ced3db6468`,`temp_5a8ced385d894`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8ced38222fa`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4122c41` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced4122c41 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4139e0c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced4139e0c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4139e0c`,`tmp_non_replicate_shorttext_5a8ced4122c41`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4996df7` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced4996df7 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced49ae084` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced49ae084 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced49ae084`,`tmp_non_replicate_shorttext_5a8ced4996df7`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4e2fd95` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced4e2fd95 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4e2fd95`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced4e6c104` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced4e6c104 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8ced53c5aa5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8ced53c5aa5 (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53d3d36` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53d3d36 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53d8629` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53d8629 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53dc724` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53dc724 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53e09d3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53e09d3 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53e3e9a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53e3e9a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53e7910` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53e7910 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53ea6eb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53ea6eb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53ed38f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53ed38f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53f0706` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53f0706 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced53f38f2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced53f38f2 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8ced5407999` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8ced5407999 (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u469=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5417abd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5417abd (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5422193` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5422193 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced542adad` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced542adad (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced542deef` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced542deef (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5432204` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5432204 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5434ad5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5434ad5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5437779` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5437779 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced543b479` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced543b479 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced543ee51` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced543ee51 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5441fbc` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced5441fbc (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced5441fbc`,`tmp_non_replicate_shorttext_5a8ced543ee51`,`tmp_non_replicate_shorttext_5a8ced543b479`,`tmp_non_replicate_shorttext_5a8ced5437779`,`tmp_non_replicate_shorttext_5a8ced5434ad5`,`tmp_non_replicate_shorttext_5a8ced5432204`,`tmp_non_replicate_shorttext_5a8ced542deef`,`tmp_non_replicate_shorttext_5a8ced542adad`,`tmp_non_replicate_shorttext_5a8ced5422193`,`tmp_non_replicate_shorttext_5a8ced5417abd`,`tmp_non_replicate_5a8ced5407999`,`temp_lvl_1`,`temp_lvl_2`,`temp_lvl_3`,`temp_lvl_4`,`temp_lvl_5`,`temp_lvl_6`,`temp_lvl_7`,`tmp_non_replicate_shorttext_5a8ced53f38f2`,`tmp_non_replicate_shorttext_5a8ced53f0706`,`tmp_non_replicate_shorttext_5a8ced53ed38f`,`tmp_non_replicate_shorttext_5a8ced53ea6eb`,`tmp_non_replicate_shorttext_5a8ced53e7910`,`tmp_non_replicate_shorttext_5a8ced53e3e9a`,`tmp_non_replicate_shorttext_5a8ced53e09d3`,`tmp_non_replicate_shorttext_5a8ced53dc724`,`tmp_non_replicate_shorttext_5a8ced53d8629`,`tmp_non_replicate_shorttext_5a8ced53d3d36`,`tmp_non_replicate_5a8ced53c5aa5`,`tmp_non_replicate_shorttext_5a8ced4e6c104`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced591a842` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced591a842 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced591a842`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced596a528` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced596a528 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced596a528`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced7d4028a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced7d4028a (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced7d49e8b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced7d49e8b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced7d49e8b`,`tmp_non_replicate_shorttext_5a8ced7d4028a`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced813a325` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced813a325 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced813a325`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced8ae30d9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ced8ae30d9 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ced8ae30d9`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb2de14c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb2de14c (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb2de14c`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb32e918` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb32e918 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8cedb901d03` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8cedb901d03 (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb910f83` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb910f83 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb915c31` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb915c31 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb91992d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb91992d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb91c74c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb91c74c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb91fab9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb91fab9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb923d2e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb923d2e (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb92753b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb92753b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb92b468` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb92b468 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb92f2aa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb92f2aa (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb932cdb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedb932cdb (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedb932cdb`,`tmp_non_replicate_shorttext_5a8cedb92f2aa`,`tmp_non_replicate_shorttext_5a8cedb92b468`,`tmp_non_replicate_shorttext_5a8cedb92753b`,`tmp_non_replicate_shorttext_5a8cedb923d2e`,`tmp_non_replicate_shorttext_5a8cedb91fab9`,`tmp_non_replicate_shorttext_5a8cedb91c74c`,`tmp_non_replicate_shorttext_5a8cedb91992d`,`tmp_non_replicate_shorttext_5a8cedb915c31`,`tmp_non_replicate_shorttext_5a8cedb910f83`,`tmp_non_replicate_5a8cedb901d03`,`temp_lvl_1`,`temp_lvl_2`,`temp_lvl_3`,`temp_lvl_4`,`temp_lvl_5`,`temp_lvl_6`,`temp_lvl_7`,`tmp_non_replicate_shorttext_5a8cedb32e918`
DROP TABLE IF EXISTS `tmp_tbl_5a8cedc011098` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cedc011098 SELECT * FROM bill_detail where dt_transno=93519 and dt_type1='SN' and dt_type2='RN' and dt_transeqno>0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cedc01108c 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cedc0c06d3` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cedc0c06fb` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cedc0c0e69` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cedc0c0d81` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cedc0c0e6c` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cedc0c0d83` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cedc0c0d8a` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cedc0c0c2a` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cedc0c0c2d` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cedc0c0c2e` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cedc0c0c30` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cedc0c0c34` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cedc0c0c32` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cedc0c0d59` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cedc01108c` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cedc011093` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;DROP TABLE IF EXISTS producttemp_5a8cedc0c06cf;;

    				DROP TABLE IF EXISTS product_null_5a8cedc0c0d88;;

    				CREATE TEMPORARY TABLE product_null_5a8cedc0c0d88  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cedc01108c` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cedc011093` (
DROP TABLE IF EXISTS `producttemp_5a8cedc0c06cf` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cedc011093`,`tmp_tbl_oldprdt5a8cedc01108c`,`tmp_tbl_5a8cedc011098`
DROP TABLE IF EXISTS `totalproduct_5a8cedc0c06d3` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cedc0c06fb` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8cedc0c06fd` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cedc0c0abf` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cedc0c0ac2` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cedc0c06ff` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cedc0c0d7a` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cedc0c0d7c` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cedc0c0d59` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cedc0c0d7c` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cedc0c0d7a` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cedc0c06fb` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8cedc0c0e0f` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cedc0c0e13` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cedc0c0e14` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cedc0c0d59` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cedc0c0e69` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc2096d8` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cedc0c0d81` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc2096d8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc216d16` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc216d16 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc216d16`,`tmp_non_replicate_shorttext_5a8cedc2096d8`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc23be93` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc23be93 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc249651` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc249651 (INDEX(st_id))

DROP TABLE IF EXISTS `latest_5a8cedc0c0e6c` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cedc0c0d81` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cedc0c0d83` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cedc0c0d8a` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cedc0c0d88` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cedc0c0d88  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cedc0be8eb` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cedc0c0d81` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc249651`,`tmp_non_replicate_shorttext_5a8cedc23be93`
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cedc0c0d83` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cedc0c0d8a` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cedc0c0d8a`,`latest2_5a8cedc0c0d83`,`update_price_5a8cedc0c0d81`,`lastest_bal_5a8cedc0be8eb`,`product_null_5a8cedc0c0d88`,`latest_5a8cedc0c0e6c`,`bal_cost_5a8cedc0c0e69`,`final_5a8cedc0c0d59`,`tmp_latest_bal_bal_5a8cedc0c0e14`,`tmp_latest_bal_date_5a8cedc0c0e13`,`_temptable25a8cedc0c0e0f`,`init_5a8cedc0c06fb`,`initv_5a8cedc0c06ff`,`initialtablebycomp25a8cedc0c0ac2`,`initialtablebycomp5a8cedc0c0abf`,`initpd_5a8cedc0c06fd`,`totalproduct_5a8cedc0c06d3`,`producttemp_5a8cedc0c06cf`,`tmp_tbl_olddate5a8cedc011093`,`tmp_tbl_oldprdt5a8cedc01108c`
DROP TABLE IF EXISTS `tmp_tbl1_sn_5a8cedc7b1e67` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl2_sn_5a8cedc7b1e6b` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl3_sn_5a8cedc7b1e6d` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl2_sn_5a8cedc7b1e6b 	

CREATE TEMPORARY TABLE tmp_tbl1_sn_5a8cedc7b1e67 	(INDEX(dt_serial))

DROP TABLE IF EXISTS `tmp_tbl_final_sn_5a8cedc7b1e6f` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl_final_sn_5a8cedc7b1e6f

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc825ac1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc825ac1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc82df4d` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc82df4d (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc8315fc` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc8315fc (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc837e85` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc837e85 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc83c201` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedc83c201 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedc83c201`,`tmp_non_replicate_shorttext_5a8cedc837e85`,`tmp_non_replicate_shorttext_5a8cedc8315fc`,`tmp_non_replicate_shorttext_5a8cedc82df4d`,`tmp_non_replicate_shorttext_5a8cedc825ac1`,`tmp_tbl_final_sn_5a8cedc7b1e6f`,`tmp_tbl1_sn_5a8cedc7b1e67`,`tmp_tbl2_sn_5a8cedc7b1e6b`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce17e58` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce17e58 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cedce4bb68` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce6d971` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce6d971 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce70ebd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce70ebd (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce73e73` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce73e73 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce76ce8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce76ce8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce7f30c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce7f30c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce86ee6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce86ee6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce89c61` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce89c61 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce8cea4` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce8cea4 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce90686` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce90686 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce93ac4` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce93ac4 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce96f74` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce96f74 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce99a18` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce99a18 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce9d5ba` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedce9d5ba (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedce9d5ba`,`tmp_non_replicate_shorttext_5a8cedce99a18`,`tmp_non_replicate_shorttext_5a8cedce96f74`,`tmp_non_replicate_shorttext_5a8cedce93ac4`,`tmp_non_replicate_shorttext_5a8cedce90686`,`tmp_non_replicate_shorttext_5a8cedce8cea4`,`tmp_non_replicate_shorttext_5a8cedce89c61`,`tmp_non_replicate_shorttext_5a8cedce86ee6`,`tmp_non_replicate_shorttext_5a8cedce7f30c`,`tmp_non_replicate_shorttext_5a8cedce76ce8`,`tmp_non_replicate_shorttext_5a8cedce73e73`,`tmp_non_replicate_shorttext_5a8cedce70ebd`,`tmp_non_replicate_shorttext_5a8cedce6d971`,`temp_5a8cedce4bb68`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cedce17e58`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceddb6bfbd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceddb6bfbd (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceddb7a277` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceddb7a277 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceddb7a277`,`tmp_non_replicate_shorttext_5a8ceddb6bfbd`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf09a48e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf09a48e (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf09a48e`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf0be10e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf0be10e (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf0be10e`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf108ac0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf108ac0 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_lvl_7` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_7  SELECT * FROM producttree where ptree_level='7' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_6` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_6  SELECT * FROM producttree where ptree_level='6' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_5` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_5  SELECT * FROM producttree where ptree_level='5' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_4` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_4  SELECT * FROM producttree where ptree_level='4' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_3` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_3  SELECT * FROM producttree where ptree_level='3' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_2` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_2  SELECT * FROM producttree where ptree_level='2' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `temp_lvl_1` /* generated by server */
CREATE TEMPORARY TABLE temp_lvl_1  SELECT * FROM producttree where ptree_level='1' order by ptree_id /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TABLE IF EXISTS `tmp_non_replicate_5a8cedf6367fd` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_5a8cedf6367fd (index(productno)) SELECT temp_lvl_1.ptree_id as main_hier_no, temp_lvl_1.ptree_code as main_hier_code, temp_lvl_1.ptree_name as main_hier_name, temp_lvl_2.ptree_id as n_hier_no, temp_lvl_2.ptree_code as n_hier_code, temp_lvl_2.ptree_name as n_hier_name ,temp_lvl_3.ptree_id as t_hier_no, temp_lvl_3.ptree_code as t_hier_code, temp_lvl_3.ptree_name as t_hier_name  , temp_lvl_7.ptree_id as hier_no , temp_lvl_7.ptree_code as hier_code , temp_lvl_7.ptree_name as hier_name , temp_lvl_7.prdt_no as productno  FROM temp_lvl_1 INNER JOIN temp_lvl_2 ON temp_lvl_2.ptree_parent_id=temp_lvl_1.ptree_id INNER JOIN temp_lvl_3 ON temp_lvl_3.ptree_parent_id=temp_lvl_2.ptree_id INNER JOIN temp_lvl_4 ON temp_lvl_4.ptree_parent_id=temp_lvl_3.ptree_id INNER JOIN temp_lvl_5 ON temp_lvl_5.ptree_parent_id=temp_lvl_4.ptree_id INNER JOIN temp_lvl_6 ON temp_lvl_6.ptree_parent_id=temp_lvl_5.ptree_id INNER JOIN temp_lvl_7 ON temp_lvl_7.ptree_parent_id=temp_lvl_6.ptree_id    /*u511=/ver5.08.03/merchandising/merc_price_checker.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf643d79` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf643d79 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf64dda6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf64dda6 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf650d91` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf650d91 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf6535b8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf6535b8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf656bd0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf656bd0 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf659b86` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf659b86 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf65d20c` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf65d20c (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf660a07` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf660a07 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf66481f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf66481f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf667611` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cedf667611 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cedf667611`,`tmp_non_replicate_shorttext_5a8cedf66481f`,`tmp_non_replicate_shorttext_5a8cedf660a07`,`tmp_non_replicate_shorttext_5a8cedf65d20c`,`tmp_non_replicate_shorttext_5a8cedf659b86`,`tmp_non_replicate_shorttext_5a8cedf656bd0`,`tmp_non_replicate_shorttext_5a8cedf6535b8`,`tmp_non_replicate_shorttext_5a8cedf650d91`,`tmp_non_replicate_shorttext_5a8cedf64dda6`,`tmp_non_replicate_shorttext_5a8cedf643d79`,`tmp_non_replicate_5a8cedf6367fd`,`temp_lvl_1`,`temp_lvl_2`,`temp_lvl_3`,`temp_lvl_4`,`temp_lvl_5`,`temp_lvl_6`,`temp_lvl_7`,`tmp_non_replicate_shorttext_5a8cedf108ac0`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee0d48de1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee0d48de1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee0d53924` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee0d53924 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee0d53924`,`tmp_non_replicate_shorttext_5a8cee0d48de1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee11b2b93` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee11b2b93 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee11b2b93`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee3290601` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee3290601 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee329ac20` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee329ac20 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee329ac20`,`tmp_non_replicate_shorttext_5a8cee3290601`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee3551746` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee3551746 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee3551746`
DROP TABLE IF EXISTS `tmp_tbl_5a8cee375faea` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cee375faea SELECT * FROM bill_detail where dt_transno=42892 and dt_type1='SN' and dt_type2='DN' and dt_transeqno>0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cee375fadc 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u639=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cee3a1b33d` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cee3a1b367` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cee3a1bb4c` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cee3a1ba44` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cee3a1bb4f` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cee3a1ba46` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cee3a1ba4c` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cee3a1b8dd` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cee3a1b8e0` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cee3a1b8e1` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cee3a1b8e3` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cee3a1b8e7` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cee3a1b8e5` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cee3a1ba19` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cee375fadc` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_oldprdt5a8cee375fadc values  (\'39599\') , (\'42624\') , (\'42625\') , (\'42626\') , (\'32763\') , (\'21730\') , (\'36418\') , (\'19833\') , (\'19832\') , (\'7798\') , (\'31038\') , (\'31039\') , (\'26990\') , (\'26991\') , (\'36276\') , (\'37010\') , (\'39789\') , (\'42078\') , (\'6047\') , (\'6039\') , (\'6053\') , (\'6036\') , (\'34001\') , (\'6032\') , (\'38250\') , (\'36284\') , (\'42084\') , (\'42086\') , (\'42085\') , (\'37386\') , (\'38249\') , (\'41148\') , (\'41149\') , (\'33422\') , (\'35444\') , (\'40690\') , (\'41871\') , (\'39427\') , (\'35138\') , (\'7756\') , (\'20871\') , (\'36233\') , (\'38892\') , (\'38880\') , (\'41942\') , (\'41741\') , (\'36312\') , (\'36313\') , (\'38356\') , (\'41498\') , (\'38881\') , (\'23145\') , (\'38193\') , (\'38283\') , (\'39414\') , (\'23134\') , (\'30892\') , (\'36653\') , (\'42518\') , (\'42504\') , (\'42362\') , (\'42364\') , (\'42398\') , (\'42388\') , (\'38941\') , (\'38884\') , (\'42344\') , (\'42410\') , (\'42392\') , (\'36665\') , (\'42399\') , (\'34521\') , (\'42414\') , (\'42368\') , (\'42372\') , (\'42319\') , (\'42341\') , (\'42439\') , (\'42411\') , (\'42403\') , (\'38891\') , (\'42407\') , (\'42416\') , (\'37337\') , (\'42395\') , (\'42400\') , (\'38937\') , (\'39750\') , (\'41249\') , (\'42391\') , (\'42393\') , (\'42464\') , (\'42466\') , (\'42448\') , (\'42449\') , (\'42457\') , (\'42458\') , (\'42459\') , (\'42463\') , (\'42467\') , (\'42461\') , (\'42460\') , (\'42465\') , (\'42462\') , (\'41921\') , (\'33742\') , (\'34719\') , (\'13374\') , (\'42529\') , (\'42517\') , (\'42527\') , (\'42528\') , (\'42521\') , (\'39436\') , (\'41934\') , (\'33739\') , (\'33740\') , (\'17050\') , (\'29345\') , (\'38305\') , (\'42531\') , (\'38304\') , (\'34299\') , (\'41547\') , (\'41331\') , (\'33741\') , (\'42061\') , (\'42533\') , (\'42524\') , (\'34193\') , (\'41721\') , (\'38308\') , (\'42526\') , (\'42532\') , (\'42511\') , (\'42510\') , (\'42505\') , (\'42506\') , (\'42530\') , (\'38309\') , (\'38306\') , (\'42514\') , (\'41624\') , (\'34190\') , (\'35311\') , (\'41903\') , (\'39019\') , (\'41905\') , (\'40599\') , (\'40597\') , (\'35313\') , (\'41236\') , (\'41237\') , (\'36909\') , (\'38888\') , (\'40596\') , (\'37115\') , (\'41927\') , (\'42523\') , (\'39889\') , (\'41947\') , (\'31670\') , (\'24110\') , (\'37091\') , (\'39437\') , (\'41931\') , (\'32506\') , (\'42507\') , (\'38307\') , (\'42515\') , (\'41614\') , (\'39438\') , (\'31225\') , (\'41972\') , (\'32787\') , (\'38814\') , (\'38812\') , (\'38627\') , (\'41695\') , (\'38327\') , (\'34695\') , (\'41708\') , (\'41696\') , (\'41699\') , (\'34672\') , (\'38624\') , (\'42509\') , (\'42501\') , (\'42503\') , (\'42500\') , (\'42508\') , (\'42513\') , (\'7715\') , (\'15850\') , (\'40666\') , (\'40863\') , (\'40665\') , (\'40668\') , (\'40663\') , (\'40658\') , (\'7712\') , (\'19264\') , (\'23208\') , (\'42088\') , (\'36319\') , (\'36308\') , (\'36310\') , (\'41480\') , (\'36314\') , (\'42519\') , (\'37607\') , (\'36952\') , (\'36328\') , (\'36957\') , (\'36302\') , (\'42404\') , (\'42389\') , (\'42405\') , (\'36942\') , (\'37640\') , (\'36941\') , (\'36236\') , (\'42520\') , (\'42502\') , (\'21639\') , (\'16405\') , (\'42402\') , (\'36888\') , (\'42366\') , (\'36662\') , (\'42360\') , (\'37641\') , (\'36940\') , (\'38885\') , (\'42370\') , (\'38944\') , (\'42390\') , (\'42415\') , (\'39751\') , (\'40027\') ;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cee375fae3` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;insert into tmp_tbl_olddate5a8cee375fae3 values  (\'2018-02-21\') ;;DROP TABLE IF EXISTS producttemp_5a8cee3a1b33a;;

    				DROP TABLE IF EXISTS product_null_5a8cee3a1ba4a;;

    				CREATE TEMPORARY TABLE product_null_5a8cee3a1ba4a  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cee375fadc` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cee375fae3` (
DROP TABLE IF EXISTS `producttemp_5a8cee3a1b33a` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cee3a1b33d` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cee375fae3`,`tmp_tbl_oldprdt5a8cee375fadc`,`tmp_tbl_5a8cee375faea`
DROP TABLE IF EXISTS `init_5a8cee3a1b367` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8cee3a1b36a` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cee3a1b746` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cee3a1b749` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cee3a1b36c` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cee3a1ba3c` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cee3a1ba3e` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cee3a1ba19` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cee3a1ba3e` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cee3a1ba3c` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cee3a1b367` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8cee3a1bae2` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cee3a1bae5` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cee3a1bae7` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cee3a1ba19` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cee3a1bb4c` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cee3a1ba44` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee3e51bb8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee3e51bb8 (INDEX(st_id))

DROP TABLE IF EXISTS `latest_5a8cee3a1bb4f` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cee3a1ba44` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee3e51bb8`
DROP TABLE IF EXISTS `latest2_5a8cee3a1ba46` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cee3a1ba4c` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cee3a1ba4a` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cee3a1ba4a  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cee3a191f1` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cee3a1ba44` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cee3a1ba46` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cee3a1ba4c` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cee3a1ba4c`,`latest2_5a8cee3a1ba46`,`update_price_5a8cee3a1ba44`,`lastest_bal_5a8cee3a191f1`,`product_null_5a8cee3a1ba4a`,`latest_5a8cee3a1bb4f`,`bal_cost_5a8cee3a1bb4c`,`final_5a8cee3a1ba19`,`tmp_latest_bal_bal_5a8cee3a1bae7`,`tmp_latest_bal_date_5a8cee3a1bae5`,`_temptable25a8cee3a1bae2`,`init_5a8cee3a1b367`,`initv_5a8cee3a1b36c`,`initialtablebycomp25a8cee3a1b749`,`initialtablebycomp5a8cee3a1b746`,`initpd_5a8cee3a1b36a`,`totalproduct_5a8cee3a1b33d`,`producttemp_5a8cee3a1b33a`,`tmp_tbl_olddate5a8cee375fae3`,`tmp_tbl_oldprdt5a8cee375fadc`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e23d78` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e23d78 (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cee4e501cc` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e6a880` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e6a880 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e6d420` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e6d420 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e70171` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e70171 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e73ae5` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e73ae5 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e7b554` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e7b554 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e83e5b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e83e5b (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e874a2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e874a2 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e89cdb` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e89cdb (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e8c814` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e8c814 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e8ff65` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e8ff65 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e93f04` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e93f04 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e97631` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e97631 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e9a966` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee4e9a966 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee4e9a966`,`tmp_non_replicate_shorttext_5a8cee4e97631`,`tmp_non_replicate_shorttext_5a8cee4e93f04`,`tmp_non_replicate_shorttext_5a8cee4e8ff65`,`tmp_non_replicate_shorttext_5a8cee4e8c814`,`tmp_non_replicate_shorttext_5a8cee4e89cdb`,`tmp_non_replicate_shorttext_5a8cee4e874a2`,`tmp_non_replicate_shorttext_5a8cee4e83e5b`,`tmp_non_replicate_shorttext_5a8cee4e7b554`,`tmp_non_replicate_shorttext_5a8cee4e73ae5`,`tmp_non_replicate_shorttext_5a8cee4e70171`,`tmp_non_replicate_shorttext_5a8cee4e6d420`,`tmp_non_replicate_shorttext_5a8cee4e6a880`,`temp_5a8cee4e501cc`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cee4e23d78`
DROP TABLE IF EXISTS `tmp_tbl_5a8cee5e8844b` /* generated by server */
create TEMPORARY TABLE tmp_tbl_5a8cee5e8844b SELECT * FROM bill_detail where dt_transno=93520 and dt_type1='SN' and dt_type2='RN' and dt_transeqno>0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE tmp_tbl_oldprdt5a8cee5e8843e 

DROP TABLE IF EXISTS `temp_header` /* generated by server */
DROP TABLE IF EXISTS `temp_detail` /* generated by server */
CREATE TEMPORARY TABLE temp_header SELECT * FROM bill_header LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
CREATE TEMPORARY TABLE temp_detail SELECT * FROM bill_detail LIMIT 0 /*u149=/ver5.08.03/inv_trn_sn_redirect.php=okn*/
DROP TEMPORARY TABLE IF EXISTS `temp_header` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `temp_detail` /* generated by server */
DROP TABLE IF EXISTS `totalproduct_5a8cee5ef16e7` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cee5ef170d` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cee5ef1ea8` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cee5ef1dd0` /* generated by server */
DROP TABLE IF EXISTS `latest_5a8cee5ef1eab` /* generated by server */
DROP TABLE IF EXISTS `latest2_5a8cee5ef1dd2` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cee5ef1dd7` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_shelf5a8cee5ef1c80` /* generated by server */
DROP TABLE IF EXISTS `init_balshelforder5a8cee5ef1c82` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf_5a8cee5ef1c84` /* generated by server */
DROP TABLE IF EXISTS `initpdshelf2_5a8cee5ef1c86` /* generated by server */
DROP TABLE IF EXISTS `initpdrepkstore_5a8cee5ef1c8a` /* generated by server */
DROP TABLE IF EXISTS `init_balrepkstoreorder5a8cee5ef1c88` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cee5ef1da9` /* generated by server */
insert into SQLThread (sql_data,sql_status) values ('CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cee5e8843e` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cee5e88445` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;;DROP TABLE IF EXISTS producttemp_5a8cee5ef16e4;;

    				DROP TABLE IF EXISTS product_null_5a8cee5ef1dd6;;

    				CREATE TEMPORARY TABLE product_null_5a8cee5ef1dd6  (INDEX (prdt_null))

CREATE TEMPORARY TABLE `tmp_tbl_oldprdt5a8cee5e8843e` (
CREATE TEMPORARY TABLE `tmp_tbl_olddate5a8cee5e88445` (
DROP TABLE IF EXISTS `producttemp_5a8cee5ef16e4` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_tbl_olddate5a8cee5e88445`,`tmp_tbl_oldprdt5a8cee5e8843e`,`tmp_tbl_5a8cee5e8844b`
DROP TABLE IF EXISTS `totalproduct_5a8cee5ef16e7` /* generated by server */
DROP TABLE IF EXISTS `init_5a8cee5ef170d` /* generated by server */
DROP TABLE IF EXISTS `initpd_5a8cee5ef170f` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp5a8cee5ef1b1e` /* generated by server */
DROP TABLE IF EXISTS `initialtablebycomp25a8cee5ef1b21` /* generated by server */
DROP TABLE IF EXISTS `initv_5a8cee5ef1711` /* generated by server */
DROP TABLE IF EXISTS `initpd_def_bal_store5a8cee5ef1dc9` /* generated by server */
DROP TABLE IF EXISTS `init_balstoreorder5a8cee5ef1dcb` /* generated by server */
DROP TABLE IF EXISTS `final_5a8cee5ef1da9` /* generated by server */
DROP TEMPORARY TABLE `init_balstoreorder5a8cee5ef1dcb` /* generated by server */
DROP TEMPORARY TABLE `initpd_def_bal_store5a8cee5ef1dc9` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `init_5a8cee5ef170d` /* generated by server */
DROP TABLE IF EXISTS `_temptable25a8cee5ef1e51` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_date_5a8cee5ef1e55` /* generated by server */
DROP TABLE IF EXISTS `tmp_latest_bal_bal_5a8cee5ef1e56` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `final_5a8cee5ef1da9` /* generated by server */
DROP TABLE IF EXISTS `bal_cost_5a8cee5ef1ea8` /* generated by server */
DROP TABLE IF EXISTS `update_price_5a8cee5ef1dd0` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee601f9c9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee601f9c9 (INDEX(st_id))

DROP TABLE IF EXISTS `latest_5a8cee5ef1eab` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cee5ef1dd0` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee602c969` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee602c969 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee602c969`,`tmp_non_replicate_shorttext_5a8cee601f9c9`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee604cdde` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee604cdde (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee60599f3` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee60599f3 (INDEX(st_id))

DROP TABLE IF EXISTS `latest2_5a8cee5ef1dd2` /* generated by server */
DROP TABLE IF EXISTS `latest3_5a8cee5ef1dd7` /* generated by server */
DROP TABLE IF EXISTS `product_null_5a8cee5ef1dd6` /* generated by server */
CREATE TEMPORARY TABLE product_null_5a8cee5ef1dd6  (INDEX (prdt_null))

DROP TABLE IF EXISTS `lastest_bal_5a8cee5eefa60` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `update_price_5a8cee5ef1dd0` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest2_5a8cee5ef1dd2` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `latest3_5a8cee5ef1dd7` /* generated by server */
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `latest3_5a8cee5ef1dd7`,`latest2_5a8cee5ef1dd2`,`update_price_5a8cee5ef1dd0`,`lastest_bal_5a8cee5eefa60`,`product_null_5a8cee5ef1dd6`,`latest_5a8cee5ef1eab`,`bal_cost_5a8cee5ef1ea8`,`final_5a8cee5ef1da9`,`tmp_latest_bal_bal_5a8cee5ef1e56`,`tmp_latest_bal_date_5a8cee5ef1e55`,`_temptable25a8cee5ef1e51`,`init_5a8cee5ef170d`,`initv_5a8cee5ef1711`,`initialtablebycomp25a8cee5ef1b21`,`initialtablebycomp5a8cee5ef1b1e`,`initpd_5a8cee5ef170f`,`totalproduct_5a8cee5ef16e7`,`producttemp_5a8cee5ef16e4`,`tmp_tbl_olddate5a8cee5e88445`,`tmp_tbl_oldprdt5a8cee5e8843e`
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee60599f3`,`tmp_non_replicate_shorttext_5a8cee604cdde`
DROP TABLE IF EXISTS `tmp_tbl1_sn_5a8cee6560867` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl2_sn_5a8cee656086b` /* generated by server */
DROP TABLE IF EXISTS `tmp_tbl3_sn_5a8cee656086c` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl2_sn_5a8cee656086b 	

CREATE TEMPORARY TABLE tmp_tbl1_sn_5a8cee6560867 	(INDEX(dt_serial))

DROP TABLE IF EXISTS `tmp_tbl_final_sn_5a8cee656086e` /* generated by server */
CREATE TEMPORARY TABLE tmp_tbl_final_sn_5a8cee656086e

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65ab52f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee65ab52f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65b28d9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee65b28d9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65b6b74` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee65b6b74 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65bcbc8` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee65bcbc8 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65c012a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee65c012a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee65c012a`,`tmp_non_replicate_shorttext_5a8cee65bcbc8`,`tmp_non_replicate_shorttext_5a8cee65b6b74`,`tmp_non_replicate_shorttext_5a8cee65b28d9`,`tmp_non_replicate_shorttext_5a8cee65ab52f`,`tmp_tbl_final_sn_5a8cee656086e`,`tmp_tbl1_sn_5a8cee6560867`,`tmp_tbl2_sn_5a8cee656086b`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b0b98e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b0b98e (INDEX(st_id))

DROP TABLE IF EXISTS `temp_5a8cee6b3cc53` /* generated by server */
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b59fb9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b59fb9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b5d329` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b5d329 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b60707` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b60707 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b63b97` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b63b97 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b6b80f` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b6b80f (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b72eb9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b72eb9 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b75551` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b75551 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b77edf` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b77edf (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b7ab40` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b7ab40 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b7de05` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b7de05 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b81cb0` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b81cb0 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b84ff2` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b84ff2 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b886c9` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee6b886c9 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee6b886c9`,`tmp_non_replicate_shorttext_5a8cee6b84ff2`,`tmp_non_replicate_shorttext_5a8cee6b81cb0`,`tmp_non_replicate_shorttext_5a8cee6b7de05`,`tmp_non_replicate_shorttext_5a8cee6b7ab40`,`tmp_non_replicate_shorttext_5a8cee6b77edf`,`tmp_non_replicate_shorttext_5a8cee6b75551`,`tmp_non_replicate_shorttext_5a8cee6b72eb9`,`tmp_non_replicate_shorttext_5a8cee6b6b80f`,`tmp_non_replicate_shorttext_5a8cee6b63b97`,`tmp_non_replicate_shorttext_5a8cee6b60707`,`tmp_non_replicate_shorttext_5a8cee6b5d329`,`tmp_non_replicate_shorttext_5a8cee6b59fb9`,`temp_5a8cee6b3cc53`,`new_notes_def`,`notes_def1`,`wf_def1`,`tmp_non_replicate_shorttext_5a8cee6b0b98e`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7c5c8af` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7c5c8af (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7c66b96` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7c66b96 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7c66b96`,`tmp_non_replicate_shorttext_5a8cee7c5c8af`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7d82544` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7d82544 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7d8ba2e` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7d8ba2e (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7d8ba2e`,`tmp_non_replicate_shorttext_5a8cee7d82544`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7edc3ac` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7edc3ac (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7ee648a` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee7ee648a (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee7ee648a`,`tmp_non_replicate_shorttext_5a8cee7edc3ac`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee8183475` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee8183475 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee818ceaa` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee818ceaa (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee818ceaa`,`tmp_non_replicate_shorttext_5a8cee8183475`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee8359bf1` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee8359bf1 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee8362e1b` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cee8362e1b (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cee8362e1b`,`tmp_non_replicate_shorttext_5a8cee8359bf1`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceee06cd41` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceee06cd41 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceee0768ae` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceee0768ae (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceee0768ae`,`tmp_non_replicate_shorttext_5a8ceee06cd41`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceee401791` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8ceee401791 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8ceee401791`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef383e816` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cef383e816 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef384a052` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cef384a052 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef384a052`,`tmp_non_replicate_shorttext_5a8cef383e816`
DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef3e62e60` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cef3e62e60 (INDEX(st_id))

DROP TEMPORARY TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef3e6d6a6` /* generated by server */
CREATE TEMPORARY TABLE tmp_non_replicate_shorttext_5a8cef3e6d6a6 (INDEX(st_id))

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp_non_replicate_shorttext_5a8cef3e6d6a6`,`tmp_non_replicate_shorttext_5a8cef3e62e60`