Details
Description
Simple select query that crashes MariaDB 10.2.
Crash does not happen when set names utf8 is not set.
SET NAMES 'utf8';
|
SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , psi.price_min, psi.price_max
|
FROM ps_product p INNER JOIN ps_product_shop product_shop
|
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
|
INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product)
|
INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 24 AND c.active = 1)
|
LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1)
|
INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1)
|
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both","catalog") AND p.id_product IN
|
(SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 32) AND p.id_product IN
|
(SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 15) AND p.id_product IN
|
(SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 18 OR fp.`id_feature_value` = 19) AND p.id_product IN
|
(SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 34 OR fp.`id_feature_value` = 23) AND p.id_product IN
|
(SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 29 OR fp.`id_feature_value` = 28 OR fp.`id_feature_value` = 26)
|
GROUP BY p.id_product;
|
Log:
Feb 8 10:26:19 uvn-234-24 mysqld: Version: '10.2.12-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
|
Feb 8 10:26:19 uvn-234-24 systemd: Started MariaDB database server.
|
Feb 8 10:26:55 uvn-234-24 systemd: Started Session 1150 of user root.
|
Feb 8 10:26:55 uvn-234-24 systemd-logind: New session 1150 of user root.
|
Feb 8 10:26:55 uvn-234-24 systemd: Starting Session 1150 of user root.
|
Feb 8 10:26:55 uvn-234-24 systemd-logind: Removed session 1150.
|
Feb 8 10:28:31 uvn-234-24 mysqld: 180208 10:28:31 [ERROR] mysqld got signal 11 ;
|
Feb 8 10:28:31 uvn-234-24 mysqld: This could be because you hit a bug. It is also possible that this binary
|
Feb 8 10:28:31 uvn-234-24 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Feb 8 10:28:31 uvn-234-24 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Feb 8 10:28:31 uvn-234-24 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Feb 8 10:28:31 uvn-234-24 mysqld: We will try our best to scrape up some info that will hopefully help
|
Feb 8 10:28:31 uvn-234-24 mysqld: diagnose the problem, but since we have already crashed,
|
Feb 8 10:28:31 uvn-234-24 mysqld: something is definitely wrong and this may fail.
|
Feb 8 10:28:31 uvn-234-24 mysqld: Server version: 10.2.12-MariaDB
|
Feb 8 10:28:31 uvn-234-24 mysqld: key_buffer_size=134217728
|
Feb 8 10:28:31 uvn-234-24 mysqld: read_buffer_size=131072
|
Feb 8 10:28:31 uvn-234-24 mysqld: max_used_connections=1
|
Feb 8 10:28:31 uvn-234-24 mysqld: max_threads=153
|
Feb 8 10:28:31 uvn-234-24 mysqld: thread_count=7
|
Feb 8 10:28:31 uvn-234-24 mysqld: It is possible that mysqld could use up to
|
Feb 8 10:28:31 uvn-234-24 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467244 K bytes of memory
|
Feb 8 10:28:31 uvn-234-24 mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Feb 8 10:28:31 uvn-234-24 mysqld: Thread pointer: 0x7fe6e9a04e38
|
Feb 8 10:28:31 uvn-234-24 mysqld: Attempting backtrace. You can use the following information to find out
|
Feb 8 10:28:31 uvn-234-24 mysqld: where mysqld died. If you see no messages after this, something went
|
Feb 8 10:28:31 uvn-234-24 mysqld: terribly wrong...
|
Feb 8 10:28:31 uvn-234-24 mysqld: stack_bottom = 0x7fe6d80c6d70 thread_stack 0x49000
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fe6e6511c4e]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x7fe6e5f9c825]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /lib64/libpthread.so.0(+0xf130)[0x7fe6e5501130]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN10TABLE_LIST33is_with_table_recursive_referenceEv+0x0)[0x7fe6e5f2e4a0]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN13st_join_table7cleanupEv+0x18)[0x7fe6e5e489d8]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN7cleanupEb+0x368)[0x7fe6e5e49058]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN9join_freeEv+0x4c)[0x7fe6e5e4934c]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x9b5)[0x7fe6e5e60635]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x7fe6e5e608d3]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x7fe6e5e60a2a]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x7fe6e5e61584]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(+0x415dcc)[0x7fe6e5d46dcc]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6d85)[0x7fe6e5e113a5]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x7fe6e5e13a5e]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x209f)[0x7fe6e5e16a6f]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x149)[0x7fe6e5e17669]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x7fe6e5edaefa]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x7fe6e5edb01d]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /lib64/libpthread.so.0(+0x7df3)[0x7fe6e54f9df3]
|
Feb 8 10:28:31 uvn-234-24 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fe6e3b511ad]
|
Feb 8 10:28:31 uvn-234-24 mysqld: Trying to get some variables.
|
Feb 8 10:28:31 uvn-234-24 mysqld: Some pointers may be invalid and cause the dump to abort.
|
Feb 8 10:28:31 uvn-234-24 mysqld: Query (0x7fe6e9a12400): SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , psi.price_min, psi.price_max FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 3 AND c.nright <= 24 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both","catalog") AND p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 32) AND p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 15) AND p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 18 OR fp.`id_feature_value` = 19) AND p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 34 OR fp.`id_feature_value` = 23) AND p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE fp.`id_feature_value` = 29 OR fp.`id_feature_value` = 28 OR fp.`id_feature_value` = 26) GROUP BY p.id_product
|
Feb 8 10:28:31 uvn-234-24 mysqld: Connection ID (thread ID): 10
|
Feb 8 10:28:31 uvn-234-24 mysqld: Status: NOT_KILLED
|
Feb 8 10:28:31 uvn-234-24 mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
Feb 8 10:28:31 uvn-234-24 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
Feb 8 10:28:31 uvn-234-24 mysqld: information that should help you find out what is causing the crash.
|
Feb 8 10:28:31 uvn-234-24 systemd: mariadb.service: main process exited, code=killed, status=11/SEGV
|
Feb 8 10:28:31 uvn-234-24 systemd: Unit mariadb.service entered failed state.
|
Feb 8 10:28:31 uvn-234-24 systemd: mariadb.service failed.
|
Feb 8 10:28:36 uvn-234-24 systemd: mariadb.service holdoff time over, scheduling restart.
|
Feb 8 10:28:36 uvn-234-24 systemd: Starting MariaDB database server...
|
Attachments
Issue Links
- is duplicated by
-
MDEV-15434 Mariadb crashes several times
-
- Closed
-
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Attachment | dump.txt [ 45172 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Assignee | Alice Sherepa [ alice ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Component/s | Optimizer [ 10200 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Priority | Critical [ 2 ] | Major [ 3 ] |
Reproducible with MyIsam, not with Innodb
CREATE TABLE `t1` ( |
`id_category` int unsigned not null, |
`id_parent` int unsigned, |
`id_shop_default` int unsigned DEFAULT 1, |
`level_depth` tinyint(3) unsigned,
|
`nleft` int unsigned, |
`nright` int unsigned, |
`active` tinyint(1) unsigned,
|
`date_add` datetime,
|
`date_upd` datetime,
|
`position` int unsigned, |
`is_root_category` tinyint(1),
|
KEY `nright` (`nright`), |
KEY `nleft` (`nleft`) |
) ENGINE=MyISAM;
|
|
|
INSERT INTO `t1` VALUES (1,0,1,0,1,42,1,'2013-06-16 16:52:34','2013-06-16 16:52:34',0,0),(2,1,1,1,2,41,1,'2013-06-16 16:52:34','2013-06-16 16:52:34',0,1),(30,14,1,3,32,33,1,'2013-09-30 21:36:29','2013-12-28 18:23:26',2,0),(29,14,1,3,30,31,1,'2013-09-30 21:36:04','2013-12-28 18:23:08',1,0),(27,34,1,3,6,7,1,'2013-09-24 15:48:01','2013-12-28 22:11:07',2,0),(35,2,1,2,25,28,1,'2013-10-02 14:45:56','2013-10-02 14:45:56',0,0),(33,14,1,3,38,39,1,'2013-09-30 21:37:17','2013-12-28 18:24:02',5,0),(9,34,1,3,22,23,1,'2013-06-16 20:24:07','2013-10-02 14:37:11',6,0),(32,14,1,3,36,37,1,'2013-09-30 21:37:02','2013-12-28 18:23:49',4,0),(11,35,1,3,26,27,1,'2013-06-16 20:24:47','2013-10-02 14:46:31',10,0),(12,34,1,3,18,19,1,'2013-06-16 20:24:59','2013-10-02 14:41:46',7,0),(13,34,1,3,14,15,1,'2013-06-16 20:25:17','2013-10-02 14:40:27',1,0),(14,2,1,2,29,40,1,'2013-06-16 20:26:32','2013-12-28 18:22:26',3,0),(34,2,1,2,3,24,1,'2013-10-01 13:23:10','2013-12-28 17:17:43',1,0),(31,14,1,3,34,35,1,'2013-09-30 21:36:46','2013-12-28 18:23:38',3,0),(18,34,1,3,16,17,1,'2013-06-16 22:34:44','2013-10-02 14:32:27',3,0),(19,34,1,3,12,13,1,'2013-06-16 22:35:15','2013-10-02 14:33:42',4,0),(23,34,1,3,8,9,1,'2013-06-16 23:07:50','2013-10-02 14:41:01',3,0),(24,34,1,3,10,11,1,'2013-06-16 23:07:51','2013-10-02 14:40:44',4,0),(25,34,1,3,4,5,1,'2013-06-16 23:19:32','2013-12-28 22:10:16',1,0),(26,34,1,3,20,21,1,'2013-06-16 23:19:34','2013-10-02 14:42:01',8,0); |
|
|
CREATE TABLE `t2` ( |
`id_category` int unsigned, |
`id_product` int unsigned, |
`position` int, |
PRIMARY KEY (`id_category`,`id_product`) |
) ENGINE=MyISAM;
|
|
|
INSERT INTO `t2` VALUES (31,216,5),(31,215,4),(31,214,0),(31,213,3),(31,212,2),(32,211,3),(32,210,2),(32,209,1),(32,208,0),(29,207,30),(30,315372,5),(2,161,7),(2,132,6),(33,315380,1),(31,315371,1),(29,315370,6),(29,315373,31),(29,315369,5),(29,315374,32),(29,315368,4),(29,315375,33),(29,315367,3),(29,183,2),(29,182,1),(30,177,0),(29,315376,34),(13,315365,9),(2,167,5),(2,315357,4),(2,164,3),(2,159,2),(2,131,1),(2,127,0),(14,315364,0),(27,315363,8),(29,205,29),(29,204,28),(29,203,27),(29,202,26),(29,201,25),(29,200,24),(29,199,23),(29,198,22),(29,197,21),(29,196,20),(29,195,19),(29,194,18),(29,193,17),(29,192,16),(29,191,15),(29,190,14),(29,189,13),(14,188,1),(29,187,12),(29,186,11),(29,185,10),(29,184,9),(29,315377,35),(29,315378,36),(29,181,8),(33,315379,0),(29,179,7),(30,178,7),(29,180,0),(30,176,6),(30,175,4),(30,174,3),(30,173,2),(30,172,1),(11,171,5),(11,170,4),(11,169,3),(11,168,2),(11,167,1),(11,166,0),(26,165,1),(26,164,0),(9,163,1),(9,162,0),(12,161,2),(12,160,1),(12,159,0),(19,158,8),(19,157,7),(19,156,6),(19,155,5),(19,154,4),(19,153,3),(19,152,2),(19,151,1),(19,150,0),(18,149,6),(18,148,5),(18,147,4),(18,146,3),(18,145,2),(18,144,1),(18,143,0),(13,142,8),(13,141,7),(13,140,6),(13,139,5),(13,138,4),(13,137,3),(13,136,2),(13,135,1),(25,130,5),(25,132,7),(25,131,6),(13,134,0),(23,114,13),(23,115,14),(24,116,0),(25,133,8),(24,117,1),(23,105,4),(23,106,5),(23,107,6),(24,118,2),(25,129,4),(24,121,5),(24,123,7),(24,119,3),(24,120,4),(27,315355,0),(27,315361,6),(27,315358,3),(27,315359,4),(23,104,3),(23,113,12),(23,101,0),(24,122,6),(23,109,8),(23,103,2),(27,315360,5),(27,315362,7),(25,128,3),(24,124,8),(25,125,0),(25,126,1),(25,127,2),(23,112,11),(23,111,10),(23,110,9),(27,315356,1),(27,315357,2),(23,108,7),(23,102,1); |
|
|
CREATE TABLE `t3` ( |
`id_feature` int, |
`id_product` int, |
`id_t3` int, |
KEY `id_t3` (`id_t3`), |
KEY `id_product` (`id_product`) |
) ENGINE=MyISAM;
|
|
|
INSERT INTO `t3` VALUES (11,159,31),(11,160,31),(11,161,31),(11,101,32),(11,102,32),(11,103,32),(10,102,26),(11,104,32),(10,104,28),(11,107,32),(10,107,29),(11,126,33),(10,126,26),(11,132,33),(10,132,27),(9,159,23),(11,164,32),(10,164,26),(8,167,18),(7,167,15),(11,105,32),(10,105,28),(11,106,32),(10,106,28),(11,108,32),(10,108,29),(11,109,32),(10,109,29),(8,116,19),(7,116,16),(8,117,18),(7,117,16),(8,118,20),(7,118,16),(11,119,32),(10,119,28),(8,120,19),(7,120,16),(8,121,20),(7,121,16),(11,122,32),(10,122,29),(8,123,19),(7,123,16),(8,124,20),(7,124,16),(10,315358,27),(9,315358,23),(10,315359,27),(9,315359,23),(10,315360,27),(9,315360,23),(11,134,32),(10,134,27),(11,135,32),(10,135,27),(8,315365,18),(7,315365,15),(10,143,26),(9,143,24),(8,143,19),(7,143,16),(10,146,26),(9,146,23),(8,146,19),(7,146,16),(8,145,18),(7,145,16),(8,147,18),(7,147,16),(9,148,23),(8,148,18),(9,149,23),(8,149,19),(7,149,16),(7,148,16),(8,144,19),(7,144,16),(11,150,31),(10,150,27),(9,150,24),(11,151,31),(10,151,27),(9,151,23),(8,151,19),(11,152,31),(10,152,26),(9,152,24),(8,152,19),(11,154,31),(10,154,26),(9,154,25),(8,154,18),(11,155,31),(10,155,26),(9,155,23),(8,155,19),(11,156,31),(10,156,26),(9,156,23),(8,156,18),(11,157,31),(10,157,30),(9,157,23),(8,157,18),(11,158,31),(10,158,30),(9,158,23),(8,158,19),(11,153,31),(10,153,26),(9,153,25),(8,153,19),(8,150,21),(11,113,32),(10,113,26),(9,113,22),(8,113,19),(11,114,32),(10,114,26),(9,114,22),(8,114,18),(11,115,32),(10,115,26),(9,115,22),(8,115,20),(11,128,33),(10,128,26),(9,128,22),(8,128,19),(11,129,33),(10,129,26),(9,129,22),(8,129,18),(11,130,33),(10,130,26),(9,130,22),(8,130,20),(11,136,32),(10,136,26),(9,136,24),(8,136,19),(11,137,32),(10,137,26),(9,137,25),(8,137,19),(11,138,32),(10,138,26),(9,138,25),(8,138,18),(11,140,32),(10,140,26),(9,140,23),(8,140,18),(11,141,32),(10,141,30),(9,141,23),(8,141,18),(11,142,32),(10,142,30),(9,142,23),(8,142,19),(11,139,32),(10,139,26),(9,139,23),(8,139,19),(11,110,32),(10,110,27),(9,110,23),(11,112,32),(10,112,27),(9,112,23),(11,111,32),(10,111,27),(9,111,23),(10,315361,26),(9,315361,22),(8,315361,19),(7,315361,15),(10,315362,26),(9,315362,22),(8,315362,20),(7,315362,15),(10,315363,26),(9,315363,22),(8,315363,18),(7,315363,15),(8,180,19),(10,101,26),(10,103,26),(11,125,33),(10,125,26),(11,127,33),(10,127,26),(11,131,33),(10,131,27),(11,133,33),(10,133,27),(11,315355,31),(10,315355,26),(11,315356,31),(10,315356,26),(8,315357,18),(7,315357,15),(9,160,23),(9,161,23),(9,134,24),(8,134,21),(7,150,15),(7,151,15),(7,152,15),(7,153,15),(7,154,15),(7,155,15),(7,156,15),(7,157,15),(7,158,15),(8,159,18),(7,159,17),(8,160,18),(7,160,17),(8,161,19),(7,161,17),(9,315355,23),(8,315355,19),(7,315355,15),(9,315356,23),(8,315356,20),(7,315356,15),(9,315357,23),(10,315357,26),(11,315357,31),(8,315358,19),(7,315358,15),(8,315359,20),(7,315359,15),(8,315360,18),(7,315360,15),(11,315361,31),(11,315362,31),(11,315363,31),(9,125,23),(8,125,19),(7,125,15),(9,126,23),(8,126,18),(7,126,15),(9,127,23),(8,127,20),(7,127,15),(7,130,15),(7,129,15),(7,128,15),(9,131,23),(8,131,19),(7,131,15),(9,132,23),(8,132,18),(7,132,15),(9,133,23),(8,133,20),(7,133,15),(9,101,23),(8,101,19),(7,101,15),(9,102,23),(8,102,18),(7,102,15),(9,103,23),(8,103,20),(7,103,15),(9,104,23),(8,104,18),(7,104,15),(9,105,23),(8,105,19),(7,105,15),(9,106,23),(8,106,20),(7,106,15),(9,107,23),(8,107,18),(7,107,15),(9,108,23),(8,108,19),(7,108,15),(9,109,23),(8,109,20),(7,109,15),(8,110,19),(7,110,15),(8,111,18),(7,111,15),(8,112,20),(7,112,15),(7,113,15),(7,114,15),(7,115,15),(9,116,23),(10,116,26),(11,116,32),(9,117,23),(10,117,26),(11,117,32),(9,118,23),(10,118,26),(11,118,32),(9,119,23),(8,119,18),(7,119,16),(9,120,23),(10,120,28),(11,120,32),(9,121,23),(10,121,28),(11,121,32),(9,122,23),(8,122,18),(7,122,16),(9,123,23),(10,123,29),(11,123,32),(9,124,23),(10,124,29),(11,124,32),(11,143,32),(9,144,25),(10,144,26),(11,144,32),(9,145,25),(10,145,26),(11,145,32),(11,146,32),(9,147,23),(10,147,26),(11,147,32),(10,149,30),(11,149,32),(7,141,15),(9,315365,23),(10,315365,27),(11,315365,32),(11,165,32),(10,165,26),(9,165,22),(8,165,18),(7,165,15),(9,164,34),(8,164,18),(7,164,15),(11,163,32),(7,162,15),(10,148,30),(11,148,32),(7,134,15),(9,135,23),(8,135,19),(7,135,15),(7,136,15),(7,137,15),(7,138,15),(7,139,15),(7,140,15),(7,142,15),(11,315359,31),(11,315360,31),(11,315358,31),(11,162,32),(7,163,15),(8,175,19),(8,181,21),(8,183,19),(8,187,21),(8,315369,18),(8,315370,18),(8,315372,18),(8,315373,19),(8,315374,18),(8,315375,19),(8,315376,18),(8,315379,18),(8,315380,19); |
|
|
CREATE TABLE `t4` ( |
`id_product` int, |
`id_currency` int, |
`id_shop` int, |
`price_min` int, |
`price_max` int, |
PRIMARY KEY (`id_product`,`id_currency`,`id_shop`) |
) ENGINE=MyISAM ;
|
|
|
INSERT INTO `t4` VALUES (101,1,1,391,470),(102,1,1,391,470),(103,1,1,441,530),(104,1,1,400,480),(105,1,1,400,480),(106,1,1,441,530),(107,1,1,466,560),(108,1,1,466,560),(109,1,1,516,620),(110,1,1,433,520),(111,1,1,433,520),(112,1,1,483,580),(113,1,1,425,510),(114,1,1,425,510),(115,1,1,487,585),(116,1,1,0,0),(117,1,1,0,0),(118,1,1,0,0),(119,1,1,0,0),(120,1,1,0,0),(121,1,1,0,0),(122,1,1,314,378),(123,1,1,0,0),(124,1,1,0,0),(125,1,1,491,590),(126,1,1,491,590),(127,1,1,533,640),(128,1,1,525,630),(129,1,1,525,630),(130,1,1,558,670),(131,1,1,508,610),(132,1,1,508,610),(133,1,1,533,640),(134,1,1,158,190),(135,1,1,208,250),(136,1,1,233,280),(137,1,1,250,300),(138,1,1,250,300),(139,1,1,300,360),(140,1,1,300,360),(141,1,1,270,325),(142,1,1,325,390),(143,1,1,0,0),(144,1,1,0,0),(145,1,1,0,0),(146,1,1,0,0),(147,1,1,0,0),(148,1,1,0,0),(149,1,1,0,0),(150,1,1,400,480),(151,1,1,441,530),(152,1,1,508,610),(153,1,1,541,650),(154,1,1,541,650),(155,1,1,508,610),(156,1,1,508,610),(157,1,1,508,610),(158,1,1,508,610),(159,1,1,370,445),(160,1,1,412,495),(161,1,1,0,0),(162,1,1,0,0),(163,1,1,300,360),(164,1,1,200,240),(165,1,1,158,190),(166,1,1,0,0),(167,1,1,0,0),(168,1,1,0,0),(169,1,1,0,0),(170,1,1,0,0),(171,1,1,0,0),(172,1,1,0,0),(173,1,1,0,0),(174,1,1,0,0),(175,1,1,0,0),(176,1,1,0,0),(177,1,1,0,0),(178,1,1,0,0),(179,1,1,0,0),(180,1,1,0,0),(181,1,1,0,0),(182,1,1,0,0),(183,1,1,0,0),(184,1,1,0,0),(185,1,1,0,0),(186,1,1,0,0),(187,1,1,0,0),(188,1,1,0,0),(189,1,1,0,0),(190,1,1,0,0),(191,1,1,0,0),(192,1,1,0,0),(193,1,1,0,0),(194,1,1,0,0),(195,1,1,0,0),(196,1,1,0,0),(197,1,1,0,0),(198,1,1,0,0),(199,1,1,0,0),(200,1,1,0,0),(201,1,1,0,0),(202,1,1,0,0),(203,1,1,0,0),(204,1,1,0,0),(205,1,1,0,0),(206,1,1,0,0),(207,1,1,0,0),(208,1,1,0,0),(209,1,1,0,0),(210,1,1,0,0),(211,1,1,0,0),(212,1,1,0,0),(213,1,1,0,0),(214,1,1,0,0),(215,1,1,0,0),(216,1,1,0,0),(315355,1,1,0,0),(315356,1,1,0,0),(315357,1,1,0,0),(315358,1,1,0,0),(315359,1,1,0,0),(315360,1,1,0,0),(315361,1,1,0,0),(315362,1,1,0,0),(315363,1,1,0,0),(315364,1,1,0,0),(315365,1,1,0,0),(315366,1,1,0,0),(315367,1,1,0,0),(315368,1,1,0,0),(315369,1,1,0,0),(315370,1,1,0,0),(315371,1,1,0,0),(315372,1,1,0,0),(315373,1,1,0,0),(315374,1,1,0,0),(315375,1,1,0,0),(315376,1,1,0,0),(315377,1,1,0,0),(315378,1,1,0,0),(315379,1,1,0,0),(315380,1,1,0,0); |
|
|
CREATE TABLE `t5` ( |
`id_product` int unsigned, |
`id_supplier` int unsigned, |
`id_manufacturer` int unsigned, |
`id_category_default` int unsigned, |
`id_shop_default` int unsigned DEFAULT 1, |
`id_tax_rules_group` int unsigned, |
`on_sale` tinyint(1) unsigned,
|
`online_only` tinyint(1) unsigned,
|
`ean13` varchar(13), |
`upc` varchar(12), |
`ecotax` decimal(17,6) DEFAULT 0.000000, |
`quantity` int, |
`minimal_quantity` int unsigned DEFAULT 1, |
`price` decimal(20,6) DEFAULT 0.000000, |
`wholesale_price` decimal(20,6) DEFAULT 0.000000, |
`unity` varchar(255), |
`unit_price_ratio` decimal(20,6) DEFAULT 0.000000, |
`additional_shipping_cost` decimal(20,2) DEFAULT 0.00, |
`reference` varchar(32), |
`supplier_reference` varchar(32), |
`location` varchar(64), |
`width` decimal(20,6) DEFAULT 0.000000, |
`height` decimal(20,6) DEFAULT 0.000000, |
`depth` decimal(20,6) DEFAULT 0.000000, |
`weight` decimal(20,6) DEFAULT 0.000000, |
`out_of_stock` int unsigned DEFAULT 2, |
`quantity_discount` tinyint(1) DEFAULT 0, |
`customizable` tinyint(2),
|
`uploadable_files` tinyint(4),
|
`text_fields` tinyint(4),
|
`active` tinyint(1) unsigned,
|
`redirect_type` enum('','404','301','302') DEFAULT '', |
`id_product_redirected` int unsigned, |
`available_for_order` tinyint(1) DEFAULT 1, |
`available_date` date, |
`condition` enum('new','used','refurbished') DEFAULT 'new', |
`show_price` tinyint(1) DEFAULT 1, |
`indexed` tinyint(1),
|
`visibility` enum('both','catalog','search','none') DEFAULT 'both', |
`cache_is_pack` tinyint(1),
|
`cache_has_attachments` tinyint(1),
|
`is_virtual` tinyint(1),
|
`cache_default_attribute` int unsigned, |
`date_add` datetime,
|
`date_upd` datetime,
|
`advanced_stock_management` tinyint(1),
|
PRIMARY KEY (`id_product`) |
) ENGINE=MyISAM;
|
|
|
INSERT INTO `t5` VALUES (102,0,5,23,1,1,0,0,'','',0.000000,0,1,391.666667,0.000000,'',0.000000,0.00,'3051','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:47:53',0),(103,0,5,23,1,1,0,0,'','',0.000000,0,1,441.666667,0.000000,'',0.000000,0.00,'3006','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:02',0),(104,0,5,23,1,1,0,0,'','',0.000000,0,1,400.000000,0.000000,'',0.000000,0.00,'3151','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:11',0),(105,0,5,23,1,1,0,0,'','',0.000000,0,1,400.000000,0.000000,'',0.000000,0.00,'3100','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:18',0),(106,0,5,23,1,1,0,0,'','',0.000000,0,1,441.666667,0.000000,'',0.000000,0.00,'3106','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:24',0),(107,0,5,23,1,1,0,0,'','',0.000000,0,1,466.666667,0.000000,'',0.000000,0.00,'3049','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:30',0),(108,0,5,23,1,1,0,0,'','',0.000000,0,1,466.666667,0.000000,'',0.000000,0.00,'3067','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:37',0),(109,0,5,23,1,1,0,0,'','',0.000000,0,1,516.666667,0.000000,'',0.000000,0.00,'3066','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:49',0),(110,0,5,23,1,1,0,0,'','',0.000000,0,1,433.333333,0.000000,'',0.000000,0.00,'3020','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:48:56',0),(111,0,5,23,1,1,0,0,'','',0.000000,0,1,433.333333,0.000000,'',0.000000,0.00,'3021','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:49:17',0),(112,0,5,23,1,1,0,0,'','',0.000000,0,1,483.333333,0.000000,'',0.000000,0.00,'3026','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:49:23',0),(113,0,5,23,1,1,0,0,'','',0.000000,0,1,425.000000,0.000000,'',0.000000,0.00,'30002','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:49:32',0),(114,0,5,23,1,1,0,0,'','',0.000000,0,1,425.000000,0.000000,'',0.000000,0.00,'30512','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:49:42',0),(115,0,5,23,1,1,0,0,'','',0.000000,0,1,487.500000,0.000000,'',0.000000,0.00,'30062','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:49:51',0),(116,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3000-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:17:52',0),(117,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3051-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:18:03',0),(118,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3006-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:18:14',0),(119,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3151-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 10:58:09',0),(120,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3100-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:19:07',0),(121,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3106-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:19:26',0),(122,0,5,24,1,1,0,0,'','',0.000000,0,1,314.870000,0.000000,'',0.000000,0.00,'3049-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-12 16:06:42',1),(123,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3067-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:21:24',0),(124,0,5,24,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3066-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:21:44',0),(125,0,5,25,1,1,0,0,'','',0.000000,0,1,491.666667,0.000000,'',0.000000,0.00,'30001','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:50:11',0),(126,0,5,25,1,1,0,0,'','',0.000000,0,1,491.666667,0.000000,'',0.000000,0.00,'30511','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:50:43',0),(127,0,5,25,1,1,0,0,'','',0.000000,0,1,533.333333,0.000000,'',0.000000,0.00,'30061','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:57:10',0),(128,0,5,25,1,1,0,0,'','',0.000000,0,1,525.000000,0.000000,'',0.000000,0.00,'30003','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:57:44',0),(129,0,5,25,1,1,0,0,'','',0.000000,0,1,525.000000,0.000000,'',0.000000,0.00,'30513','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:58:22',0),(130,0,5,25,1,1,0,0,'','',0.000000,0,1,558.333333,0.000000,'',0.000000,0.00,'30063','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:58:53',0),(131,0,5,25,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'30201','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:51:23',0),(132,0,5,25,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'30211','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 19:43:32',0),(133,0,5,25,1,1,0,0,'','',0.000000,0,1,533.333333,0.000000,'',0.000000,0.00,'30261','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:51:44',0),(134,0,5,13,1,1,0,0,'','',0.000000,0,1,158.333333,0.000000,'',0.000000,0.00,'5149','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:52:10',1),(135,0,5,13,1,1,0,0,'','',0.000000,0,1,208.333333,0.000000,'',0.000000,0.00,'2020','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:55:49',1),(136,0,5,13,1,1,0,0,'','',0.000000,0,1,233.333333,0.000000,'',0.000000,0.00,'7900','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:56:38',0),(137,0,5,13,1,1,0,0,'','',0.000000,0,1,250.000000,0.000000,'',0.000000,0.00,'7901','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:53:37',1),(138,0,5,13,1,1,0,0,'','',0.000000,0,1,250.000000,0.000000,'',0.000000,0.00,'7951','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:53:22',1),(139,0,5,13,1,1,0,0,'','',0.000000,0,1,300.000000,0.000000,'',0.000000,0.00,'2000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:53:14',1),(140,0,5,13,1,1,0,0,'','',0.000000,0,1,300.000000,0.000000,'',0.000000,0.00,'2051','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:52:57',1),(141,0,5,13,1,1,0,0,'','',0.000000,0,1,270.833333,0.000000,'',0.000000,0.00,'2049','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:59:25',1),(142,0,5,13,1,1,0,0,'','',0.000000,0,1,325.000000,0.000000,'',0.000000,0.00,'2067','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:52:41',1),(143,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'7900-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:24:08',0),(144,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'7901-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:26:15',0),(145,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'7951-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:26:45',0),(146,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2000-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:32:54',0),(147,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2051-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:33:33',0),(148,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-03 00:31:46',0),(149,0,5,18,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2067-24','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-02 23:35:19',0),(150,0,5,19,1,1,0,0,'','',0.000000,0,1,400.000000,0.000000,'',0.000000,0.00,'51494','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:54:03',0),(151,0,5,19,1,1,0,0,'','',0.000000,0,1,441.666667,0.000000,'',0.000000,0.00,'20204','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:56:04',0),(152,0,5,19,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'79004','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:56:55',0),(153,0,5,19,1,1,0,0,'','',0.000000,0,1,541.666667,0.000000,'',0.000000,0.00,'79014','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:57:26',0),(154,0,5,19,1,1,0,0,'','',0.000000,0,1,541.666667,0.000000,'',0.000000,0.00,'79514','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:58:07',0),(155,0,5,19,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'20004','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:58:38',0),(156,0,5,19,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'20514','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:59:09',0),(157,0,5,19,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'20494','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:59:40',0),(158,0,5,19,1,1,0,0,'','',0.000000,0,1,508.333333,0.000000,'',0.000000,0.00,'20674','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:59:55',0),(159,0,5,12,1,1,0,0,'','',0.000000,0,1,370.833333,0.000000,'8',0.000000,0.00,'4411','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:46:17',0),(160,0,5,12,1,1,0,0,'','',0.000000,0,1,412.500000,0.000000,'8',0.000000,0.00,'4421','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,0,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:55:33',0),(161,0,5,12,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'8',0.000000,0.00,'4422','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 19:45:31',0),(162,0,5,9,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'8130','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,0,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-12 17:18:33',1),(163,0,5,9,1,1,0,0,'','',0.000000,0,1,300.000000,0.000000,'',0.000000,0.00,'8132','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:55:05',1),(164,0,5,26,1,1,0,0,'','',0.000000,0,1,200.000000,0.000000,'',0.000000,0.00,'2151','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:54:31',1),(165,0,5,26,1,1,0,0,'','',0.000000,0,1,158.333333,0.000000,'',0.000000,0.00,'2121','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:56:21',0),(166,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3320','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 11:02:29',0),(167,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3321','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 11:01:55',0),(168,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3367','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 11:01:25',0),(169,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3349','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 11:00:43',0),(170,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'33672','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 10:59:45',0),(171,0,5,11,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'33492','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-08 10:59:20',0),(172,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30100','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:26:08',0),(173,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30200','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:26:24',0),(174,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'39000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:24:39',0),(175,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15305','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:09:45',0),(176,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3020-D','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:26:39',0),(177,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3020-20','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:19:39',0),(178,0,5,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'31900','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:24:49',0),(179,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'1204','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 21:17:33',0),(180,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'10200','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-11-06 00:09:30',0),(181,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15201','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 18:19:08',0),(182,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15303','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:22:04',0),(183,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15304','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:09:59',0),(184,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15320','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:22:14',0),(185,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15321','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:22:30',0),(186,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15444','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 18:53:01',0),(187,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'16300','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 18:30:30',0),(188,0,5,14,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'17920','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-10-12 16:01:13',1),(189,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'18000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 18:54:54',0),(190,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-10','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:12:01',0),(191,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-10X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:12:14',0),(192,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-20','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:18:05',0),(193,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-20X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 21:17:08',0),(194,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-32','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:18:18',0),(195,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-D','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:44:52',0),(196,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-Y','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:27:43',0),(197,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2020-X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:24:19',0),(198,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-10','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:18:30',0),(199,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-10X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:17:47',0),(200,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-20','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:18:44',0),(201,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-20X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:18:11',0),(202,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-32','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:18:56',0),(203,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-32X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:18:50',0),(204,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-D','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 19:41:42',0),(205,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'49000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:24:57',0),(315372,0,0,30,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15306','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-06 00:05:04','2014-02-25 20:10:14',0),(207,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'7921','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 17:47:56',0),(208,0,5,32,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'20100','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:26:52',0),(209,0,5,32,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'21163','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 17:47:41',0),(210,0,5,32,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'29000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:25:19',0),(211,0,5,32,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2221','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 18:08:26',0),(212,0,5,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'8110','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 20:01:49',0),(213,0,5,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'81007','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:22:39',0),(101,0,5,23,1,1,0,0,'','',0.000000,0,1,391.666667,0.000000,'',0.000000,0.00,'3000','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 00:47:46',0),(214,0,5,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'81301','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:22:49',0),(215,0,5,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'8131','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2013-12-28 20:05:12',0),(216,0,5,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'49030','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 14:28:57','2014-02-25 20:25:31',0),(315355,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30004','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 15:58:29','2013-10-02 22:30:35',0),(315356,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30064','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 15:59:42','2013-10-02 22:31:28',0),(315357,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30514','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:00:16','2013-10-02 22:32:24',0),(315368,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15302','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-05 23:10:41','2014-02-25 20:23:07',0),(315358,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30204','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:00:38','2013-10-12 17:06:52',0),(315359,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30264','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:00:59','2013-10-12 17:05:23',0),(315360,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30214','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:01:21','2013-10-12 17:05:39',0),(315365,0,0,13,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2021','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-25 11:22:09','2013-10-03 00:24:23',0),(315361,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30005','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:01:45','2013-10-02 22:29:34',0),(315362,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30065','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:02:03','2013-10-02 22:29:43',0),(315363,0,0,27,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'30515','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 16:02:28','2013-10-02 22:29:52',0),(315364,0,0,14,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'3020-20','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-09-24 22:20:40','2014-02-25 20:19:06',0),(315367,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15301','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-05 23:04:10','2014-02-25 20:22:59',0),(315369,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15307','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-05 23:14:24','2014-02-25 20:10:05',0),(315370,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'10251','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-05 23:27:05','2013-12-28 20:34:49',0),(315371,0,0,31,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'81303','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-11-05 23:42:07','2014-02-25 20:23:16',0),(315373,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15202','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 18:17:13','2013-12-28 18:19:28',0),(315374,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15203','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 18:17:58','2013-12-28 18:58:34',0),(315375,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'16301','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 18:28:32','2013-12-28 18:29:36',0),(315376,0,5,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'16303','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 18:28:37','2013-12-28 18:30:09',0),(315377,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-Y','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 19:32:20','2013-12-28 19:53:16',0),(315378,0,0,29,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'2049-X','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 19:53:21','2013-12-28 19:54:55',0),(315379,0,0,33,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15344','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 20:15:51','2014-02-25 20:10:21',0),(315380,0,0,33,1,1,0,0,'','',0.000000,0,1,0.000000,0.000000,'',0.000000,0.00,'15345','','',0.000000,0.000000,0.000000,0.000000,2,0,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,0,0,'2013-12-28 20:15:55','2014-02-25 20:10:27',0); |
|
|
|
|
CREATE TABLE `t6` ( |
`id_product` int not null, |
`id_shop` int, |
`id_category_default` int, |
`id_tax_rules_group` int, |
`on_sale` tinyint(1),
|
`online_only` tinyint(1),
|
`ecotax` decimal(17,6) DEFAULT 0.000000, |
`minimal_quantity` int DEFAULT 1, |
`price` decimal(20,6) DEFAULT 0.000000, |
`wholesale_price` decimal(20,6) DEFAULT 0.000000, |
`unity` varchar(255), |
`unit_price_ratio` decimal(20,6) DEFAULT 0.000000, |
`additional_shipping_cost` decimal(20,2) DEFAULT 0.00, |
`customizable` tinyint(2),
|
`uploadable_files` tinyint(4),
|
`text_fields` tinyint(4),
|
`active` tinyint(1),
|
`redirect_type` enum('','404','301','302') DEFAULT '', |
`id_product_redirected` int, |
`available_for_order` tinyint(1) DEFAULT 1, |
`available_date` date, |
`condition` enum('new','used','refurbished') DEFAULT 'new', |
`show_price` tinyint(1) DEFAULT 1, |
`indexed` tinyint(1),
|
`visibility` enum('both','catalog','search','none') DEFAULT 'both', |
`cache_default_attribute` int, |
`advanced_stock_management` tinyint(1),
|
`date_add` datetime,
|
`date_upd` datetime,
|
PRIMARY KEY (`id_product`,`id_shop`) |
) ENGINE=MyISAM ;
|
|
|
INSERT INTO `t6` VALUES (315360,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:01:21','2013-10-12 17:05:39'),(315367,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-05 23:04:10','2014-02-25 20:22:59'),(315359,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:00:59','2013-10-12 17:05:23'),(315358,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:00:38','2013-10-12 17:06:52'),(315357,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:00:16','2013-10-02 22:32:24'),(315356,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 15:59:42','2013-10-02 22:31:28'),(315355,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 15:58:29','2013-10-02 22:30:35'),(216,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:25:31'),(215,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 20:05:12'),(214,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:22:49'),(213,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:22:39'),(212,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 20:01:49'),(211,1,32,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 18:08:26'),(210,1,32,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:25:19'),(209,1,32,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 17:47:41'),(208,1,32,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:26:52'),(207,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 17:47:56'),(315372,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-06 00:05:04','2014-02-25 20:10:14'),(205,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:24:57'),(204,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:41:42'),(203,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:18:50'),(202,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:18:56'),(201,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:18:11'),(200,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:18:44'),(199,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:17:47'),(198,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:18:30'),(197,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:24:19'),(196,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:27:43'),(195,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 19:44:52'),(194,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:18:18'),(193,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 21:17:08'),(192,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:18:05'),(191,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:12:14'),(190,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:12:01'),(189,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 18:54:54'),(188,1,14,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2013-10-12 16:01:13'),(187,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 18:30:30'),(186,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 18:53:01'),(185,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:22:30'),(184,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:22:14'),(183,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:09:59'),(182,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:22:04'),(181,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 18:19:08'),(180,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-11-06 00:09:30'),(179,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-12-28 21:17:33'),(178,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:24:49'),(177,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:19:39'),(176,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:26:39'),(175,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:09:45'),(174,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:24:39'),(173,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:26:24'),(172,1,30,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 20:26:08'),(171,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 10:59:20'),(170,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 10:59:45'),(169,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 11:00:43'),(168,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 11:01:25'),(167,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 11:01:55'),(166,1,11,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 11:02:29'),(165,1,26,1,0,0,0.000000,1,158.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:56:21'),(164,1,26,1,0,0,0.000000,1,200.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:54:31'),(163,1,9,1,0,0,0.000000,1,300.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:55:05'),(162,1,9,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,0,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2013-10-12 17:18:33'),(161,1,12,1,0,0,0.000000,1,0.000000,0.000000,'8',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 19:45:31'),(160,1,12,1,0,0,0.000000,1,412.500000,0.000000,'8',0.000000,0.00,0,0,0,0,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:55:33'),(159,1,12,1,0,0,0.000000,1,370.833333,0.000000,'8',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:46:17'),(158,1,19,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:59:55'),(157,1,19,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:59:40'),(156,1,19,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:59:09'),(155,1,19,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:58:38'),(154,1,19,1,0,0,0.000000,1,541.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:58:07'),(153,1,19,1,0,0,0.000000,1,541.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:57:26'),(152,1,19,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:56:55'),(151,1,19,1,0,0,0.000000,1,441.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:56:04'),(150,1,19,1,0,0,0.000000,1,400.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:54:03'),(149,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:35:19'),(148,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-03 00:31:46'),(147,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:33:33'),(146,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:32:54'),(145,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:26:45'),(144,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:26:15'),(143,1,18,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:24:08'),(142,1,13,1,0,0,0.000000,1,325.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:52:41'),(141,1,13,1,0,0,0.000000,1,270.833333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:59:25'),(140,1,13,1,0,0,0.000000,1,300.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:52:57'),(139,1,13,1,0,0,0.000000,1,300.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:53:14'),(138,1,13,1,0,0,0.000000,1,250.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:53:22'),(137,1,13,1,0,0,0.000000,1,250.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:53:37'),(136,1,13,1,0,0,0.000000,1,233.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:56:38'),(135,1,13,1,0,0,0.000000,1,208.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:55:49'),(134,1,13,1,0,0,0.000000,1,158.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2014-02-25 00:52:10'),(133,1,25,1,0,0,0.000000,1,533.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:51:44'),(132,1,25,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 19:43:32'),(131,1,25,1,0,0,0.000000,1,508.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:51:23'),(130,1,25,1,0,0,0.000000,1,558.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:58:53'),(129,1,25,1,0,0,0.000000,1,525.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:58:22'),(128,1,25,1,0,0,0.000000,1,525.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:57:44'),(127,1,25,1,0,0,0.000000,1,533.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:57:10'),(126,1,25,1,0,0,0.000000,1,491.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:50:43'),(125,1,25,1,0,0,0.000000,1,491.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:50:11'),(124,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:21:44'),(123,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:21:24'),(122,1,24,1,0,0,0.000000,1,314.870000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,1,'2013-09-24 14:28:57','2013-10-12 16:06:42'),(121,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:19:26'),(120,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:19:07'),(119,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-08 10:58:09'),(118,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:18:14'),(117,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:18:03'),(116,1,24,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2013-10-02 23:17:52'),(115,1,23,1,0,0,0.000000,1,487.500000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:49:51'),(114,1,23,1,0,0,0.000000,1,425.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:49:42'),(113,1,23,1,0,0,0.000000,1,425.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:49:32'),(112,1,23,1,0,0,0.000000,1,483.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:49:23'),(111,1,23,1,0,0,0.000000,1,433.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:49:17'),(110,1,23,1,0,0,0.000000,1,433.333333,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:56'),(109,1,23,1,0,0,0.000000,1,516.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:49'),(108,1,23,1,0,0,0.000000,1,466.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:37'),(107,1,23,1,0,0,0.000000,1,466.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:30'),(106,1,23,1,0,0,0.000000,1,441.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:24'),(105,1,23,1,0,0,0.000000,1,400.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:18'),(104,1,23,1,0,0,0.000000,1,400.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:11'),(101,1,23,1,0,0,0.000000,1,391.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:47:46'),(102,1,23,1,0,0,0.000000,1,391.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:47:53'),(103,1,23,1,0,0,0.000000,1,441.666667,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 14:28:57','2014-02-25 00:48:02'),(315365,1,13,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-25 11:22:09','2013-10-03 00:24:23'),(315361,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:01:45','2013-10-02 22:29:34'),(315362,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:02:03','2013-10-02 22:29:43'),(315363,1,27,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 16:02:28','2013-10-02 22:29:52'),(315368,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-05 23:10:41','2014-02-25 20:23:07'),(315364,1,14,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-09-24 22:20:40','2014-02-25 20:19:06'),(315369,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-05 23:14:24','2014-02-25 20:10:05'),(315370,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-05 23:27:05','2013-12-28 20:34:49'),(315371,1,31,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-11-05 23:42:07','2014-02-25 20:23:16'),(315373,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 18:17:13','2013-12-28 18:19:28'),(315374,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 18:17:58','2013-12-28 18:58:34'),(315375,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 18:28:32','2013-12-28 18:29:36'),(315376,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 18:28:37','2013-12-28 18:30:09'),(315377,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 19:32:20','2013-12-28 19:53:16'),(315378,1,29,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 19:53:21','2013-12-28 19:54:55'),(315379,1,33,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 20:15:51','2014-02-25 20:10:21'),(315380,1,33,1,0,0,0.000000,1,0.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,0,'0000-00-00','new',1,1,'both',0,0,'2013-12-28 20:15:55','2014-02-25 20:10:27'); |
CREATE TABLE `t7` ( |
`id_stock_available` int, |
`id_product` int, |
`id_product_attribute` int, |
`id_shop` int, |
`id_shop_group` int, |
`quantity` int, |
`depends_on_stock` tinyint(1),
|
`out_of_stock` tinyint(1),
|
PRIMARY KEY (`id_stock_available`) |
) ENGINE=MyISAM;
|
INSERT INTO `t7` VALUES (636,192,0,1,0,0,0,2),(637,193,0,1,0,0,0,2),(641,197,0,1,0,0,0,2),(642,198,0,1,0,0,0,2),(643,199,0,1,0,0,0,2),(644,200,0,1,0,0,0,2),(660,216,0,1,0,0,0,2),(638,194,0,1,0,0,0,2),(639,195,0,1,0,0,0,2),(640,196,0,1,0,0,0,2),(428,2,0,1,0,0,0,0),(623,179,0,1,0,0,0,2),(624,180,0,1,0,0,0,2),(625,181,0,1,0,0,0,2),(626,182,0,1,0,0,0,2),(627,183,0,1,0,0,0,2),(651,207,0,1,0,0,0,2),(35,0,0,1,0,0,0,0),(645,201,0,1,0,0,0,2),(628,184,0,1,0,0,0,2),(635,191,0,1,0,0,0,2),(629,185,0,1,0,0,0,2),(649,205,0,1,0,0,0,2),(657,213,0,1,0,0,0,2),(648,204,0,1,0,0,0,2),(646,202,0,1,0,0,0,2),(659,215,0,1,0,0,0,2),(647,203,0,1,0,0,0,2),(631,187,0,1,0,0,0,2),(634,190,0,1,0,0,0,2),(653,209,0,1,0,0,0,2),(633,189,0,1,0,0,0,2),(630,186,0,1,0,0,0,2),(632,188,0,1,0,0,1,2),(622,178,0,1,0,0,0,2),(621,177,0,1,0,0,0,2),(336,15321,0,1,0,0,0,0),(620,176,0,1,0,0,0,2),(619,175,0,1,0,0,0,2),(618,174,0,1,0,0,0,2),(617,173,0,1,0,0,0,2),(616,172,0,1,0,0,0,2),(615,171,0,1,0,0,0,2),(614,170,0,1,0,0,0,2),(613,169,0,1,0,0,0,2),(612,168,0,1,0,0,0,2),(611,167,0,1,0,0,0,2),(610,166,0,1,0,0,0,2),(609,165,0,1,0,0,0,2),(608,164,0,1,0,0,1,2),(607,163,0,1,0,0,1,2),(606,162,0,1,0,0,0,2),(605,161,0,1,0,0,0,2),(604,160,0,1,0,0,0,2),(603,159,0,1,0,-2,0,2),(602,158,0,1,0,0,0,2),(601,157,0,1,0,0,0,2),(600,156,0,1,0,0,0,2),(599,155,0,1,0,0,0,2),(598,154,0,1,0,0,0,2),(597,153,0,1,0,0,0,2),(596,152,0,1,0,0,0,2),(595,151,0,1,0,0,0,2),(594,150,0,1,0,0,0,2),(593,149,0,1,0,0,0,2),(592,148,0,1,0,0,0,2),(591,147,0,1,0,0,0,2),(590,146,0,1,0,0,0,2),(589,145,0,1,0,0,0,2),(588,144,0,1,0,0,0,2),(587,143,0,1,0,0,0,2),(586,142,0,1,0,0,1,2),(585,141,0,1,0,0,1,2),(584,140,0,1,0,0,1,2),(583,139,0,1,0,0,1,2),(582,138,0,1,0,0,1,2),(581,137,0,1,0,0,1,2),(580,136,0,1,0,0,0,2),(575,131,0,1,0,0,0,2),(577,133,0,1,0,0,0,2),(576,132,0,1,0,0,0,2),(579,135,0,1,0,0,1,2),(559,115,0,1,0,0,0,2),(560,116,0,1,0,0,0,2),(561,117,0,1,0,0,0,2),(124,15305,0,1,0,0,0,0),(578,134,0,1,0,0,0,2),(562,118,0,1,0,0,0,2),(550,106,0,1,0,0,0,2),(551,107,0,1,0,0,0,2),(129,10200,0,1,0,0,0,0),(130,15201,0,1,0,0,0,0),(131,15303,0,1,0,0,0,0),(132,15304,0,1,0,0,0,0),(552,108,0,1,0,0,0,2),(553,109,0,1,0,0,0,2),(547,103,0,1,0,0,0,2),(136,16300,0,1,0,0,0,0),(556,112,0,1,0,0,0,2),(555,111,0,1,0,0,0,2),(549,105,0,1,0,0,0,2),(558,114,0,1,0,0,0,2),(663,315357,0,1,0,0,0,2),(664,315358,0,1,0,0,0,2),(661,315355,0,1,0,0,0,2),(666,315360,0,1,0,0,0,2),(665,315359,0,1,0,0,0,2),(667,315361,0,1,0,0,0,2),(545,101,0,1,0,0,0,2),(662,315356,0,1,0,0,0,2),(546,102,0,1,0,0,0,2),(566,122,0,1,0,0,1,2),(568,124,0,1,0,0,0,2),(574,130,0,1,0,0,0,2),(571,127,0,1,0,0,0,2),(570,126,0,1,0,0,0,2),(548,104,0,1,0,0,0,2),(572,128,0,1,0,0,0,2),(557,113,0,1,0,0,0,2),(573,129,0,1,0,0,0,2),(565,121,0,1,0,0,0,2),(564,120,0,1,0,0,0,2),(563,119,0,1,0,0,0,2),(554,110,0,1,0,0,0,2),(163,81301,0,1,0,0,0,0),(569,125,0,1,0,0,0,2),(567,123,0,1,0,0,0,2),(654,210,0,1,0,0,0,2),(655,211,0,1,0,0,0,2),(656,212,0,1,0,0,0,2),(658,214,0,1,0,0,0,2),(678,315372,0,1,0,0,0,2),(652,208,0,1,0,0,0,2),(668,315362,0,1,0,0,0,2),(669,315363,0,1,0,0,0,2),(670,315364,0,1,0,0,0,2),(671,315365,0,1,0,0,0,2),(673,315367,0,1,0,0,0,2),(674,315368,0,1,0,0,0,2),(675,315369,0,1,0,0,0,2),(676,315370,0,1,0,0,0,2),(677,315371,0,1,0,0,0,2),(679,315373,0,1,0,0,0,2),(680,315374,0,1,0,0,0,2),(681,315375,0,1,0,0,0,2),(682,315376,0,1,0,0,0,2),(683,315377,0,1,0,0,0,2),(684,315378,0,1,0,0,0,2),(685,315379,0,1,0,0,0,2),(686,315380,0,1,0,0,0,2); |
|
|
|
|
SELECT * FROM t5 |
JOIN t6 ON (t6.id_product = t5.id_product AND t6.id_shop = 1) |
JOIN t2 ON (t2.id_product = t5.id_product) |
JOIN t1 ON (t1.id_category = t2.id_category AND t1.nleft >= 3 AND t1.nright <= 24 AND t1.active = 1) |
LEFT JOIN t7 ON (t7.id_product = t5.id_product) |
JOIN t4 ON (t4.id_product = t5.id_product AND t4.id_currency = 1) |
WHERE 1=1 |
AND t5.id_product IN (SELECT id_product FROM t3 WHERE t3.`id_t3` = 32) |
AND t5.id_product IN (SELECT id_product FROM t3 WHERE t3.`id_t3` = 15) |
AND t5.id_product IN (SELECT id_product FROM t3 WHERE t3.`id_t3` = 18 OR t3.`id_t3` = 19) |
AND t5.id_product IN (SELECT id_product FROM t3 WHERE t3.`id_t3` = 34 OR t3.`id_t3` = 23) |
AND t5.id_product IN (SELECT id_product FROM t3 WHERE t3.`id_t3` = 29 OR t3.`id_t3` = 28 OR t3.`id_t3` = 26); |
|
|
drop table t1,t2,t3,t4,t5,t6,t7; |
on debug, built as cmake -DWITH_EMBEDDED_SERVER=OFF -DWITH_UNIT_TESTS=OFF -DCMAKE_BUILD_TYPE=Debug -DPLUGIN_TOKUDB=NO -DPLUGIN_MROONGA=NO -DPLUGIN_OQGRAPH=NO -DPLUGIN_ROCKSDB=NO -DWITH_SSL=bundled -DWITH_VALGRIND=ON
=================================================================
|
==22878==ERROR: AddressSanitizer: heap-buffer-overflow on address 0x6290000bd670 at pc 0x5586cec0c8cb bp 0x7f6e09c28040 sp 0x7f6e09c28030
|
WRITE of size 8 at 0x6290000bd670 thread T5
|
#0 0x5586cec0c8ca in make_join_select /home/alice/git/10.2/sql/sql_select.cc:10174
|
#1 0x5586cebcf0ed in JOIN::optimize_inner() /home/alice/git/10.2/sql/sql_select.cc:1735
|
#2 0x5586cebc913c in JOIN::optimize() /home/alice/git/10.2/sql/sql_select.cc:1113
|
#3 0x5586cebe1d2e in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /home/alice/git/10.2/sql/sql_select.cc:3747
|
#4 0x5586cebc206c in handle_select(THD*, LEX*, select_result*, unsigned long) /home/alice/git/10.2/sql/sql_select.cc:376
|
#5 0x5586ceb49d35 in execute_sqlcom_select /home/alice/git/10.2/sql/sql_parse.cc:6456
|
#6 0x5586ceb36e41 in mysql_execute_command(THD*) /home/alice/git/10.2/sql/sql_parse.cc:3467
|
#7 0x5586ceb51d85 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /home/alice/git/10.2/sql/sql_parse.cc:7902
|
#8 0x5586ceb2db92 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /home/alice/git/10.2/sql/sql_parse.cc:1806
|
#9 0x5586ceb2ad46 in do_command(THD*) /home/alice/git/10.2/sql/sql_parse.cc:1360
|
#10 0x5586cee4836a in do_handle_one_connection(CONNECT*) /home/alice/git/10.2/sql/sql_connect.cc:1335
|
#11 0x5586cee47d72 in handle_one_connection /home/alice/git/10.2/sql/sql_connect.cc:1241
|
#12 0x5586cf618a27 in pfs_spawn_thread /home/alice/git/10.2/storage/perfschema/pfs.cc:1862
|
#13 0x7f6e144426b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
|
#14 0x7f6e138d741c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)
|
|
|
0x6290000bd670 is located 8 bytes to the right of 17512-byte region [0x6290000b9200,0x6290000bd668)
|
allocated by thread T5 here:
|
#0 0x7f6e14f48602 in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x98602)
|
#1 0x5586d00ddd74 in my_malloc /home/alice/git/10.2/mysys/my_malloc.c:101
|
#2 0x5586d00bfcb6 in alloc_root /home/alice/git/10.2/mysys/my_alloc.c:188
|
#3 0x5586d00c007d in multi_alloc_root /home/alice/git/10.2/mysys/my_alloc.c:309
|
#4 0x5586cebe2a0b in make_join_statistics /home/alice/git/10.2/sql/sql_select.cc:3863
|
#5 0x5586cebcd066 in JOIN::optimize_inner() /home/alice/git/10.2/sql/sql_select.cc:1537
|
#6 0x5586cebc913c in JOIN::optimize() /home/alice/git/10.2/sql/sql_select.cc:1113
|
#7 0x5586cebe1d2e in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /home/alice/git/10.2/sql/sql_select.cc:3747
|
#8 0x5586cebc206c in handle_select(THD*, LEX*, select_result*, unsigned long) /home/alice/git/10.2/sql/sql_select.cc:376
|
#9 0x5586ceb49d35 in execute_sqlcom_select /home/alice/git/10.2/sql/sql_parse.cc:6456
|
#10 0x5586ceb36e41 in mysql_execute_command(THD*) /home/alice/git/10.2/sql/sql_parse.cc:3467
|
#11 0x5586ceb51d85 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /home/alice/git/10.2/sql/sql_parse.cc:7902
|
#12 0x5586ceb2db92 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /home/alice/git/10.2/sql/sql_parse.cc:1806
|
#13 0x5586ceb2ad46 in do_command(THD*) /home/alice/git/10.2/sql/sql_parse.cc:1360
|
#14 0x5586cee4836a in do_handle_one_connection(CONNECT*) /home/alice/git/10.2/sql/sql_connect.cc:1335
|
#15 0x5586cee47d72 in handle_one_connection /home/alice/git/10.2/sql/sql_connect.cc:1241
|
#16 0x5586cf618a27 in pfs_spawn_thread /home/alice/git/10.2/storage/perfschema/pfs.cc:1862
|
#17 0x7f6e144426b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
|
|
|
Thread T5 created by T0 here:
|
#0 0x7f6e14ee6253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)
|
#1 0x5586cf618e14 in spawn_thread_v1 /home/alice/git/10.2/storage/perfschema/pfs.cc:1912
|
#2 0x5586ce93bc26 in inline_mysql_thread_create /home/alice/git/10.2/include/mysql/psi/mysql_thread.h:1239
|
#3 0x5586ce94ffed in create_thread_to_handle_connection(CONNECT*) /home/alice/git/10.2/sql/mysqld.cc:6431
|
#4 0x5586ce9506ed in create_new_thread /home/alice/git/10.2/sql/mysqld.cc:6501
|
#5 0x5586ce951719 in handle_connections_sockets() /home/alice/git/10.2/sql/mysqld.cc:6776
|
#6 0x5586ce94f53a in mysqld_main(int, char**) /home/alice/git/10.2/sql/mysqld.cc:6050
|
#7 0x5586ce93a5bf in main /home/alice/git/10.2/sql/main.cc:25
|
#8 0x7f6e137f082f in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x2082f)
|
if I build only with -DCMAKE_BUILD_TYPE=Debug, I get sql_class.cc:1650: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed, but no backtrace.
| Assignee | Alice Sherepa [ alice ] | Igor Babaev [ igor ] |
I do not see SET NAMES 'utf8'; in your test case. Did you try with this?
| Link |
This issue is duplicated by |
It looks like I hit the same problem on MariaDB 10.2.13. The database server produces a segmentation fault on a specific SELECT query.
My application sets the character set to utf8mb4. When I change it to utf8, the query does not trigger the crash anymore. When I prefix the query with EXPLAIN to see the query plan, the crash is triggered for both the utf8mb4 and utf8 character sets as well as the latin1 character set (did not try others yet).
The query is a select query reading from InnoDB tables. I run the CentOS RPMs that are offered here:
http://yum.mariadb.org/10.2/centos7-amd64/rpms/
which do not include a version with debugging symbols. So, the stack trace is not very detailed but here it is:
180319 12:28:11 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.2.13-MariaDB
|
key_buffer_size=33554432
|
read_buffer_size=131072
|
max_used_connections=73
|
max_threads=502
|
thread_count=79
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1135817 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7f0de99bc8e8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f0e74a30d70 thread_stack 0x49000
|
//sbin/mysqld(my_print_stacktrace+0x2e)[0x560fcb8566ce]
|
//sbin/mysqld(handle_fatal_signal+0x355)[0x560fcb2de085]
|
sigaction.c:0(__restore_rt)[0x7f0eda2b25e0]
|
//sbin/mysqld(_ZN10TABLE_LIST33is_with_table_recursive_referenceEv+0x1)[0x560fcb26fc61]
|
sql/sql_cte.cc:1093(TABLE_LIST::is_with_table_recursive_reference())[0x560fcb187df8]
|
sql/sql_select.cc:11767(st_join_table::cleanup())[0x560fcb188478]
|
sql/sql_select.cc:12201(JOIN::cleanup(bool))[0x560fcb18876c]
|
sql/sql_select.cc:12102(JOIN::join_free())[0x560fcb19fc55]
|
sql/sql_select.cc:18283(JOIN::exec_inner())[0x560fcb19fef3]
|
sql/sql_select.cc:3362(JOIN::exec())[0x560fcb1a004a]
|
sql/sql_select.cc:3763(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x560fcb1a0ba4]
|
sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x560fcb085eb9]
|
sql/sql_parse.cc:6457(execute_sqlcom_select(THD*, TABLE_LIST*))[0x560fcb150495]
|
sql/sql_parse.cc:3467(mysql_execute_command(THD*))[0x560fcb152d5e]
|
sql/sql_parse.cc:1806(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560fcb155d9e]
|
sql/sql_parse.cc:1362(do_command(THD*))[0x560fcb156999]
|
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x560fcb21b23a]
|
sql/sql_connect.cc:1243(handle_one_connection)[0x560fcb21b35d]
|
pthread_create.c:0(start_thread)[0x7f0eda2aae25]
|
/lib64/libc.so.6(clone+0x6d)[0x7f0ed888234d]
|
In case it is valuable to try and produce more details about the crash, please let me know.
I am planning to drop the database that reproduces this crash, please let me know if there is anything I can do to help.
10.3 3bbc30c73b3db
Thread 1 (Thread 0x7fde3c421700 (LWP 4528)):
|
#0 0x00007fde412dd428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#1 0x00007fde412df02a in __GI_abort () at abort.c:89
|
#2 0x00007fde4131f7ea in __libc_message (do_abort=do_abort@entry=2, fmt=fmt@entry=0x7fde41438ed8 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/posix/libc_fatal.c:175
|
#3 0x00007fde4132a651 in malloc_printerr (ar_ptr=0x7fde3c41f0b0, ptr=0x7fde201782e0, str=0x7fde414392e0 "malloc(): memory corruption (fast)", action=3) at malloc.c:5006
|
#4 _int_malloc (av=av@entry=0x7fde20000020, bytes=bytes@entry=56) at malloc.c:3386
|
#5 0x00007fde4132c184 in __GI___libc_malloc (bytes=bytes@entry=56) at malloc.c:2913
|
#6 0x00007fde4307c737 in _dl_map_object_deps (map=map@entry=0x7fde43269000, preloads=preloads@entry=0x0, npreloads=npreloads@entry=0, trace_mode=trace_mode@entry=0, open_mode=open_mode@entry=-2147483648) at dl-deps.c:499
|
#7 0x00007fde430835e2 in dl_open_worker (a=a@entry=0x7fde3c41f520) at dl-open.c:280
|
#8 0x00007fde4307e564 in _dl_catch_error (objname=objname@entry=0x7fde3c41f510, errstring=errstring@entry=0x7fde3c41f518, mallocedp=mallocedp@entry=0x7fde3c41f50f, operate=operate@entry=0x7fde430834d0 <dl_open_worker>, args=args@entry=0x7fde3c41f520) at dl-error.c:187
|
#9 0x00007fde43082da9 in _dl_open (file=0x7fde41434686 "libgcc_s.so.1", mode=-2147483647, caller_dlopen=0x7fde413bda85 <init+21>, nsid=-2, argc=<optimized out>, argv=<optimized out>, env=0x7ffec9f594a0) at dl-open.c:660
|
#10 0x00007fde413eb5ad in do_dlopen (ptr=ptr@entry=0x7fde3c41f740) at dl-libc.c:87
|
#11 0x00007fde4307e564 in _dl_catch_error (objname=0x7fde3c41f730, errstring=0x7fde3c41f738, mallocedp=0x7fde3c41f72f, operate=0x7fde413eb570 <do_dlopen>, args=0x7fde3c41f740) at dl-error.c:187
|
#12 0x00007fde413eb664 in dlerror_run (args=0x7fde3c41f740, operate=0x7fde413eb570 <do_dlopen>) at dl-libc.c:46
|
#13 __GI___libc_dlopen_mode (name=name@entry=0x7fde41434686 "libgcc_s.so.1", mode=mode@entry=-2147483647) at dl-libc.c:163
|
#14 0x00007fde413bda85 in init () at ../sysdeps/x86_64/backtrace.c:52
|
#15 0x00007fde41f21a99 in __pthread_once_slow (once_control=0x7fde41670110 <once>, init_routine=0x7fde413bda70 <init>) at pthread_once.c:116
|
#16 0x00007fde413bdba4 in __GI___backtrace (array=<optimized out>, size=<optimized out>) at ../sysdeps/x86_64/backtrace.c:105
|
#17 0x000055a32e4a270b in my_print_stacktrace (stack_bottom=0x7fde3c420e70 "\230\n", thread_stack=299008, silent=0 '\000') at /home/alice/git/10.3/mysys/stacktrace.c:269
|
#18 0x000055a32dc90d68 in handle_fatal_signal (sig=11) at /home/alice/git/10.3/sql/signal_handler.cc:166
|
#19 <signal handler called>
|
#20 __memset_avx2 () at ../sysdeps/x86_64/multiarch/memset-avx2.S:161
|
#21 0x000055a32e49a0c9 in my_free (ptr=0x7fde20037398) at /home/alice/git/10.3/mysys/my_malloc.c:220
|
#22 0x000055a32e48ac26 in free_root (root=0x7fde20006110, MyFlags=1) at /home/alice/git/10.3/mysys/my_alloc.c:418
|
#23 0x000055a32d993df4 in dispatch_command (command=COM_QUERY, thd=0x7fde20000a98, packet=0x7fde2014e539 '\217' <repeats 200 times>..., packet_length=786, is_com_multi=false, is_next_command=false) at /home/alice/git/10.3/sql/sql_parse.cc:2436
|
#24 0x000055a32d990a14 in do_command (thd=0x7fde20000a98) at /home/alice/git/10.3/sql/sql_parse.cc:1391
|
#25 0x000055a32dafb957 in do_handle_one_connection (connect=0x55a331c25778) at /home/alice/git/10.3/sql/sql_connect.cc:1402
|
#26 0x000055a32dafb6a8 in handle_one_connection (arg=0x55a331c25778) at /home/alice/git/10.3/sql/sql_connect.cc:1308
|
#27 0x000055a32dee18d6 in pfs_spawn_thread (arg=0x55a331c1f648) at /home/alice/git/10.3/storage/perfschema/pfs.cc:1862
|
#28 0x00007fde41f1a6ba in start_thread (arg=0x7fde3c421700) at pthread_create.c:333
|
#29 0x00007fde413af41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Igor Babaev [ igor ] | Varun Gupta [ varun ] |
| Comment |
[ Looks like another materialization bug.
If I run the query provided in description with the optimizer_switch='materialization=off ', then i don't see any crash. ] |
| Assignee | Varun Gupta [ varun ] | Sergei Petrunia [ psergey ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Link |
This issue is duplicated by |
| Assignee | Sergei Petrunia [ psergey ] | Varun Gupta [ varun ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.0.36 [ 22916 ] | |
| Fix Version/s | 10.1.35 [ 23116 ] | |
| Fix Version/s | 10.2.16 [ 23110 ] | |
| Fix Version/s | 10.3.8 [ 23113 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 85489 ] | MariaDB v4 [ 153761 ] |
Thanks for the report and test case.
Oddly, for me the crash is only reproducible with a non-debug build.
ASAN also throws errors, but also on a non-debug build.
Valgrind produces 'Invalid read'.
Here is a somewhat shortened test case. I've intentionally kept the problematic query intact, only the dump is a bit reduced, and put together with the query in an MTR-like test case.
10.2 valgrind 5a7b6db6711
==13948== Invalid write of size 8==13948== at 0x7194CE: make_join_select(JOIN*, SQL_SELECT*, Item*) (sql_select.cc:10174)==13948== by 0x70103B: JOIN::optimize_inner() (sql_select.cc:1735)==13948== by 0x6FEA4C: JOIN::optimize() (sql_select.cc:1113)==13948== by 0x707CEB: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:3747)==13948== by 0x6FC241: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:376)==13948== by 0x6C7516: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6456)==13948== by 0x6BD59B: mysql_execute_command(THD*) (sql_parse.cc:3467)==13948== by 0x6CAF4C: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7902)==13948== by 0x6B8E6A: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1806)==13948== by 0x6B77CD: do_command(THD*) (sql_parse.cc:1360)==13948== by 0x80B6BD: do_handle_one_connection(CONNECT*) (sql_connect.cc:1335)==13948== by 0x80B44A: handle_one_connection (sql_connect.cc:1241)==13948== by 0xC4BE85: pfs_spawn_thread (pfs.cc:1862)==13948== by 0x4E3F493: start_thread (pthread_create.c:333)==13948== by 0x6A9A93E: clone (clone.S:97)==13948== Address 0xe663bd0 is 8 bytes after a block of size 17,512 alloc'd==13948== at 0x4C2BBAF: malloc (vg_replace_malloc.c:299)==13948== by 0x10EE236: my_malloc (my_malloc.c:101)==13948== by 0x10DF18C: alloc_root (my_alloc.c:188)==13948== by 0x10DF3AD: multi_alloc_root (my_alloc.c:309)==13948== by 0x708218: make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*) (sql_select.cc:3871)==13948== by 0x7002B7: JOIN::optimize_inner() (sql_select.cc:1537)==13948== by 0x6FEA4C: JOIN::optimize() (sql_select.cc:1113)==13948== by 0x707CEB: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:3747)==13948== by 0x6FC241: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:376)==13948== by 0x6C7516: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6456)==13948== by 0x6BD59B: mysql_execute_command(THD*) (sql_parse.cc:3467)==13948== by 0x6CAF4C: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7902)==13948== by 0x6B8E6A: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1806)==13948== by 0x6B77CD: do_command(THD*) (sql_parse.cc:1360)==13948== by 0x80B6BD: do_handle_one_connection(CONNECT*) (sql_connect.cc:1335)==13948== by 0x80B44A: handle_one_connection (sql_connect.cc:1241)10.2 non-debug asan 5a7b6db671
==14160==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x5591b4515122 sp 0x7f3273428330 bp 0x0c5a00051d0e T5)#0 0x5591b4515121 in TABLE_LIST::is_with_table_recursive_reference() /data/src/10.2/sql/sql_cte.cc:1097#1 0x5591b421a026 in st_join_table::cleanup() /data/src/10.2/sql/sql_select.cc:11767#2 0x5591b421b236 in JOIN::cleanup(bool) /data/src/10.2/sql/sql_select.cc:12200#3 0x5591b421c6d3 in JOIN::join_free() /data/src/10.2/sql/sql_select.cc:12106#4 0x5591b42733ac in do_select /data/src/10.2/sql/sql_select.cc:18281#5 0x5591b42733ac in JOIN::exec_inner() /data/src/10.2/sql/sql_select.cc:3566#6 0x5591b4274233 in JOIN::exec() /data/src/10.2/sql/sql_select.cc:3361#7 0x5591b4274636 in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/src/10.2/sql/sql_select.cc:3761#8 0x5591b4276f4b in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.2/sql/sql_select.cc:376#9 0x5591b3f315f6 in execute_sqlcom_select /data/src/10.2/sql/sql_parse.cc:6456#10 0x5591b416bc80 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:3467#11 0x5591b417d593 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7902#12 0x5591b418466a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1806#13 0x5591b41866ff in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1360#14 0x5591b440a5c7 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1335#15 0x5591b440aaba in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241#16 0x5591b4d59426 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1862#17 0x7f327f7ba493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)#18 0x7f327dba093e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)10.2 non-debug 5a7b6db6711
#2 <signal handler called>#3 TABLE_LIST::is_with_table_recursive_reference (this=0x4048800000000000) at /data/src/10.2/sql/sql_cte.cc:1097#4 0x000055b532617197 in st_join_table::cleanup (this=0x7fc3301873d8) at /data/src/10.2/sql/sql_select.cc:11767#5 0x000055b532617848 in JOIN::cleanup (this=0x7fc3300429e0, full=full@entry=true) at /data/src/10.2/sql/sql_select.cc:12200#6 0x000055b532617bd9 in JOIN::join_free (this=this@entry=0x7fc3300429e0) at /data/src/10.2/sql/sql_select.cc:12106#7 0x000055b532630cdc in do_select (procedure=<optimized out>, join=0x7fc3300429e0) at /data/src/10.2/sql/sql_select.cc:18281#8 JOIN::exec_inner (this=this@entry=0x7fc3300429e0) at /data/src/10.2/sql/sql_select.cc:3566#9 0x000055b532630fb9 in JOIN::exec (this=this@entry=0x7fc3300429e0) at /data/src/10.2/sql/sql_select.cc:3361#10 0x000055b5326310fb in mysql_select (thd=thd@entry=0x7fc3300009a8, tables=0x7fc3300104a8, wild_num=0, fields=..., conds=0x7fc33004e098, og_num=1, order=0x0, group=0x7fc330042760, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc3300429c0, unit=0x7fc330004390, select_lex=0x7fc330004ac8) at /data/src/10.2/sql/sql_select.cc:3761#11 0x000055b532631b06 in handle_select (thd=thd@entry=0x7fc3300009a8, lex=lex@entry=0x7fc3300042c8, result=result@entry=0x7fc3300429c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:376#12 0x000055b53252275f in execute_sqlcom_select (thd=0x7fc3300009a8, all_tables=0x7fc3300104a8) at /data/src/10.2/sql/sql_parse.cc:6456#13 0x000055b5325e05c9 in mysql_execute_command (thd=0x7fc3300009a8) at /data/src/10.2/sql/sql_parse.cc:3467#14 0x000055b5325e2bc9 in mysql_parse (thd=0x7fc3300009a8, rawbuf=<optimized out>, length=1357, parser_state=0x7fc340377240, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.2/sql/sql_parse.cc:7902#15 0x000055b5325e5624 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc3300009a8, packet=packet@entry=0x7fc330035109 "", packet_length=packet_length@entry=1357, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1806#16 0x000055b5325e5ec3 in do_command (thd=0x7fc3300009a8) at /data/src/10.2/sql/sql_parse.cc:1360#17 0x000055b5326ad924 in do_handle_one_connection (connect=connect@entry=0x55b534b5d088) at /data/src/10.2/sql/sql_connect.cc:1335#18 0x000055b5326adac4 in handle_one_connection (arg=arg@entry=0x55b534b5d088) at /data/src/10.2/sql/sql_connect.cc:1241#19 0x000055b53296e1c4 in pfs_spawn_thread (arg=0x55b534b125f8) at /data/src/10.2/storage/perfschema/pfs.cc:1862#20 0x00007fc347d74494 in start_thread (arg=0x7fc340378700) at pthread_create.c:333#21 0x00007fc34615a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6