[NO ISSUE] Add CH2 tests in Analyze Suite
- user mode changes: no
- storage format changes: no
- interface changes: no
Ext-ref: MB-66167
Change-Id: I1798b2ada96cf5de539ee7c77e3c307954cda0fe
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19629
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Ian Maxon <imaxon@apache.org>
Contrib: Ian Maxon <imaxon@apache.org>
diff --git a/asterixdb/asterix-app/pom.xml b/asterixdb/asterix-app/pom.xml
index f74a995..7cd2cb8 100644
--- a/asterixdb/asterix-app/pom.xml
+++ b/asterixdb/asterix-app/pom.xml
@@ -38,6 +38,7 @@
<appendedResourcesDirectory>${basedir}/src/main/appended-resources</appendedResourcesDirectory>
<sonar.sources>pom.xml,src/main/java,src/main/resources</sonar.sources>
<pip.path>${project.build.directory}/bin/pip3</pip.path>
+ <pypip.path>${project.build.directory}/bin/python</pypip.path>
<shiv.path>${project.build.directory}/bin/shiv</shiv.path>
<asterix-test-datagenerator-maven-plugin.version>${project.version}</asterix-test-datagenerator-maven-plugin.version>
</properties>
@@ -337,6 +338,72 @@
<async>true</async>
</configuration>
</execution>
+ <execution>
+ <id>clone-ch2</id>
+ <phase>${prepare-env.stage}</phase>
+ <goals>
+ <goal>exec</goal>
+ </goals>
+ <configuration>
+ <executable>git</executable>
+ <arguments>
+ <argument>clone</argument>
+ <argument>https://github.com/couchbaselabs/ch2.git</argument>
+ <argument>${project.build.directory}/ch2</argument>
+ </arguments>
+ </configuration>
+ </execution>
+ <execution>
+ <id>numpy-install</id>
+ <phase>${prepare-env.stage}</phase>
+ <goals>
+ <goal>exec</goal>
+ </goals>
+ <configuration>
+ <executable>${pip.path}</executable>
+ <workingDirectory>${project.build.directory}</workingDirectory>
+ <arguments>
+ <argument>install</argument>
+ <argument>-r </argument>
+ <argument>ch2/requirements.txt</argument>
+ </arguments>
+ <environmentVariables>
+ <VIRTUALENV>${project.build.directory}</VIRTUALENV>
+ <PATH>${project.build.directory}${path.separator}${env.PATH}${file.separator}bin</PATH>
+ </environmentVariables>
+ </configuration>
+ </execution>
+ <execution>
+ <id>ch2-datagen</id>
+ <phase>${prepare-env.stage}</phase>
+ <goals>
+ <goal>exec</goal>
+ </goals>
+ <configuration>
+ <executable>${pypip.path}</executable>
+ <workingDirectory>${project.build.directory}/ch2/ch2driver/pytpcc</workingDirectory>
+ <arguments>
+ <argument>tpcc.py</argument>
+ <argument>nestcollectionsdocgen</argument>
+ <argument>--warehouses</argument>
+ <argument>1</argument>
+ <argument>--tclients</argument>
+ <argument>1</argument>
+ <argument>--no-execute</argument>
+ <argument>--bulkload-batch-size</argument>
+ <argument>100000000</argument>
+ <argument>--docgen-load</argument>
+ <argument>--datagenSeed</argument>
+ <argument>12345</argument>
+ <argument>--config</argument>
+ <argument>${project.basedir}/src/test/resources/ch2_docgen.conf</argument>
+ </arguments>
+ <environmentVariables>
+ <VIRTUALENV>${project.build.directory}</VIRTUALENV>
+ <PATH>${project.build.directory}${path.separator}${env.PATH}${file.separator}bin</PATH>
+ </environmentVariables>
+ </configuration>
+ </execution>
</executions>
</plugin>
<plugin>
diff --git a/asterixdb/asterix-app/src/test/resources/ch2_docgen.conf b/asterixdb/asterix-app/src/test/resources/ch2_docgen.conf
new file mode 100644
index 0000000..065d26f
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/ch2_docgen.conf
@@ -0,0 +1,19 @@
+; Licensed to the Apache Software Foundation (ASF) under one
+; or more contributor license agreements. See the NOTICE file
+; distributed with this work for additional information
+; regarding copyright ownership. The ASF licenses this file
+; to you under the Apache License, Version 2.0 (the
+; "License"); you may not use this file except in compliance
+; with the License. You may obtain a copy of the License at
+;
+; http://www.apache.org/licenses/LICENSE-2.0
+;
+; Unless required by applicable law or agreed to in writing,
+; software distributed under the License is distributed on an
+; "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+; KIND, either express or implied. See the License for the
+; specific language governing permissions and limitations
+; under the License.
+
+[nestcollectionsdocgen]
+output_dir = ../../../data/ch2
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/CBOJoinQueries.xml b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/CBOJoinQueries.xml
new file mode 100644
index 0000000..26eb5ca
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/CBOJoinQueries.xml
@@ -0,0 +1,25 @@
+<!--
+ ! Licensed to the Apache Software Foundation (ASF) under one
+ ! or more contributor license agreements. See the NOTICE file
+ ! distributed with this work for additional information
+ ! regarding copyright ownership. The ASF licenses this file
+ ! to you under the Apache License, Version 2.0 (the
+ ! "License"); you may not use this file except in compliance
+ ! with the License. You may obtain a copy of the License at
+ !
+ ! http://www.apache.org/licenses/LICENSE-2.0
+ !w or agreed to in writing,
+ ! software distributed under the License is distributed on an
+ ! "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ ! KIND, either express or implied. See the License for the
+ ! specific language governing permissions and limitations
+ ! under the License.
+ !-->
+<test-group name="cbo-join">
+ <test-case FilePath="cbo-join">
+ <compilation-unit name="ch2">
+ <output-dir compare="Text">ch2</output-dir>
+ </compilation-unit>
+ </test-case>
+ ! Unless required by applicable la
+</test-group>
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.1.ddl.sqlpp
new file mode 100644
index 0000000..bc3bce3
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.1.ddl.sqlpp
@@ -0,0 +1,37 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+
+drop dataverse test if exists;
+create dataverse test;
+use test;
+
+CREATE DATASET customer PRIMARY KEY ( c_w_id : integer,c_d_id : integer, c_id : integer);
+CREATE DATASET district PRIMARY KEY( d_w_id : integer, d_id : integer);
+CREATE DATASET history PRIMARY KEY( h_c_w_id : integer, h_c_d_id : integer, h_c_id : integer);
+CREATE DATASET item PRIMARY KEY( i_id : integer);
+CREATE DATASET nation PRIMARY KEY( n_nationkey : integer);
+CREATE DATASET neworder PRIMARY KEY( no_w_id : integer, no_d_id : integer, no_o_id : integer);
+CREATE DATASET orders PRIMARY KEY ( o_w_id : integer, o_d_id : integer, o_id : integer);
+CREATE DATASET region PRIMARY KEY ( r_regionkey : integer);
+CREATE DATASET stock PRIMARY KEY ( s_w_id : integer, s_i_id : integer);
+CREATE DATASET supplier PRIMARY KEY ( su_suppkey : integer);
+CREATE DATASET warehouse PRIMARY KEY ( w_id : integer);
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.10.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.10.query.sqlpp
new file mode 100644
index 0000000..9dd0250
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.10.query.sqlpp
@@ -0,0 +1,51 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 8
+
+SELECT GET_YEAR(DATE(rn1coolis.o_entry_d)) as l_year,
+ ROUND((SUM(case when sun2.n_name = 'Germany' then rn1coolis.ol_amount else 0 end) / SUM(rn1coolis.ol_amount)),2) as mkt_share
+FROM (SELECT rn1cooli.o_entry_d, rn1cooli.ol_amount, s.s_w_id, s.s_i_id
+ FROM stock s JOIN
+ (SELECT o.o_entry_d, ol.ol_i_id, ol.ol_amount, ol.ol_supply_w_id
+ FROM orders o, o.o_orderline ol, item i JOIN
+ (SELECT c.c_id, c.c_w_id, c.c_d_id
+ FROM customer c JOIN
+ (SELECT n1.n_nationkey
+ FROM nation n1, region r
+ WHERE n1.n_regionkey = r.r_regionkey AND r.r_name = 'Europe') nr
+ ON nr.n_nationkey = string_to_codepoint(c.c_state)[0]) cnr
+ ON cnr.c_id = o.o_c_id AND cnr.c_w_id = o.o_w_id AND cnr.c_d_id = o.o_d_id
+ AND i.i_data LIKE '%b' AND i.i_id = ol.ol_i_id
+ AND ol.ol_i_id < 1000
+ AND o.o_entry_d BETWEEN '2017-01-01 00:00:00.000000' AND '2018-12-31 00:00:00.000000') rn1cooli
+ ON rn1cooli.ol_i_id = s.s_i_id
+ AND rn1cooli.ol_supply_w_id = s.s_w_id) rn1coolis JOIN
+ (SELECT su.su_suppkey, n2.n_name
+ FROM supplier su, nation n2
+ WHERE su.su_nationkey = n2.n_nationkey) sun2
+ ON rn1coolis.s_w_id * rn1coolis.s_i_id MOD 10000 = sun2.su_suppkey
+GROUP BY GET_YEAR(DATE(rn1coolis.o_entry_d))
+ORDER BY l_year;
+
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.11.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.11.query.sqlpp
new file mode 100644
index 0000000..7b166e6
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.11.query.sqlpp
@@ -0,0 +1,39 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+
+use test;
+
+
+-- CH2 Query 9
+
+
+SELECT sun.n_name, GET_YEAR(DATE(oolis.o_entry_d)) as l_year, round (SUM(oolis.ol_amount), 2) as SUM_profit
+FROM (SELECT s.s_w_id, s.s_i_id, ooli.o_entry_d, ooli.ol_amount
+ FROM stock s JOIN
+ (SELECT ol.ol_i_id, ol.ol_supply_w_id, ol.ol_amount, o.o_entry_d
+ FROM orders o, o.o_orderline ol, item i
+ WHERE i.i_data LIKE '%bb' and ol.ol_i_id = i.i_id) ooli
+ ON ooli.ol_i_id = s.s_i_id and ooli.ol_supply_w_id = s.s_w_id) oolis JOIN
+ (SELECT su.su_suppkey, n.n_name
+ FROM supplier su, nation n
+ WHERE su.su_nationkey = n.n_nationkey) sun
+ ON oolis.s_w_id * oolis.s_i_id MOD 10000 = sun.su_suppkey
+GROUP BY sun.n_name, GET_YEAR(DATE(oolis.o_entry_d))
+ORDER BY sun.n_name, l_year DESC;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.12.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.12.query.sqlpp
new file mode 100644
index 0000000..119d82f
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.12.query.sqlpp
@@ -0,0 +1,35 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 10
+
+SELECT c.c_id, c.c_last, SUM(ol.ol_amount) as revenue, c.c_city, c.c_phone, n.n_name
+FROM nation n, customer c, orders o, o.o_orderline ol
+WHERE c.c_id = o.o_c_id
+ AND c.c_w_id = o.o_w_id
+ AND c.c_d_id = o.o_d_id
+ AND o.o_entry_d >= '2015-10-01 00:00:00.000000'
+ AND o.o_entry_d < '2016-01-01 00:00:00.000000'
+ AND n.n_nationkey = string_to_codepoint(c.c_state)[0]
+GROUP BY c.c_id, c.c_last, c.c_city, c.c_phone, n.n_name
+ORDER BY revenue DESC
+ LIMIT 20;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.13.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.13.query.sqlpp
new file mode 100644
index 0000000..0a25964
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.13.query.sqlpp
@@ -0,0 +1,39 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 11
+
+SELECT s.s_i_id, SUM(s.s_order_cnt) as ordercount
+FROM nation n, supplier su, stock s
+WHERE s.s_w_id * s.s_i_id MOD 10000 = su.su_suppkey
+ AND su.su_nationkey = n.n_nationkey
+ AND n.n_name = 'Germany'
+GROUP BY s.s_i_id
+HAVING SUM(s.s_order_cnt) >
+ (SELECT VALUE SUM(s1.s_order_cnt) * 0.00005
+ FROM nation n1, supplier su1, stock s1
+ WHERE s1.s_w_id * s1.s_i_id MOD 10000 = su1.su_suppkey
+ AND su1.su_nationkey = n1.n_nationkey
+ AND n1.n_name = 'Germany')[0]
+ORDER BY ordercount DESC, s_i_id;
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.14.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.14.query.sqlpp
new file mode 100644
index 0000000..b10c0e0
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.14.query.sqlpp
@@ -0,0 +1,35 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 12
+
+SELECT o.o_ol_cnt,
+ SUM (case WHEN o.o_carrier_id = 1 or o.o_carrier_id = 2
+ THEN 1 ELSE 0 END) AS high_line_COUNT,
+ SUM (case WHEN o.o_carrier_id <> 1 AND o.o_carrier_id <> 2
+ THEN 1 ELSE 0 END) AS low_line_COUNT
+FROM orders o, o.o_orderline ol
+WHERE o.o_entry_d <= ol.ol_delivery_d
+ AND ol.ol_delivery_d >= '2016-01-01 00:00:00.000000' AND ol.ol_delivery_d < '2017-01-01 00:00:00.000000'
+GROUP BY o.o_ol_cnt
+ORDER BY o.o_ol_cnt;
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.16.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.16.query.sqlpp
new file mode 100644
index 0000000..29523a1
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.16.query.sqlpp
@@ -0,0 +1,32 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 14
+
+SELECT 100.00 * SUM(CASE WHEN i.i_data LIKE 'pr%'
+ THEN ol.ol_amount ELSE 0 END) / (1+SUM(ol.ol_amount)) AS promo_revenue
+FROM item i, orders o, o.o_orderline ol
+WHERE ol.ol_i_id = i.i_id
+ AND ol.ol_delivery_d >= '2017-09-01 00:00:00.000000' AND ol.ol_delivery_d < '2017-10-01 00:00:00.000000';
+
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.17.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.17.query.sqlpp
new file mode 100644
index 0000000..de455f3
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.17.query.sqlpp
@@ -0,0 +1,36 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 15
+
+WITH revenue AS (
+ SELECT s.s_w_id * s.s_i_id MOD 10000 as supplier_no, SUM(ol.ol_amount) AS total_rev
+ FROM stock s, orders o, o.o_orderline ol
+ WHERE ol.ol_i_id = s.s_i_id
+ AND ol.ol_supply_w_id = s.s_w_id
+ AND ol.ol_delivery_d >= '2018-01-01 00:00:00.000000' AND ol.ol_delivery_d < '2018-04-01 00:00:00.000000'
+ GROUP BY s.s_w_id * s.s_i_id MOD 10000)
+SELECT su.su_suppkey, su.su_name, su.su_address, su.su_phone, r.total_revenue
+FROM revenue r, supplier su
+WHERE su.su_suppkey = r.supplier_no
+ AND r.total_revenue = (SELECT VALUE max(r1.total_revenue) FROM revenue r1)[0]
+ORDER BY su.su_suppkey;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.18.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.18.query.sqlpp
new file mode 100644
index 0000000..84b10c5
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.18.query.sqlpp
@@ -0,0 +1,37 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 16
+
+SELECT i.i_name, SUBSTR1(i.i_data, 1, 3) AS brand, i.i_price,
+ COUNT(DISTINCT (s.s_w_id * s.s_i_id MOD 10000)) AS supplier_cnt
+FROM stock s, item i
+WHERE i.i_id = s.s_i_id
+ AND i.i_data not LIKE 'zz%'
+ AND (s.s_w_id * s.s_i_id MOD 10000 NOT IN
+ (SELECT VALUE su.su_suppkey
+ FROM supplier su
+ WHERE su.su_comment LIKE '%Customer%Complaints%'))
+GROUP BY i.i_name, SUBSTR1(i.i_data, 1, 3), i.i_price
+ORDER BY supplier_cnt DESC, brand, i.i_name, i.i_price
+LIMIT 200;
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.19.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.19.query.sqlpp
new file mode 100644
index 0000000..ea0b4d1
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.19.query.sqlpp
@@ -0,0 +1,34 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 17
+
+
+SELECT SUM(ol.ol_amount) / 2.0 AS AVG_yearly
+FROM (SELECT i.i_id, AVG(ol1.ol_quantity) AS a
+ FROM item i, orders o1, o1.o_orderline ol1
+ WHERE i.i_data LIKE '%b'
+ AND ol1.ol_i_id = i.i_id
+ GROUP BY i.i_id) t, orders o, o.o_orderline ol
+WHERE ol.ol_i_id = t.i_id
+ AND ol.ol_quantity < t.a;
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.2.update.sqlpp
new file mode 100644
index 0000000..6c7181c
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.2.update.sqlpp
@@ -0,0 +1,43 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+use test;
+
+
+
+LOAD DATASET customer USING localfs ((`path`=`asterix_nc1://target/data/ch2/customer-0-0.json`),(`format`=`json`));
+
+LOAD DATASET district USING localfs ((`path`=`asterix_nc1://target/data/ch2/district-0-0.json`),(`format`=`json`));
+
+LOAD DATASET history USING localfs ((`path`=`asterix_nc1://target/data/ch2/history-0-0.json`),(`format`=`json`));
+
+LOAD DATASET item USING localfs ((`path`=`asterix_nc1://target/data/ch2/item-0-0.json`),(`format`=`json`));
+
+LOAD DATASET nation USING localfs ((`path`=`asterix_nc1://target/data/ch2/nation-0-0.json`),(`format`=`json`));
+
+LOAD DATASET neworder USING localfs ((`path`=`asterix_nc1://target/data/ch2/neworder-0-0.json`),(`format`=`json`));
+
+LOAD DATASET orders USING localfs ((`path`=`asterix_nc1://target/data/ch2/orders-0-0.json`),(`format`=`json`));
+
+LOAD DATASET region USING localfs ((`path`=`asterix_nc1://target/data/ch2/region-0-0.json`),(`format`=`json`));
+
+LOAD DATASET stock USING localfs ((`path`=`asterix_nc1://target/data/ch2/stock-0-0.json`),(`format`=`json`));
+
+LOAD DATASET supplier USING localfs ((`path`=`asterix_nc1://target/data/ch2/supplier-0-0.json`),(`format`=`json`));
+
+LOAD DATASET warehouse USING localfs ((`path`=`asterix_nc1://target/data/ch2/warehouse-0-0.json`),(`format`=`json`));
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.20.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.20.query.sqlpp
new file mode 100644
index 0000000..905f438
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.20.query.sqlpp
@@ -0,0 +1,34 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 18
+
+
+SELECT c.c_last, c.c_id o_id, o.o_entry_d, o.o_ol_cnt, SUM(ol.ol_amount)
+FROM orders o, o.o_orderline ol, customer c
+WHERE c.c_id = o.o_c_id AND c.c_w_id = o.o_w_id AND c.c_d_id = o.o_d_id
+GROUP BY o.o_id, o.o_w_id, o.o_d_id, c.c_id, c.c_last, o.o_entry_d, o.o_ol_cnt
+HAVING SUM(ol.ol_amount) > 200
+ORDER BY SUM(ol.ol_amount) DESC, o.o_entry_d
+ LIMIT 100;
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.21.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.21.query.sqlpp
new file mode 100644
index 0000000..872509a
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.21.query.sqlpp
@@ -0,0 +1,44 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 19
+
+SELECT SUM(ol.ol_amount) AS revenue
+FROM orders o, o.o_orderline ol, item i
+WHERE ((
+ i.i_data LIKE '%h'
+ AND ol.ol_quantity >= 7 AND ol.ol_quantity <= 17
+ AND i.i_price between 1 AND 5
+ AND o.o_w_id IN [37, 29, 70]
+ ) OR (
+ i.i_data LIKE '%t'
+ AND ol.ol_quantity >= 16 AND ol.ol_quantity <= 26
+ AND i.i_price between 1 AND 10
+ AND o.o_w_id IN [78, 17, 6]
+ ) OR (
+ i.i_data LIKE '%m'
+ AND ol.ol_quantity >= 24 AND ol.ol_quantity <= 34
+ AND i.i_price between 1 AND 15
+ AND o.o_w_id IN [91, 95, 15]
+ ))
+ AND ol.ol_i_id = i.i_id
+ AND i.i_price between 1 AND 15;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.22.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.22.query.sqlpp
new file mode 100644
index 0000000..08ae226
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.22.query.sqlpp
@@ -0,0 +1,42 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 20
+
+SELECT su.su_name, su.su_address
+FROM supplier su, nation n
+WHERE su.su_suppkey IN
+ (SELECT VALUE s.s_i_id * s.s_w_id MOD 10000
+ FROM stock s, orders o, o.o_orderline ol
+ WHERE s.s_i_id IN
+ (SELECT VALUE i.i_id
+ FROM item i
+ WHERE i.i_data LIKE 'co%')
+ AND ol.ol_i_id=s.s_i_id
+ AND ol.ol_delivery_d >= '2016-01-01 12:00:00'
+ AND ol.ol_delivery_d < '2017-01-01 12:00:00'
+ GROUP BY s.s_i_id, s.s_w_id, s.s_quantity
+ HAVING 20*s.s_quantity > SUM(ol.ol_quantity))
+ AND su.su_nationkey = n.n_nationkey
+ AND n.n_name = 'Germany'
+ORDER BY su.su_name;
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.23.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.23.query.sqlpp
new file mode 100644
index 0000000..fbffce5
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.23.query.sqlpp
@@ -0,0 +1,47 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+
+use test;
+
+
+-- CH2 Query 21
+
+SELECT z.su_name, count (*) AS numwait
+FROM (SELECT x.su_name
+ FROM (SELECT o1.o_id, o1.o_w_id, o1.o_d_id, ol1.ol_delivery_d,
+ n.n_nationkey, su.su_suppkey, s.s_w_id, s.s_i_id, su.su_name
+ FROM nation n, supplier su, stock s, orders o1, o1.o_orderline ol1
+ WHERE o1.o_w_id = s.s_w_id
+ AND ol1.ol_i_id = s.s_i_id
+ AND s.s_w_id * s.s_i_id MOD 10000 = su.su_suppkey
+ AND ol1.ol_delivery_d > STRING(DATE(o1.o_entry_d) + duration("P150D"))
+ AND o1.o_entry_d between '2017-12-01 00:00:00' and '2017-12-31 00:00:00'
+ AND su.su_nationkey = n.n_nationkey
+ AND n.n_name = 'Peru') x
+ LEFT OUTER JOIN
+ (SELECT o2.o_id, o2.o_w_id, o2.o_d_id, ol2.ol_delivery_d
+ FROM orders o2, o2.o_orderline ol2
+ WHERE o2.o_entry_d BETWEEN '2017-12-01 00:00:00' AND '2017-12-31 00:00:00') y
+ ON y.o_id = x.o_id AND y.o_w_id = x.o_w_id AND y.o_d_id = x.o_d_id
+ AND y.ol_delivery_d > x.ol_delivery_d
+ GROUP BY x.o_w_id, x.o_d_id, x.o_id, x.n_nationkey, x.su_suppkey, x.s_w_id, x.s_i_id, x.su_name
+ HAVING COUNT (y.o_id) = 0) z
+GROUP BY z.su_name
+ LIMIT 100;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.24.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.24.query.sqlpp
new file mode 100644
index 0000000..602a836
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.24.query.sqlpp
@@ -0,0 +1,40 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 22
+
+
+SELECT SUBSTR1(c.c_state,1,1) AS country, COUNT(*) AS numcust, SUM(c.c_balance) AS totacctbal
+FROM customer c
+WHERE SUBSTR1(c.c_phone,1,1) IN ['1','2','3','4','5','6','7']
+ AND c.c_balance > (SELECT VALUE AVG(c1.c_balance)
+ FROM customer c1
+ WHERE c1.c_balance > 0.00
+ AND SUBSTR1(c1.c_phone,1,1) IN ['1','2','3','4','5','6','7'])[0]
+ AND NOT EXISTS (SELECT VALUE 1
+ FROM orders o
+ WHERE o.o_c_id = c.c_id AND o.o_w_id = c.c_w_id AND o.o_d_id = c.c_d_id
+ AND o.o_entry_d BETWEEN '2013-12-01 00:00:00' AND '2013-12-31 00:00:00')
+GROUP BY SUBSTR1(c.c_state,1,1)
+ORDER BY SUBSTR1(c.c_state,1,1);
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.3.query.sqlpp
new file mode 100644
index 0000000..8428413
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.3.query.sqlpp
@@ -0,0 +1,34 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+
+use test;
+
+-- CH2 Query 1
+
+SELECT ol.ol_number,
+ SUM(ol.ol_quantity) as sum_qty,
+ SUM(ol.ol_amount) as sum_amount,
+ AVG(ol.ol_quantity) as avg_qty,
+ AVG(ol.ol_amount) as avg_amount,
+ COUNT(*) as COUNT_order
+FROM orders o, o.o_orderline ol
+WHERE ol.ol_delivery_d > '2014-07-01 00:00:00'
+GROUP BY ol.ol_number
+ORDER BY ol.ol_number;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.4.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.4.query.sqlpp
new file mode 100644
index 0000000..f6ef95f
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.4.query.sqlpp
@@ -0,0 +1,45 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 2
+
+SELECT su.su_suppkey, su.su_name, n.n_name, i.i_id, i.i_name, su.su_address, su.su_phone, su.su_comment
+FROM (SELECT s1.s_i_id as m_i_id, MIN(s1.s_quantity) as m_s_quantity
+ FROM stock s1,
+ (SELECT su1.su_suppkey
+ FROM supplier su1, (SELECT n1.n_nationkey
+ FROM nation n1, region r1
+ WHERE n1.n_regionkey=r1.r_regionkey
+ AND r1.r_name LIKE 'Europ%') t1
+ WHERE su1.su_nationkey=t1.n_nationkey) t2
+ WHERE s1.s_w_id*s1.s_i_id MOD 10000 = t2.su_suppkey
+ GROUP BY s1.s_i_id) m, item i, stock s, supplier su, nation n, region r
+WHERE i.i_id = s.s_i_id
+ AND s.s_w_id * s.s_i_id MOD 10000 = su.su_suppkey
+ AND su.su_nationkey = n.n_nationkey
+ AND n.n_regionkey = r.r_regionkey
+ AND i.i_data LIKE '%b'
+ AND r.r_name LIKE 'Europ%'
+ AND i.i_id=m.m_i_id
+ AND s.s_quantity = m.m_s_quantity
+ORDER BY n.n_name, su.su_name, i.i_id
+ LIMIT 100;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.5.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.5.query.sqlpp
new file mode 100644
index 0000000..6921256
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.5.query.sqlpp
@@ -0,0 +1,35 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 3
+
+WITH co as
+ (SELECT o.o_id, o.o_w_id, o.o_d_id, o.o_entry_d, o.o_orderline
+ FROM orders o, customer c
+ WHERE c.c_state LIKE 'A%'
+ AND c.c_id = o.o_c_id AND c.c_w_id = o.o_w_id AND c.c_d_id = o.o_d_id
+ AND o.o_entry_d < '2017-03-15 00:00:00.000000')
+SELECT co.o_id, co.o_w_id, co.o_d_id, SUM(ol.ol_amount) as revenue, co.o_entry_d
+FROM co, co.o_orderline ol, neworder no
+WHERE no.no_w_id = co.o_w_id AND no.no_d_id = co.o_d_id AND no.no_o_id = co.o_id
+GROUP BY co.o_id, co.o_w_id, co.o_d_id, co.o_entry_d
+ORDER BY revenue DESC, co.o_entry_d;
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.6.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.6.query.sqlpp
new file mode 100644
index 0000000..1c360f6
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.6.query.sqlpp
@@ -0,0 +1,33 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+use test;
+
+
+-- CH2 Query 4
+
+SELECT o.o_ol_cnt, COUNT(*) as order_COUNT
+FROM orders o
+WHERE o.o_entry_d >= '2015-07-01 00:00:00.000000' AND o.o_entry_d < '2015-10-01 00:00:00.000000'
+ AND EXISTS (SELECT VALUE 1
+ FROM o.o_orderline ol
+ WHERE ol.ol_delivery_d >= STRING(DATE(o.o_entry_d) + duration("P7D")))
+GROUP BY o.o_ol_cnt
+ORDER BY o.o_ol_cnt;
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.7.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.7.query.sqlpp
new file mode 100644
index 0000000..43bdee9
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.7.query.sqlpp
@@ -0,0 +1,44 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 5
+
+SELECT cnros.n_name, ROUND(sum (cnros.ol_amount),2) as revenue
+FROM (SELECT cnro.ol_amount, cnro.n_name, cnro.n_nationkey, s.s_w_id, s.s_i_id
+ FROM stock s JOIN
+ (SELECT o.o_w_id, ol.ol_amount, ol.ol_i_id, cnr.n_name, cnr.n_nationkey
+ FROM orders o, o.o_orderline ol JOIN
+ (SELECT c.c_id, c.c_w_id, c.c_d_id, nr.n_name, nr.n_nationkey
+ FROM customer c JOIN
+ (SELECT n.n_nationkey, n.n_name
+ FROM nation n, region r
+ WHERE n.n_regionkey = r.r_regionkey AND r.r_name = 'Asia') nr
+ ON string_to_codepoint(c.c_state)[0] = nr.n_nationkey) cnr
+ ON o.o_entry_d >= '2016-01-01 00:00:00.000000' AND o.o_entry_d < '2017-01-01 00:00:00.000000'
+ AND cnr.c_id = o.o_c_id AND cnr.c_w_id = o.o_w_id AND cnr.c_d_id = o.o_d_id) cnro
+ ON cnro.o_w_id = s.s_w_id AND cnro.ol_i_id = s.s_i_id) cnros JOIN supplier su
+ ON cnros.s_w_id * cnros.s_i_id MOD 10000 = su.su_suppkey AND su.su_nationkey = cnros.n_nationkey
+GROUP BY cnros.n_name
+ORDER BY revenue DESC;
+
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.8.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.8.query.sqlpp
new file mode 100644
index 0000000..5abea8e
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.8.query.sqlpp
@@ -0,0 +1,32 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+use test;
+
+
+-- CH2 Query 6
+
+
+SELECT SUM(ol.ol_amount) as revenue
+FROM orders o, o.o_orderline ol
+WHERE ol.ol_delivery_d >= '2016-01-01 00:00:00.000000'
+ AND ol.ol_delivery_d < '2017-01-01 00:00:00.000000'
+ AND ol.ol_amount > 600;
+
+
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.9.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.9.query.sqlpp
new file mode 100644
index 0000000..46ca402
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/ch2/ch2.9.query.sqlpp
@@ -0,0 +1,42 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+-- CH2 Query 7
+
+SELECT su.su_nationkey as supp_nation, SUBSTR1(n1n2cools.c_state,1,1) as cust_nation, GET_YEAR(DATE(n1n2cools.o_entry_d)) as l_year, ROUND(SUM(n1n2cools.ol_amount),2) as revenue
+FROM (SELECT n1n2cool.c_state, n1n2cool.o_entry_d, n1n2cool.ol_amount, n1n2cool.n1key, s.s_w_id, s.s_i_id
+ FROM stock s JOIN
+ (SELECT o.o_entry_d, ol.ol_supply_w_id, ol.ol_i_id, n1n2c.c_state, ol.ol_amount, n1n2c.n1key
+ FROM orders o, o.o_orderline ol JOIN
+ (SELECT c.c_id, c.c_w_id, c.c_d_id, c.c_state, n1n2.n1key
+ FROM customer c JOIN
+ (SELECT n1.n_nationkey n1key, n2.n_nationkey n2key
+ FROM nation n1, nation n2
+ WHERE (n1.n_name = 'Germany' AND n2.n_name = 'Cambodia') OR (n1.n_name = 'Cambodia' AND n2.n_name = 'Germany')
+ )n1n2
+ ON string_to_codepoint(c.c_state)[0] = n1n2.n2key) n1n2c
+ ON n1n2c.c_id = o.o_c_id AND n1n2c.c_w_id = o.o_w_id AND n1n2c.c_d_id = o.o_d_id
+ AND ol.ol_delivery_d BETWEEN '2017-01-01 00:00:00.000000' AND '2018-12-31 00:00:00.000000') n1n2cool
+ ON n1n2cool.ol_supply_w_id = s.s_w_id AND n1n2cool.ol_i_id = s.s_i_id) n1n2cools JOIN supplier su
+ ON n1n2cools.s_w_id * n1n2cools.s_i_id MOD 10000 = su.su_suppkey AND su.su_nationkey = n1n2cools.n1key
+GROUP BY su.su_nationkey, SUBSTR1(n1n2cools.c_state,1,1), GET_YEAR(DATE(n1n2cools.o_entry_d))
+ORDER BY su.su_nationkey, cust_nation, l_year;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.10.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.10.adm
new file mode 100644
index 0000000..8e6c67a
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.10.adm
@@ -0,0 +1 @@
+{ "l_year": null, "mkt_share": null }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.11.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.11.adm
new file mode 100644
index 0000000..3aa81d4
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.11.adm
@@ -0,0 +1,58 @@
+{ "l_year": null, "n_name": "Algeria", "SUM_profit": 2896.69 }
+{ "l_year": null, "n_name": "Argentina", "SUM_profit": 0.0 }
+{ "l_year": null, "n_name": "Belgium", "SUM_profit": 2379.08 }
+{ "l_year": null, "n_name": "Bolivia", "SUM_profit": 8032.05 }
+{ "l_year": null, "n_name": "Brazil", "SUM_profit": 7624.24 }
+{ "l_year": null, "n_name": "Cambodia", "SUM_profit": 2653.78 }
+{ "l_year": null, "n_name": "Cameroon", "SUM_profit": 6842.72 }
+{ "l_year": null, "n_name": "Canada", "SUM_profit": 8549.53 }
+{ "l_year": null, "n_name": "Chile", "SUM_profit": 8789.51 }
+{ "l_year": null, "n_name": "China", "SUM_profit": 1566.93 }
+{ "l_year": null, "n_name": "Colombia", "SUM_profit": 15889.65 }
+{ "l_year": null, "n_name": "Ecuador", "SUM_profit": 7859.83 }
+{ "l_year": null, "n_name": "Egypt", "SUM_profit": 7248.03 }
+{ "l_year": null, "n_name": "Ethiopia", "SUM_profit": 4193.55 }
+{ "l_year": null, "n_name": "Finland", "SUM_profit": 8637.83 }
+{ "l_year": null, "n_name": "France", "SUM_profit": 7387.1 }
+{ "l_year": null, "n_name": "Germany", "SUM_profit": 2414.59 }
+{ "l_year": null, "n_name": "Ghana", "SUM_profit": 14942.86 }
+{ "l_year": null, "n_name": "India", "SUM_profit": 8748.45 }
+{ "l_year": null, "n_name": "Indonesia", "SUM_profit": 0.0 }
+{ "l_year": null, "n_name": "Iran", "SUM_profit": 0.0 }
+{ "l_year": null, "n_name": "Iraq", "SUM_profit": 4833.38 }
+{ "l_year": null, "n_name": "Israel", "SUM_profit": 8153.79 }
+{ "l_year": null, "n_name": "Italy", "SUM_profit": 3388.38 }
+{ "l_year": null, "n_name": "Ivory Coast", "SUM_profit": 15293.14 }
+{ "l_year": null, "n_name": "Japan", "SUM_profit": 0.0 }
+{ "l_year": null, "n_name": "Jordan", "SUM_profit": 5308.41 }
+{ "l_year": null, "n_name": "Kenya", "SUM_profit": 11413.2 }
+{ "l_year": null, "n_name": "Kuwait", "SUM_profit": 8532.18 }
+{ "l_year": null, "n_name": "Lebanon", "SUM_profit": 17762.39 }
+{ "l_year": null, "n_name": "Madagascar", "SUM_profit": 23059.03 }
+{ "l_year": null, "n_name": "Malaysia", "SUM_profit": 3264.02 }
+{ "l_year": null, "n_name": "Mexico", "SUM_profit": 9335.95 }
+{ "l_year": null, "n_name": "Morocco", "SUM_profit": 4867.29 }
+{ "l_year": null, "n_name": "Mozambique", "SUM_profit": 20385.96 }
+{ "l_year": null, "n_name": "Netherlands", "SUM_profit": 6042.67 }
+{ "l_year": null, "n_name": "Nigeria", "SUM_profit": 5882.96 }
+{ "l_year": null, "n_name": "North Korea", "SUM_profit": 13148.91 }
+{ "l_year": null, "n_name": "Norway", "SUM_profit": 25173.48 }
+{ "l_year": null, "n_name": "Oman", "SUM_profit": 14932.99 }
+{ "l_year": null, "n_name": "Peru", "SUM_profit": 27200.91 }
+{ "l_year": null, "n_name": "Qatar", "SUM_profit": 5167.11 }
+{ "l_year": null, "n_name": "Russia", "SUM_profit": 4036.6 }
+{ "l_year": null, "n_name": "Singapore", "SUM_profit": 2272.99 }
+{ "l_year": null, "n_name": "South Africa", "SUM_profit": 3526.72 }
+{ "l_year": null, "n_name": "South Korea", "SUM_profit": 23505.19 }
+{ "l_year": null, "n_name": "Spain", "SUM_profit": 12877.38 }
+{ "l_year": null, "n_name": "Sudan", "SUM_profit": 10005.98 }
+{ "l_year": null, "n_name": "Syria", "SUM_profit": 4688.43 }
+{ "l_year": null, "n_name": "Taiwan", "SUM_profit": 0.0 }
+{ "l_year": null, "n_name": "Tanzania", "SUM_profit": 2866.87 }
+{ "l_year": null, "n_name": "Ukraine", "SUM_profit": 8530.39 }
+{ "l_year": null, "n_name": "United Kingdom", "SUM_profit": 4327.43 }
+{ "l_year": null, "n_name": "United States", "SUM_profit": 6574.13 }
+{ "l_year": null, "n_name": "Uruguay", "SUM_profit": 15773.23 }
+{ "l_year": null, "n_name": "Uzbekistan", "SUM_profit": 24782.21 }
+{ "l_year": null, "n_name": "Venezuela", "SUM_profit": 8522.77 }
+{ "l_year": null, "n_name": "Vietnam", "SUM_profit": 1846.15 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.12.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.12.adm
new file mode 100644
index 0000000..3638b5a
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.12.adm
@@ -0,0 +1,20 @@
+{ "c_id": 992, "c_last": "EINGEINGOUGHT", "revenue": 48892.71000000001, "c_city": "vnmlwqdubvhnakac", "c_phone": "2046698494623135", "n_name": "Ecuador" }
+{ "c_id": 2846, "c_last": "EINGEINGATION", "revenue": 48504.63, "c_city": "yjfqfsyqcgpzx", "c_phone": "4082408112860735", "n_name": "Finland" }
+{ "c_id": 731, "c_last": "CALLYPRIBAR", "revenue": 45142.49, "c_city": "kemyfjppbhcejxd", "c_phone": "8750291952962459", "n_name": "Ecuador" }
+{ "c_id": 554, "c_last": "ESEESEPRI", "revenue": 44324.22000000001, "c_city": "lckzcarziwfwm", "c_phone": "7603285899632504", "n_name": "Bolivia" }
+{ "c_id": 1354, "c_last": "PRESCALLYOUGHT", "revenue": 44061.619999999995, "c_city": "qlwpcpukquh", "c_phone": "2412547789399468", "n_name": "Finland" }
+{ "c_id": 1428, "c_last": "OUGHTEINGOUGHT", "revenue": 43973.39, "c_city": "tjytvnidtonokrq", "c_phone": "5780914837151207", "n_name": "Bolivia" }
+{ "c_id": 2639, "c_last": "BARBARCALLY", "revenue": 43962.32, "c_city": "uatdcolxdrg", "c_phone": "6580275762134975", "n_name": "Venezuela" }
+{ "c_id": 607, "c_last": "ANTIBARANTI", "revenue": 43949.399999999994, "c_city": "vjbgklfaluquvoeq", "c_phone": "5103502953149066", "n_name": "North Korea" }
+{ "c_id": 199, "c_last": "OUGHTEINGATION", "revenue": 43714.72, "c_city": "eonunjljaiapwcti", "c_phone": "3319677636967786", "n_name": "Sudan" }
+{ "c_id": 2719, "c_last": "CALLYPRESEING", "revenue": 43571.29, "c_city": "vjkwjdxubiji", "c_phone": "4794218744238242", "n_name": "Bolivia" }
+{ "c_id": 549, "c_last": "ESEPRESATION", "revenue": 43296.19, "c_city": "mbeiueilrzchujrfr", "c_phone": "1113731989514154", "n_name": "Finland" }
+{ "c_id": 1047, "c_last": "PRIOUGHTATION", "revenue": 43018.48999999999, "c_city": "ozahekoiijmagblexyjo", "c_phone": "5670011963430458", "n_name": "North Korea" }
+{ "c_id": 88, "c_last": "BARATIONCALLY", "revenue": 42061.11, "c_city": "rwlecfywwbopfa", "c_phone": "8630987916887178", "n_name": "Ivory Coast" }
+{ "c_id": 146, "c_last": "OUGHTPRESESE", "revenue": 41576.84999999999, "c_city": "ugxzluujfhrwcmyylth", "c_phone": "4893502552673645", "n_name": "Norway" }
+{ "c_id": 2498, "c_last": "PRESCALLYEING", "revenue": 41497.97, "c_city": "thqnpgoxdutndo", "c_phone": "1214398013816680", "n_name": "Ecuador" }
+{ "c_id": 1432, "c_last": "PRIATIONPRI", "revenue": 41408.79000000001, "c_city": "twfxayczodfjzypwcak", "c_phone": "1052641057875928", "n_name": "Israel" }
+{ "c_id": 399, "c_last": "PRIEINGATION", "revenue": 40948.399999999994, "c_city": "pnnkbkeqhvemhoaclu", "c_phone": "7937586141577289", "n_name": "Taiwan" }
+{ "c_id": 2016, "c_last": "OUGHTOUGHTEING", "revenue": 40553.619999999995, "c_city": "oupdeneiqhiblmhmmh", "c_phone": "4096045315931967", "n_name": "Madagascar" }
+{ "c_id": 2798, "c_last": "EINGEINGCALLY", "revenue": 40489.54, "c_city": "fxrjsjbhqyn", "c_phone": "9420763665362803", "n_name": "Ecuador" }
+{ "c_id": 2567, "c_last": "ATIONCALLYEING", "revenue": 40473.23, "c_city": "okrodjgvkwxqq", "c_phone": "8031357032542110", "n_name": "Nigeria" }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.13.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.13.adm
new file mode 100644
index 0000000..56f0d1a
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.13.adm
@@ -0,0 +1,1561 @@
+{ "s_i_id": 22462, "ordercount": 2999 }
+{ "s_i_id": 13234, "ordercount": 2998 }
+{ "s_i_id": 28027, "ordercount": 2998 }
+{ "s_i_id": 93234, "ordercount": 2998 }
+{ "s_i_id": 91068, "ordercount": 2997 }
+{ "s_i_id": 88081, "ordercount": 2996 }
+{ "s_i_id": 9377, "ordercount": 2994 }
+{ "s_i_id": 21306, "ordercount": 2992 }
+{ "s_i_id": 97691, "ordercount": 2985 }
+{ "s_i_id": 22558, "ordercount": 2984 }
+{ "s_i_id": 68027, "ordercount": 2984 }
+{ "s_i_id": 83746, "ordercount": 2981 }
+{ "s_i_id": 86796, "ordercount": 2981 }
+{ "s_i_id": 20414, "ordercount": 2977 }
+{ "s_i_id": 44192, "ordercount": 2977 }
+{ "s_i_id": 58695, "ordercount": 2977 }
+{ "s_i_id": 48695, "ordercount": 2976 }
+{ "s_i_id": 77337, "ordercount": 2972 }
+{ "s_i_id": 83996, "ordercount": 2967 }
+{ "s_i_id": 72647, "ordercount": 2964 }
+{ "s_i_id": 74318, "ordercount": 2964 }
+{ "s_i_id": 67860, "ordercount": 2961 }
+{ "s_i_id": 13073, "ordercount": 2960 }
+{ "s_i_id": 61754, "ordercount": 2960 }
+{ "s_i_id": 77194, "ordercount": 2959 }
+{ "s_i_id": 88315, "ordercount": 2958 }
+{ "s_i_id": 56494, "ordercount": 2957 }
+{ "s_i_id": 83383, "ordercount": 2955 }
+{ "s_i_id": 51406, "ordercount": 2954 }
+{ "s_i_id": 51557, "ordercount": 2954 }
+{ "s_i_id": 72355, "ordercount": 2951 }
+{ "s_i_id": 89632, "ordercount": 2951 }
+{ "s_i_id": 14234, "ordercount": 2948 }
+{ "s_i_id": 71837, "ordercount": 2946 }
+{ "s_i_id": 15455, "ordercount": 2945 }
+{ "s_i_id": 16398, "ordercount": 2944 }
+{ "s_i_id": 36062, "ordercount": 2941 }
+{ "s_i_id": 98081, "ordercount": 2940 }
+{ "s_i_id": 55688, "ordercount": 2939 }
+{ "s_i_id": 20052, "ordercount": 2937 }
+{ "s_i_id": 47337, "ordercount": 2931 }
+{ "s_i_id": 69568, "ordercount": 2930 }
+{ "s_i_id": 86231, "ordercount": 2930 }
+{ "s_i_id": 70891, "ordercount": 2926 }
+{ "s_i_id": 77489, "ordercount": 2926 }
+{ "s_i_id": 87506, "ordercount": 2926 }
+{ "s_i_id": 50891, "ordercount": 2922 }
+{ "s_i_id": 22355, "ordercount": 2916 }
+{ "s_i_id": 2924, "ordercount": 2912 }
+{ "s_i_id": 87018, "ordercount": 2912 }
+{ "s_i_id": 84192, "ordercount": 2911 }
+{ "s_i_id": 70254, "ordercount": 2910 }
+{ "s_i_id": 18748, "ordercount": 2909 }
+{ "s_i_id": 89568, "ordercount": 2909 }
+{ "s_i_id": 92924, "ordercount": 2908 }
+{ "s_i_id": 27759, "ordercount": 2905 }
+{ "s_i_id": 47923, "ordercount": 2904 }
+{ "s_i_id": 86250, "ordercount": 2900 }
+{ "s_i_id": 19250, "ordercount": 2898 }
+{ "s_i_id": 36398, "ordercount": 2898 }
+{ "s_i_id": 98687, "ordercount": 2898 }
+{ "s_i_id": 6062, "ordercount": 2894 }
+{ "s_i_id": 51327, "ordercount": 2894 }
+{ "s_i_id": 13586, "ordercount": 2893 }
+{ "s_i_id": 54664, "ordercount": 2893 }
+{ "s_i_id": 74963, "ordercount": 2893 }
+{ "s_i_id": 31406, "ordercount": 2890 }
+{ "s_i_id": 62407, "ordercount": 2889 }
+{ "s_i_id": 94024, "ordercount": 2884 }
+{ "s_i_id": 61824, "ordercount": 2883 }
+{ "s_i_id": 20891, "ordercount": 2878 }
+{ "s_i_id": 39366, "ordercount": 2875 }
+{ "s_i_id": 75770, "ordercount": 2874 }
+{ "s_i_id": 71773, "ordercount": 2873 }
+{ "s_i_id": 97164, "ordercount": 2873 }
+{ "s_i_id": 50254, "ordercount": 2872 }
+{ "s_i_id": 92558, "ordercount": 2872 }
+{ "s_i_id": 50414, "ordercount": 2870 }
+{ "s_i_id": 30444, "ordercount": 2869 }
+{ "s_i_id": 92986, "ordercount": 2866 }
+{ "s_i_id": 7018, "ordercount": 2865 }
+{ "s_i_id": 62607, "ordercount": 2860 }
+{ "s_i_id": 27138, "ordercount": 2859 }
+{ "s_i_id": 82407, "ordercount": 2855 }
+{ "s_i_id": 24963, "ordercount": 2851 }
+{ "s_i_id": 35642, "ordercount": 2848 }
+{ "s_i_id": 79648, "ordercount": 2847 }
+{ "s_i_id": 25138, "ordercount": 2843 }
+{ "s_i_id": 80052, "ordercount": 2843 }
+{ "s_i_id": 60444, "ordercount": 2842 }
+{ "s_i_id": 39353, "ordercount": 2840 }
+{ "s_i_id": 89404, "ordercount": 2838 }
+{ "s_i_id": 16383, "ordercount": 2834 }
+{ "s_i_id": 41903, "ordercount": 2834 }
+{ "s_i_id": 79348, "ordercount": 2834 }
+{ "s_i_id": 84946, "ordercount": 2831 }
+{ "s_i_id": 4318, "ordercount": 2830 }
+{ "s_i_id": 47860, "ordercount": 2827 }
+{ "s_i_id": 8007, "ordercount": 2826 }
+{ "s_i_id": 41754, "ordercount": 2826 }
+{ "s_i_id": 58074, "ordercount": 2824 }
+{ "s_i_id": 2685, "ordercount": 2820 }
+{ "s_i_id": 86172, "ordercount": 2812 }
+{ "s_i_id": 69107, "ordercount": 2811 }
+{ "s_i_id": 92462, "ordercount": 2811 }
+{ "s_i_id": 69249, "ordercount": 2808 }
+{ "s_i_id": 48910, "ordercount": 2803 }
+{ "s_i_id": 15655, "ordercount": 2802 }
+{ "s_i_id": 62742, "ordercount": 2800 }
+{ "s_i_id": 78007, "ordercount": 2793 }
+{ "s_i_id": 31557, "ordercount": 2788 }
+{ "s_i_id": 12877, "ordercount": 2785 }
+{ "s_i_id": 65688, "ordercount": 2780 }
+{ "s_i_id": 91368, "ordercount": 2780 }
+{ "s_i_id": 67180, "ordercount": 2778 }
+{ "s_i_id": 77028, "ordercount": 2777 }
+{ "s_i_id": 94349, "ordercount": 2775 }
+{ "s_i_id": 5642, "ordercount": 2772 }
+{ "s_i_id": 30297, "ordercount": 2771 }
+{ "s_i_id": 76062, "ordercount": 2771 }
+{ "s_i_id": 10444, "ordercount": 2769 }
+{ "s_i_id": 36148, "ordercount": 2769 }
+{ "s_i_id": 11431, "ordercount": 2765 }
+{ "s_i_id": 64234, "ordercount": 2764 }
+{ "s_i_id": 82939, "ordercount": 2762 }
+{ "s_i_id": 49348, "ordercount": 2761 }
+{ "s_i_id": 27768, "ordercount": 2760 }
+{ "s_i_id": 76653, "ordercount": 2758 }
+{ "s_i_id": 79406, "ordercount": 2757 }
+{ "s_i_id": 16992, "ordercount": 2756 }
+{ "s_i_id": 4946, "ordercount": 2755 }
+{ "s_i_id": 34024, "ordercount": 2753 }
+{ "s_i_id": 7138, "ordercount": 2747 }
+{ "s_i_id": 53153, "ordercount": 2747 }
+{ "s_i_id": 37018, "ordercount": 2743 }
+{ "s_i_id": 70602, "ordercount": 2741 }
+{ "s_i_id": 22607, "ordercount": 2739 }
+{ "s_i_id": 35436, "ordercount": 2738 }
+{ "s_i_id": 1368, "ordercount": 2737 }
+{ "s_i_id": 36546, "ordercount": 2736 }
+{ "s_i_id": 36889, "ordercount": 2736 }
+{ "s_i_id": 56859, "ordercount": 2736 }
+{ "s_i_id": 54946, "ordercount": 2731 }
+{ "s_i_id": 86653, "ordercount": 2731 }
+{ "s_i_id": 16733, "ordercount": 2729 }
+{ "s_i_id": 48007, "ordercount": 2729 }
+{ "s_i_id": 87194, "ordercount": 2726 }
+{ "s_i_id": 39406, "ordercount": 2723 }
+{ "s_i_id": 68021, "ordercount": 2712 }
+{ "s_i_id": 96062, "ordercount": 2712 }
+{ "s_i_id": 83586, "ordercount": 2705 }
+{ "s_i_id": 87860, "ordercount": 2705 }
+{ "s_i_id": 8958, "ordercount": 2702 }
+{ "s_i_id": 39404, "ordercount": 2701 }
+{ "s_i_id": 76105, "ordercount": 2701 }
+{ "s_i_id": 98290, "ordercount": 2700 }
+{ "s_i_id": 11365, "ordercount": 2699 }
+{ "s_i_id": 93744, "ordercount": 2696 }
+{ "s_i_id": 41306, "ordercount": 2695 }
+{ "s_i_id": 23835, "ordercount": 2694 }
+{ "s_i_id": 53378, "ordercount": 2691 }
+{ "s_i_id": 78081, "ordercount": 2691 }
+{ "s_i_id": 64856, "ordercount": 2689 }
+{ "s_i_id": 16062, "ordercount": 2688 }
+{ "s_i_id": 32111, "ordercount": 2688 }
+{ "s_i_id": 32148, "ordercount": 2688 }
+{ "s_i_id": 71406, "ordercount": 2688 }
+{ "s_i_id": 21557, "ordercount": 2686 }
+{ "s_i_id": 61693, "ordercount": 2686 }
+{ "s_i_id": 83234, "ordercount": 2684 }
+{ "s_i_id": 66859, "ordercount": 2682 }
+{ "s_i_id": 82607, "ordercount": 2678 }
+{ "s_i_id": 92355, "ordercount": 2678 }
+{ "s_i_id": 19107, "ordercount": 2676 }
+{ "s_i_id": 23153, "ordercount": 2676 }
+{ "s_i_id": 14419, "ordercount": 2671 }
+{ "s_i_id": 51837, "ordercount": 2671 }
+{ "s_i_id": 98798, "ordercount": 2671 }
+{ "s_i_id": 2877, "ordercount": 2670 }
+{ "s_i_id": 40052, "ordercount": 2670 }
+{ "s_i_id": 93378, "ordercount": 2669 }
+{ "s_i_id": 92111, "ordercount": 2666 }
+{ "s_i_id": 55436, "ordercount": 2665 }
+{ "s_i_id": 64946, "ordercount": 2662 }
+{ "s_i_id": 89348, "ordercount": 2662 }
+{ "s_i_id": 9249, "ordercount": 2656 }
+{ "s_i_id": 18958, "ordercount": 2654 }
+{ "s_i_id": 41697, "ordercount": 2654 }
+{ "s_i_id": 70444, "ordercount": 2654 }
+{ "s_i_id": 33029, "ordercount": 2649 }
+{ "s_i_id": 65860, "ordercount": 2646 }
+{ "s_i_id": 57337, "ordercount": 2645 }
+{ "s_i_id": 42478, "ordercount": 2644 }
+{ "s_i_id": 10476, "ordercount": 2643 }
+{ "s_i_id": 27180, "ordercount": 2643 }
+{ "s_i_id": 64963, "ordercount": 2640 }
+{ "s_i_id": 18591, "ordercount": 2636 }
+{ "s_i_id": 24349, "ordercount": 2632 }
+{ "s_i_id": 92478, "ordercount": 2627 }
+{ "s_i_id": 84318, "ordercount": 2626 }
+{ "s_i_id": 52318, "ordercount": 2625 }
+{ "s_i_id": 70529, "ordercount": 2617 }
+{ "s_i_id": 98021, "ordercount": 2615 }
+{ "s_i_id": 63383, "ordercount": 2612 }
+{ "s_i_id": 20422, "ordercount": 2606 }
+{ "s_i_id": 42407, "ordercount": 2599 }
+{ "s_i_id": 95860, "ordercount": 2599 }
+{ "s_i_id": 57138, "ordercount": 2598 }
+{ "s_i_id": 66481, "ordercount": 2595 }
+{ "s_i_id": 71368, "ordercount": 2595 }
+{ "s_i_id": 85623, "ordercount": 2595 }
+{ "s_i_id": 20838, "ordercount": 2593 }
+{ "s_i_id": 66796, "ordercount": 2592 }
+{ "s_i_id": 28748, "ordercount": 2584 }
+{ "s_i_id": 78748, "ordercount": 2576 }
+{ "s_i_id": 6481, "ordercount": 2575 }
+{ "s_i_id": 64349, "ordercount": 2575 }
+{ "s_i_id": 78502, "ordercount": 2568 }
+{ "s_i_id": 77923, "ordercount": 2566 }
+{ "s_i_id": 9348, "ordercount": 2560 }
+{ "s_i_id": 33744, "ordercount": 2559 }
+{ "s_i_id": 42355, "ordercount": 2554 }
+{ "s_i_id": 23744, "ordercount": 2552 }
+{ "s_i_id": 30623, "ordercount": 2552 }
+{ "s_i_id": 6172, "ordercount": 2550 }
+{ "s_i_id": 48290, "ordercount": 2548 }
+{ "s_i_id": 73153, "ordercount": 2547 }
+{ "s_i_id": 72877, "ordercount": 2544 }
+{ "s_i_id": 12647, "ordercount": 2542 }
+{ "s_i_id": 62945, "ordercount": 2541 }
+{ "s_i_id": 90184, "ordercount": 2541 }
+{ "s_i_id": 97803, "ordercount": 2540 }
+{ "s_i_id": 84234, "ordercount": 2537 }
+{ "s_i_id": 49107, "ordercount": 2535 }
+{ "s_i_id": 58910, "ordercount": 2535 }
+{ "s_i_id": 91431, "ordercount": 2533 }
+{ "s_i_id": 20602, "ordercount": 2532 }
+{ "s_i_id": 61557, "ordercount": 2531 }
+{ "s_i_id": 94318, "ordercount": 2528 }
+{ "s_i_id": 16231, "ordercount": 2526 }
+{ "s_i_id": 76796, "ordercount": 2520 }
+{ "s_i_id": 90052, "ordercount": 2520 }
+{ "s_i_id": 35623, "ordercount": 2519 }
+{ "s_i_id": 1826, "ordercount": 2518 }
+{ "s_i_id": 82924, "ordercount": 2518 }
+{ "s_i_id": 28081, "ordercount": 2516 }
+{ "s_i_id": 13996, "ordercount": 2513 }
+{ "s_i_id": 39249, "ordercount": 2513 }
+{ "s_i_id": 75860, "ordercount": 2513 }
+{ "s_i_id": 45138, "ordercount": 2508 }
+{ "s_i_id": 2111, "ordercount": 2505 }
+{ "s_i_id": 30653, "ordercount": 2505 }
+{ "s_i_id": 50623, "ordercount": 2503 }
+{ "s_i_id": 67018, "ordercount": 2502 }
+{ "s_i_id": 15688, "ordercount": 2501 }
+{ "s_i_id": 74856, "ordercount": 2501 }
+{ "s_i_id": 29353, "ordercount": 2500 }
+{ "s_i_id": 24724, "ordercount": 2497 }
+{ "s_i_id": 91365, "ordercount": 2496 }
+{ "s_i_id": 42647, "ordercount": 2495 }
+{ "s_i_id": 71557, "ordercount": 2492 }
+{ "s_i_id": 84856, "ordercount": 2490 }
+{ "s_i_id": 18502, "ordercount": 2483 }
+{ "s_i_id": 59648, "ordercount": 2481 }
+{ "s_i_id": 60602, "ordercount": 2478 }
+{ "s_i_id": 14792, "ordercount": 2474 }
+{ "s_i_id": 29673, "ordercount": 2472 }
+{ "s_i_id": 49404, "ordercount": 2469 }
+{ "s_i_id": 96653, "ordercount": 2469 }
+{ "s_i_id": 78075, "ordercount": 2468 }
+{ "s_i_id": 88007, "ordercount": 2468 }
+{ "s_i_id": 47194, "ordercount": 2467 }
+{ "s_i_id": 50476, "ordercount": 2466 }
+{ "s_i_id": 10868, "ordercount": 2463 }
+{ "s_i_id": 30767, "ordercount": 2458 }
+{ "s_i_id": 76172, "ordercount": 2458 }
+{ "s_i_id": 22945, "ordercount": 2457 }
+{ "s_i_id": 80414, "ordercount": 2450 }
+{ "s_i_id": 87028, "ordercount": 2446 }
+{ "s_i_id": 71697, "ordercount": 2445 }
+{ "s_i_id": 36653, "ordercount": 2442 }
+{ "s_i_id": 71365, "ordercount": 2442 }
+{ "s_i_id": 28695, "ordercount": 2440 }
+{ "s_i_id": 13029, "ordercount": 2438 }
+{ "s_i_id": 51540, "ordercount": 2436 }
+{ "s_i_id": 39648, "ordercount": 2435 }
+{ "s_i_id": 33835, "ordercount": 2434 }
+{ "s_i_id": 76383, "ordercount": 2434 }
+{ "s_i_id": 98591, "ordercount": 2433 }
+{ "s_i_id": 34419, "ordercount": 2431 }
+{ "s_i_id": 37138, "ordercount": 2430 }
+{ "s_i_id": 43677, "ordercount": 2430 }
+{ "s_i_id": 93383, "ordercount": 2429 }
+{ "s_i_id": 28315, "ordercount": 2428 }
+{ "s_i_id": 86148, "ordercount": 2427 }
+{ "s_i_id": 18695, "ordercount": 2426 }
+{ "s_i_id": 653, "ordercount": 2421 }
+{ "s_i_id": 12986, "ordercount": 2421 }
+{ "s_i_id": 21754, "ordercount": 2421 }
+{ "s_i_id": 93996, "ordercount": 2420 }
+{ "s_i_id": 6250, "ordercount": 2416 }
+{ "s_i_id": 16172, "ordercount": 2409 }
+{ "s_i_id": 868, "ordercount": 2408 }
+{ "s_i_id": 45436, "ordercount": 2407 }
+{ "s_i_id": 83835, "ordercount": 2401 }
+{ "s_i_id": 81406, "ordercount": 2396 }
+{ "s_i_id": 12945, "ordercount": 2392 }
+{ "s_i_id": 46889, "ordercount": 2391 }
+{ "s_i_id": 18687, "ordercount": 2389 }
+{ "s_i_id": 98027, "ordercount": 2389 }
+{ "s_i_id": 46383, "ordercount": 2382 }
+{ "s_i_id": 81807, "ordercount": 2382 }
+{ "s_i_id": 27691, "ordercount": 2381 }
+{ "s_i_id": 81773, "ordercount": 2380 }
+{ "s_i_id": 68748, "ordercount": 2379 }
+{ "s_i_id": 94963, "ordercount": 2370 }
+{ "s_i_id": 23210, "ordercount": 2366 }
+{ "s_i_id": 51431, "ordercount": 2363 }
+{ "s_i_id": 10562, "ordercount": 2361 }
+{ "s_i_id": 68591, "ordercount": 2361 }
+{ "s_i_id": 21365, "ordercount": 2360 }
+{ "s_i_id": 56653, "ordercount": 2358 }
+{ "s_i_id": 10838, "ordercount": 2355 }
+{ "s_i_id": 1068, "ordercount": 2352 }
+{ "s_i_id": 61368, "ordercount": 2352 }
+{ "s_i_id": 9366, "ordercount": 2350 }
+{ "s_i_id": 26481, "ordercount": 2347 }
+{ "s_i_id": 35655, "ordercount": 2342 }
+{ "s_i_id": 71306, "ordercount": 2340 }
+{ "s_i_id": 28910, "ordercount": 2339 }
+{ "s_i_id": 20297, "ordercount": 2338 }
+{ "s_i_id": 78687, "ordercount": 2338 }
+{ "s_i_id": 81754, "ordercount": 2338 }
+{ "s_i_id": 31754, "ordercount": 2337 }
+{ "s_i_id": 56105, "ordercount": 2337 }
+{ "s_i_id": 40891, "ordercount": 2336 }
+{ "s_i_id": 12607, "ordercount": 2335 }
+{ "s_i_id": 4856, "ordercount": 2334 }
+{ "s_i_id": 96796, "ordercount": 2333 }
+{ "s_i_id": 78378, "ordercount": 2332 }
+{ "s_i_id": 11314, "ordercount": 2330 }
+{ "s_i_id": 23378, "ordercount": 2325 }
+{ "s_i_id": 31365, "ordercount": 2323 }
+{ "s_i_id": 47691, "ordercount": 2320 }
+{ "s_i_id": 41540, "ordercount": 2318 }
+{ "s_i_id": 13835, "ordercount": 2316 }
+{ "s_i_id": 25666, "ordercount": 2315 }
+{ "s_i_id": 71068, "ordercount": 2315 }
+{ "s_i_id": 79632, "ordercount": 2310 }
+{ "s_i_id": 59568, "ordercount": 2307 }
+{ "s_i_id": 48378, "ordercount": 2305 }
+{ "s_i_id": 94856, "ordercount": 2304 }
+{ "s_i_id": 94538, "ordercount": 2301 }
+{ "s_i_id": 30602, "ordercount": 2300 }
+{ "s_i_id": 73835, "ordercount": 2289 }
+{ "s_i_id": 42986, "ordercount": 2288 }
+{ "s_i_id": 1431, "ordercount": 2287 }
+{ "s_i_id": 42383, "ordercount": 2287 }
+{ "s_i_id": 69353, "ordercount": 2284 }
+{ "s_i_id": 87180, "ordercount": 2284 }
+{ "s_i_id": 90254, "ordercount": 2284 }
+{ "s_i_id": 27803, "ordercount": 2283 }
+{ "s_i_id": 82685, "ordercount": 2281 }
+{ "s_i_id": 46105, "ordercount": 2279 }
+{ "s_i_id": 11068, "ordercount": 2274 }
+{ "s_i_id": 73210, "ordercount": 2274 }
+{ "s_i_id": 84538, "ordercount": 2272 }
+{ "s_i_id": 72148, "ordercount": 2271 }
+{ "s_i_id": 10422, "ordercount": 2270 }
+{ "s_i_id": 52, "ordercount": 2269 }
+{ "s_i_id": 66733, "ordercount": 2269 }
+{ "s_i_id": 25655, "ordercount": 2265 }
+{ "s_i_id": 61697, "ordercount": 2262 }
+{ "s_i_id": 46494, "ordercount": 2261 }
+{ "s_i_id": 72462, "ordercount": 2261 }
+{ "s_i_id": 78021, "ordercount": 2261 }
+{ "s_i_id": 61826, "ordercount": 2259 }
+{ "s_i_id": 98695, "ordercount": 2259 }
+{ "s_i_id": 67759, "ordercount": 2256 }
+{ "s_i_id": 7803, "ordercount": 2255 }
+{ "s_i_id": 35770, "ordercount": 2255 }
+{ "s_i_id": 59107, "ordercount": 2253 }
+{ "s_i_id": 11693, "ordercount": 2251 }
+{ "s_i_id": 96148, "ordercount": 2251 }
+{ "s_i_id": 75794, "ordercount": 2250 }
+{ "s_i_id": 14538, "ordercount": 2248 }
+{ "s_i_id": 89249, "ordercount": 2246 }
+{ "s_i_id": 92877, "ordercount": 2246 }
+{ "s_i_id": 2318, "ordercount": 2245 }
+{ "s_i_id": 35666, "ordercount": 2245 }
+{ "s_i_id": 90297, "ordercount": 2243 }
+{ "s_i_id": 45860, "ordercount": 2241 }
+{ "s_i_id": 58798, "ordercount": 2240 }
+{ "s_i_id": 72989, "ordercount": 2240 }
+{ "s_i_id": 12742, "ordercount": 2237 }
+{ "s_i_id": 85138, "ordercount": 2235 }
+{ "s_i_id": 18315, "ordercount": 2227 }
+{ "s_i_id": 92607, "ordercount": 2227 }
+{ "s_i_id": 10767, "ordercount": 2225 }
+{ "s_i_id": 56148, "ordercount": 2224 }
+{ "s_i_id": 60297, "ordercount": 2223 }
+{ "s_i_id": 891, "ordercount": 2221 }
+{ "s_i_id": 20623, "ordercount": 2219 }
+{ "s_i_id": 63029, "ordercount": 2219 }
+{ "s_i_id": 64419, "ordercount": 2219 }
+{ "s_i_id": 32462, "ordercount": 2218 }
+{ "s_i_id": 19406, "ordercount": 2217 }
+{ "s_i_id": 70052, "ordercount": 2217 }
+{ "s_i_id": 87337, "ordercount": 2216 }
+{ "s_i_id": 17923, "ordercount": 2214 }
+{ "s_i_id": 25623, "ordercount": 2214 }
+{ "s_i_id": 20767, "ordercount": 2212 }
+{ "s_i_id": 62318, "ordercount": 2211 }
+{ "s_i_id": 29648, "ordercount": 2210 }
+{ "s_i_id": 52407, "ordercount": 2206 }
+{ "s_i_id": 42924, "ordercount": 2204 }
+{ "s_i_id": 40179, "ordercount": 2203 }
+{ "s_i_id": 28290, "ordercount": 2202 }
+{ "s_i_id": 11773, "ordercount": 2196 }
+{ "s_i_id": 99377, "ordercount": 2194 }
+{ "s_i_id": 86546, "ordercount": 2192 }
+{ "s_i_id": 21540, "ordercount": 2190 }
+{ "s_i_id": 6796, "ordercount": 2189 }
+{ "s_i_id": 20868, "ordercount": 2187 }
+{ "s_i_id": 11557, "ordercount": 2186 }
+{ "s_i_id": 60868, "ordercount": 2179 }
+{ "s_i_id": 76398, "ordercount": 2178 }
+{ "s_i_id": 10602, "ordercount": 2177 }
+{ "s_i_id": 10179, "ordercount": 2175 }
+{ "s_i_id": 59366, "ordercount": 2175 }
+{ "s_i_id": 81837, "ordercount": 2174 }
+{ "s_i_id": 67337, "ordercount": 2172 }
+{ "s_i_id": 81826, "ordercount": 2171 }
+{ "s_i_id": 17018, "ordercount": 2169 }
+{ "s_i_id": 40254, "ordercount": 2165 }
+{ "s_i_id": 24792, "ordercount": 2162 }
+{ "s_i_id": 92939, "ordercount": 2162 }
+{ "s_i_id": 18074, "ordercount": 2159 }
+{ "s_i_id": 48591, "ordercount": 2157 }
+{ "s_i_id": 91557, "ordercount": 2157 }
+{ "s_i_id": 96383, "ordercount": 2156 }
+{ "s_i_id": 46481, "ordercount": 2155 }
+{ "s_i_id": 85794, "ordercount": 2154 }
+{ "s_i_id": 18378, "ordercount": 2152 }
+{ "s_i_id": 6889, "ordercount": 2151 }
+{ "s_i_id": 72383, "ordercount": 2148 }
+{ "s_i_id": 6494, "ordercount": 2147 }
+{ "s_i_id": 50297, "ordercount": 2146 }
+{ "s_i_id": 30179, "ordercount": 2145 }
+{ "s_i_id": 60052, "ordercount": 2145 }
+{ "s_i_id": 66398, "ordercount": 2145 }
+{ "s_i_id": 44024, "ordercount": 2140 }
+{ "s_i_id": 90602, "ordercount": 2138 }
+{ "s_i_id": 78591, "ordercount": 2136 }
+{ "s_i_id": 96992, "ordercount": 2136 }
+{ "s_i_id": 28958, "ordercount": 2130 }
+{ "s_i_id": 68695, "ordercount": 2127 }
+{ "s_i_id": 24419, "ordercount": 2125 }
+{ "s_i_id": 50868, "ordercount": 2122 }
+{ "s_i_id": 27923, "ordercount": 2121 }
+{ "s_i_id": 96546, "ordercount": 2119 }
+{ "s_i_id": 71903, "ordercount": 2116 }
+{ "s_i_id": 30414, "ordercount": 2113 }
+{ "s_i_id": 11807, "ordercount": 2110 }
+{ "s_i_id": 77768, "ordercount": 2110 }
+{ "s_i_id": 67768, "ordercount": 2109 }
+{ "s_i_id": 73073, "ordercount": 2109 }
+{ "s_i_id": 46733, "ordercount": 2106 }
+{ "s_i_id": 82805, "ordercount": 2105 }
+{ "s_i_id": 8910, "ordercount": 2103 }
+{ "s_i_id": 38502, "ordercount": 2101 }
+{ "s_i_id": 13153, "ordercount": 2100 }
+{ "s_i_id": 25688, "ordercount": 2100 }
+{ "s_i_id": 21903, "ordercount": 2098 }
+{ "s_i_id": 41773, "ordercount": 2092 }
+{ "s_i_id": 69404, "ordercount": 2089 }
+{ "s_i_id": 73378, "ordercount": 2089 }
+{ "s_i_id": 7028, "ordercount": 2083 }
+{ "s_i_id": 95455, "ordercount": 2079 }
+{ "s_i_id": 32877, "ordercount": 2078 }
+{ "s_i_id": 48798, "ordercount": 2076 }
+{ "s_i_id": 6442, "ordercount": 2071 }
+{ "s_i_id": 72805, "ordercount": 2067 }
+{ "s_i_id": 36105, "ordercount": 2065 }
+{ "s_i_id": 57923, "ordercount": 2063 }
+{ "s_i_id": 82111, "ordercount": 2063 }
+{ "s_i_id": 62877, "ordercount": 2061 }
+{ "s_i_id": 31431, "ordercount": 2060 }
+{ "s_i_id": 28798, "ordercount": 2054 }
+{ "s_i_id": 2148, "ordercount": 2053 }
+{ "s_i_id": 767, "ordercount": 2047 }
+{ "s_i_id": 54234, "ordercount": 2045 }
+{ "s_i_id": 76481, "ordercount": 2045 }
+{ "s_i_id": 9250, "ordercount": 2044 }
+{ "s_i_id": 17768, "ordercount": 2044 }
+{ "s_i_id": 26992, "ordercount": 2040 }
+{ "s_i_id": 78910, "ordercount": 2034 }
+{ "s_i_id": 32318, "ordercount": 2028 }
+{ "s_i_id": 58027, "ordercount": 2024 }
+{ "s_i_id": 13383, "ordercount": 2022 }
+{ "s_i_id": 89648, "ordercount": 2020 }
+{ "s_i_id": 46148, "ordercount": 2019 }
+{ "s_i_id": 61068, "ordercount": 2010 }
+{ "s_i_id": 28687, "ordercount": 2007 }
+{ "s_i_id": 38798, "ordercount": 2007 }
+{ "s_i_id": 80179, "ordercount": 2005 }
+{ "s_i_id": 58315, "ordercount": 2003 }
+{ "s_i_id": 37506, "ordercount": 2001 }
+{ "s_i_id": 71314, "ordercount": 2001 }
+{ "s_i_id": 81903, "ordercount": 1998 }
+{ "s_i_id": 27164, "ordercount": 1997 }
+{ "s_i_id": 51306, "ordercount": 1997 }
+{ "s_i_id": 22986, "ordercount": 1991 }
+{ "s_i_id": 4792, "ordercount": 1990 }
+{ "s_i_id": 10254, "ordercount": 1990 }
+{ "s_i_id": 17860, "ordercount": 1990 }
+{ "s_i_id": 41327, "ordercount": 1988 }
+{ "s_i_id": 76733, "ordercount": 1988 }
+{ "s_i_id": 97506, "ordercount": 1985 }
+{ "s_i_id": 69406, "ordercount": 1981 }
+{ "s_i_id": 5770, "ordercount": 1980 }
+{ "s_i_id": 10056, "ordercount": 1977 }
+{ "s_i_id": 12685, "ordercount": 1977 }
+{ "s_i_id": 34856, "ordercount": 1977 }
+{ "s_i_id": 61431, "ordercount": 1977 }
+{ "s_i_id": 72986, "ordercount": 1977 }
+{ "s_i_id": 1773, "ordercount": 1975 }
+{ "s_i_id": 11826, "ordercount": 1975 }
+{ "s_i_id": 21327, "ordercount": 1975 }
+{ "s_i_id": 37860, "ordercount": 1975 }
+{ "s_i_id": 14192, "ordercount": 1974 }
+{ "s_i_id": 57691, "ordercount": 1971 }
+{ "s_i_id": 80602, "ordercount": 1971 }
+{ "s_i_id": 88958, "ordercount": 1970 }
+{ "s_i_id": 73383, "ordercount": 1968 }
+{ "s_i_id": 89673, "ordercount": 1968 }
+{ "s_i_id": 48748, "ordercount": 1967 }
+{ "s_i_id": 19422, "ordercount": 1966 }
+{ "s_i_id": 77180, "ordercount": 1966 }
+{ "s_i_id": 3210, "ordercount": 1965 }
+{ "s_i_id": 53029, "ordercount": 1965 }
+{ "s_i_id": 78462, "ordercount": 1964 }
+{ "s_i_id": 99632, "ordercount": 1959 }
+{ "s_i_id": 3996, "ordercount": 1958 }
+{ "s_i_id": 56398, "ordercount": 1957 }
+{ "s_i_id": 67803, "ordercount": 1957 }
+{ "s_i_id": 18798, "ordercount": 1956 }
+{ "s_i_id": 42989, "ordercount": 1954 }
+{ "s_i_id": 70653, "ordercount": 1952 }
+{ "s_i_id": 26105, "ordercount": 1950 }
+{ "s_i_id": 82355, "ordercount": 1946 }
+{ "s_i_id": 7860, "ordercount": 1944 }
+{ "s_i_id": 8021, "ordercount": 1942 }
+{ "s_i_id": 46062, "ordercount": 1938 }
+{ "s_i_id": 7506, "ordercount": 1936 }
+{ "s_i_id": 50838, "ordercount": 1935 }
+{ "s_i_id": 91903, "ordercount": 1934 }
+{ "s_i_id": 86442, "ordercount": 1933 }
+{ "s_i_id": 5688, "ordercount": 1929 }
+{ "s_i_id": 49250, "ordercount": 1928 }
+{ "s_i_id": 32685, "ordercount": 1922 }
+{ "s_i_id": 56231, "ordercount": 1920 }
+{ "s_i_id": 86494, "ordercount": 1920 }
+{ "s_i_id": 88074, "ordercount": 1917 }
+{ "s_i_id": 80868, "ordercount": 1913 }
+{ "s_i_id": 51807, "ordercount": 1911 }
+{ "s_i_id": 60056, "ordercount": 1911 }
+{ "s_i_id": 89250, "ordercount": 1911 }
+{ "s_i_id": 5655, "ordercount": 1909 }
+{ "s_i_id": 34318, "ordercount": 1904 }
+{ "s_i_id": 90891, "ordercount": 1904 }
+{ "s_i_id": 68290, "ordercount": 1901 }
+{ "s_i_id": 97180, "ordercount": 1899 }
+{ "s_i_id": 29366, "ordercount": 1895 }
+{ "s_i_id": 44419, "ordercount": 1894 }
+{ "s_i_id": 52957, "ordercount": 1894 }
+{ "s_i_id": 66231, "ordercount": 1893 }
+{ "s_i_id": 89366, "ordercount": 1887 }
+{ "s_i_id": 31368, "ordercount": 1885 }
+{ "s_i_id": 18462, "ordercount": 1884 }
+{ "s_i_id": 422, "ordercount": 1883 }
+{ "s_i_id": 29632, "ordercount": 1882 }
+{ "s_i_id": 8748, "ordercount": 1881 }
+{ "s_i_id": 40838, "ordercount": 1881 }
+{ "s_i_id": 62383, "ordercount": 1881 }
+{ "s_i_id": 65138, "ordercount": 1879 }
+{ "s_i_id": 2957, "ordercount": 1876 }
+{ "s_i_id": 22111, "ordercount": 1869 }
+{ "s_i_id": 96442, "ordercount": 1869 }
+{ "s_i_id": 34792, "ordercount": 1865 }
+{ "s_i_id": 54856, "ordercount": 1863 }
+{ "s_i_id": 58378, "ordercount": 1860 }
+{ "s_i_id": 49568, "ordercount": 1858 }
+{ "s_i_id": 36733, "ordercount": 1857 }
+{ "s_i_id": 42462, "ordercount": 1856 }
+{ "s_i_id": 10414, "ordercount": 1854 }
+{ "s_i_id": 82957, "ordercount": 1854 }
+{ "s_i_id": 11306, "ordercount": 1850 }
+{ "s_i_id": 50602, "ordercount": 1849 }
+{ "s_i_id": 80254, "ordercount": 1849 }
+{ "s_i_id": 95138, "ordercount": 1845 }
+{ "s_i_id": 8290, "ordercount": 1841 }
+{ "s_i_id": 30476, "ordercount": 1841 }
+{ "s_i_id": 72318, "ordercount": 1841 }
+{ "s_i_id": 70476, "ordercount": 1839 }
+{ "s_i_id": 9673, "ordercount": 1835 }
+{ "s_i_id": 66546, "ordercount": 1833 }
+{ "s_i_id": 95794, "ordercount": 1832 }
+{ "s_i_id": 26546, "ordercount": 1830 }
+{ "s_i_id": 76992, "ordercount": 1830 }
+{ "s_i_id": 3073, "ordercount": 1829 }
+{ "s_i_id": 17194, "ordercount": 1825 }
+{ "s_i_id": 35455, "ordercount": 1825 }
+{ "s_i_id": 9107, "ordercount": 1824 }
+{ "s_i_id": 1306, "ordercount": 1822 }
+{ "s_i_id": 4349, "ordercount": 1815 }
+{ "s_i_id": 21068, "ordercount": 1815 }
+{ "s_i_id": 57506, "ordercount": 1814 }
+{ "s_i_id": 75642, "ordercount": 1813 }
+{ "s_i_id": 92148, "ordercount": 1813 }
+{ "s_i_id": 69422, "ordercount": 1812 }
+{ "s_i_id": 38910, "ordercount": 1811 }
+{ "s_i_id": 52742, "ordercount": 1809 }
+{ "s_i_id": 1697, "ordercount": 1807 }
+{ "s_i_id": 23677, "ordercount": 1798 }
+{ "s_i_id": 39377, "ordercount": 1798 }
+{ "s_i_id": 56442, "ordercount": 1797 }
+{ "s_i_id": 98378, "ordercount": 1795 }
+{ "s_i_id": 92989, "ordercount": 1794 }
+{ "s_i_id": 37180, "ordercount": 1791 }
+{ "s_i_id": 55642, "ordercount": 1791 }
+{ "s_i_id": 4724, "ordercount": 1789 }
+{ "s_i_id": 48958, "ordercount": 1785 }
+{ "s_i_id": 12558, "ordercount": 1781 }
+{ "s_i_id": 93746, "ordercount": 1780 }
+{ "s_i_id": 50444, "ordercount": 1779 }
+{ "s_i_id": 50562, "ordercount": 1779 }
+{ "s_i_id": 56546, "ordercount": 1779 }
+{ "s_i_id": 73029, "ordercount": 1778 }
+{ "s_i_id": 22989, "ordercount": 1777 }
+{ "s_i_id": 41406, "ordercount": 1775 }
+{ "s_i_id": 59249, "ordercount": 1773 }
+{ "s_i_id": 66172, "ordercount": 1770 }
+{ "s_i_id": 29377, "ordercount": 1767 }
+{ "s_i_id": 11406, "ordercount": 1766 }
+{ "s_i_id": 5794, "ordercount": 1763 }
+{ "s_i_id": 56481, "ordercount": 1763 }
+{ "s_i_id": 95623, "ordercount": 1762 }
+{ "s_i_id": 84963, "ordercount": 1758 }
+{ "s_i_id": 24946, "ordercount": 1755 }
+{ "s_i_id": 59377, "ordercount": 1754 }
+{ "s_i_id": 91314, "ordercount": 1753 }
+{ "s_i_id": 36992, "ordercount": 1752 }
+{ "s_i_id": 71540, "ordercount": 1748 }
+{ "s_i_id": 21807, "ordercount": 1745 }
+{ "s_i_id": 74192, "ordercount": 1742 }
+{ "s_i_id": 77265, "ordercount": 1742 }
+{ "s_i_id": 2383, "ordercount": 1740 }
+{ "s_i_id": 47138, "ordercount": 1740 }
+{ "s_i_id": 60179, "ordercount": 1740 }
+{ "s_i_id": 22318, "ordercount": 1738 }
+{ "s_i_id": 1824, "ordercount": 1736 }
+{ "s_i_id": 28075, "ordercount": 1735 }
+{ "s_i_id": 72607, "ordercount": 1733 }
+{ "s_i_id": 40767, "ordercount": 1732 }
+{ "s_i_id": 38695, "ordercount": 1731 }
+{ "s_i_id": 87923, "ordercount": 1726 }
+{ "s_i_id": 64318, "ordercount": 1723 }
+{ "s_i_id": 68687, "ordercount": 1723 }
+{ "s_i_id": 53677, "ordercount": 1721 }
+{ "s_i_id": 62805, "ordercount": 1721 }
+{ "s_i_id": 92407, "ordercount": 1712 }
+{ "s_i_id": 43234, "ordercount": 1709 }
+{ "s_i_id": 6992, "ordercount": 1708 }
+{ "s_i_id": 16481, "ordercount": 1706 }
+{ "s_i_id": 52805, "ordercount": 1706 }
+{ "s_i_id": 55623, "ordercount": 1703 }
+{ "s_i_id": 65666, "ordercount": 1703 }
+{ "s_i_id": 63996, "ordercount": 1701 }
+{ "s_i_id": 68378, "ordercount": 1701 }
+{ "s_i_id": 57759, "ordercount": 1698 }
+{ "s_i_id": 33378, "ordercount": 1694 }
+{ "s_i_id": 79249, "ordercount": 1693 }
+{ "s_i_id": 21368, "ordercount": 1690 }
+{ "s_i_id": 51314, "ordercount": 1688 }
+{ "s_i_id": 7691, "ordercount": 1685 }
+{ "s_i_id": 15666, "ordercount": 1684 }
+{ "s_i_id": 10052, "ordercount": 1682 }
+{ "s_i_id": 51365, "ordercount": 1680 }
+{ "s_i_id": 85860, "ordercount": 1680 }
+{ "s_i_id": 3586, "ordercount": 1677 }
+{ "s_i_id": 47803, "ordercount": 1675 }
+{ "s_i_id": 55860, "ordercount": 1675 }
+{ "s_i_id": 97759, "ordercount": 1673 }
+{ "s_i_id": 27018, "ordercount": 1671 }
+{ "s_i_id": 7768, "ordercount": 1670 }
+{ "s_i_id": 42607, "ordercount": 1670 }
+{ "s_i_id": 91697, "ordercount": 1670 }
+{ "s_i_id": 29107, "ordercount": 1669 }
+{ "s_i_id": 90838, "ordercount": 1668 }
+{ "s_i_id": 21406, "ordercount": 1666 }
+{ "s_i_id": 56250, "ordercount": 1666 }
+{ "s_i_id": 22478, "ordercount": 1658 }
+{ "s_i_id": 23746, "ordercount": 1658 }
+{ "s_i_id": 61365, "ordercount": 1657 }
+{ "s_i_id": 8591, "ordercount": 1655 }
+{ "s_i_id": 65655, "ordercount": 1650 }
+{ "s_i_id": 46653, "ordercount": 1649 }
+{ "s_i_id": 2805, "ordercount": 1648 }
+{ "s_i_id": 71807, "ordercount": 1645 }
+{ "s_i_id": 37923, "ordercount": 1643 }
+{ "s_i_id": 51368, "ordercount": 1643 }
+{ "s_i_id": 89353, "ordercount": 1643 }
+{ "s_i_id": 98075, "ordercount": 1642 }
+{ "s_i_id": 20179, "ordercount": 1641 }
+{ "s_i_id": 28591, "ordercount": 1635 }
+{ "s_i_id": 66062, "ordercount": 1634 }
+{ "s_i_id": 57265, "ordercount": 1630 }
+{ "s_i_id": 22805, "ordercount": 1627 }
+{ "s_i_id": 25455, "ordercount": 1624 }
+{ "s_i_id": 50052, "ordercount": 1624 }
+{ "s_i_id": 44234, "ordercount": 1623 }
+{ "s_i_id": 60891, "ordercount": 1623 }
+{ "s_i_id": 50422, "ordercount": 1621 }
+{ "s_i_id": 32558, "ordercount": 1617 }
+{ "s_i_id": 72111, "ordercount": 1614 }
+{ "s_i_id": 15860, "ordercount": 1612 }
+{ "s_i_id": 28074, "ordercount": 1610 }
+{ "s_i_id": 54963, "ordercount": 1610 }
+{ "s_i_id": 81314, "ordercount": 1609 }
+{ "s_i_id": 91693, "ordercount": 1609 }
+{ "s_i_id": 63586, "ordercount": 1608 }
+{ "s_i_id": 45794, "ordercount": 1606 }
+{ "s_i_id": 49353, "ordercount": 1605 }
+{ "s_i_id": 17180, "ordercount": 1595 }
+{ "s_i_id": 64538, "ordercount": 1595 }
+{ "s_i_id": 32805, "ordercount": 1593 }
+{ "s_i_id": 90623, "ordercount": 1592 }
+{ "s_i_id": 41557, "ordercount": 1590 }
+{ "s_i_id": 58081, "ordercount": 1581 }
+{ "s_i_id": 41824, "ordercount": 1578 }
+{ "s_i_id": 39107, "ordercount": 1576 }
+{ "s_i_id": 3677, "ordercount": 1575 }
+{ "s_i_id": 36859, "ordercount": 1575 }
+{ "s_i_id": 60767, "ordercount": 1574 }
+{ "s_i_id": 48081, "ordercount": 1572 }
+{ "s_i_id": 98315, "ordercount": 1570 }
+{ "s_i_id": 40653, "ordercount": 1567 }
+{ "s_i_id": 67138, "ordercount": 1564 }
+{ "s_i_id": 20653, "ordercount": 1563 }
+{ "s_i_id": 60623, "ordercount": 1563 }
+{ "s_i_id": 79422, "ordercount": 1553 }
+{ "s_i_id": 19348, "ordercount": 1551 }
+{ "s_i_id": 76148, "ordercount": 1551 }
+{ "s_i_id": 40529, "ordercount": 1550 }
+{ "s_i_id": 53996, "ordercount": 1549 }
+{ "s_i_id": 80653, "ordercount": 1547 }
+{ "s_i_id": 30891, "ordercount": 1545 }
+{ "s_i_id": 88462, "ordercount": 1544 }
+{ "s_i_id": 88695, "ordercount": 1544 }
+{ "s_i_id": 17506, "ordercount": 1543 }
+{ "s_i_id": 62647, "ordercount": 1541 }
+{ "s_i_id": 96733, "ordercount": 1537 }
+{ "s_i_id": 37691, "ordercount": 1536 }
+{ "s_i_id": 12383, "ordercount": 1532 }
+{ "s_i_id": 7923, "ordercount": 1530 }
+{ "s_i_id": 39250, "ordercount": 1528 }
+{ "s_i_id": 31837, "ordercount": 1527 }
+{ "s_i_id": 33383, "ordercount": 1523 }
+{ "s_i_id": 80623, "ordercount": 1523 }
+{ "s_i_id": 54024, "ordercount": 1522 }
+{ "s_i_id": 66494, "ordercount": 1520 }
+{ "s_i_id": 89422, "ordercount": 1519 }
+{ "s_i_id": 17803, "ordercount": 1516 }
+{ "s_i_id": 79673, "ordercount": 1516 }
+{ "s_i_id": 7759, "ordercount": 1512 }
+{ "s_i_id": 54349, "ordercount": 1512 }
+{ "s_i_id": 61327, "ordercount": 1512 }
+{ "s_i_id": 75138, "ordercount": 1512 }
+{ "s_i_id": 97028, "ordercount": 1512 }
+{ "s_i_id": 79404, "ordercount": 1511 }
+{ "s_i_id": 52462, "ordercount": 1509 }
+{ "s_i_id": 21693, "ordercount": 1506 }
+{ "s_i_id": 76889, "ordercount": 1504 }
+{ "s_i_id": 83378, "ordercount": 1502 }
+{ "s_i_id": 21773, "ordercount": 1497 }
+{ "s_i_id": 68910, "ordercount": 1497 }
+{ "s_i_id": 25770, "ordercount": 1496 }
+{ "s_i_id": 38007, "ordercount": 1496 }
+{ "s_i_id": 52478, "ordercount": 1494 }
+{ "s_i_id": 77164, "ordercount": 1494 }
+{ "s_i_id": 69632, "ordercount": 1492 }
+{ "s_i_id": 90868, "ordercount": 1492 }
+{ "s_i_id": 25436, "ordercount": 1491 }
+{ "s_i_id": 26250, "ordercount": 1490 }
+{ "s_i_id": 81693, "ordercount": 1489 }
+{ "s_i_id": 58748, "ordercount": 1488 }
+{ "s_i_id": 85642, "ordercount": 1488 }
+{ "s_i_id": 12355, "ordercount": 1486 }
+{ "s_i_id": 18027, "ordercount": 1484 }
+{ "s_i_id": 86481, "ordercount": 1482 }
+{ "s_i_id": 65623, "ordercount": 1480 }
+{ "s_i_id": 16442, "ordercount": 1478 }
+{ "s_i_id": 16859, "ordercount": 1478 }
+{ "s_i_id": 22877, "ordercount": 1477 }
+{ "s_i_id": 67194, "ordercount": 1473 }
+{ "s_i_id": 96105, "ordercount": 1472 }
+{ "s_i_id": 59404, "ordercount": 1471 }
+{ "s_i_id": 83029, "ordercount": 1471 }
+{ "s_i_id": 51824, "ordercount": 1469 }
+{ "s_i_id": 70297, "ordercount": 1469 }
+{ "s_i_id": 76546, "ordercount": 1469 }
+{ "s_i_id": 60653, "ordercount": 1467 }
+{ "s_i_id": 67028, "ordercount": 1465 }
+{ "s_i_id": 67265, "ordercount": 1464 }
+{ "s_i_id": 62986, "ordercount": 1462 }
+{ "s_i_id": 24318, "ordercount": 1460 }
+{ "s_i_id": 52924, "ordercount": 1459 }
+{ "s_i_id": 63153, "ordercount": 1456 }
+{ "s_i_id": 81540, "ordercount": 1456 }
+{ "s_i_id": 7180, "ordercount": 1452 }
+{ "s_i_id": 39422, "ordercount": 1450 }
+{ "s_i_id": 72407, "ordercount": 1446 }
+{ "s_i_id": 39348, "ordercount": 1445 }
+{ "s_i_id": 73234, "ordercount": 1444 }
+{ "s_i_id": 58007, "ordercount": 1443 }
+{ "s_i_id": 15642, "ordercount": 1441 }
+{ "s_i_id": 7265, "ordercount": 1440 }
+{ "s_i_id": 13677, "ordercount": 1440 }
+{ "s_i_id": 88378, "ordercount": 1440 }
+{ "s_i_id": 33210, "ordercount": 1439 }
+{ "s_i_id": 46231, "ordercount": 1438 }
+{ "s_i_id": 1406, "ordercount": 1434 }
+{ "s_i_id": 96889, "ordercount": 1433 }
+{ "s_i_id": 88075, "ordercount": 1430 }
+{ "s_i_id": 19377, "ordercount": 1429 }
+{ "s_i_id": 42957, "ordercount": 1429 }
+{ "s_i_id": 58075, "ordercount": 1429 }
+{ "s_i_id": 71431, "ordercount": 1429 }
+{ "s_i_id": 38958, "ordercount": 1428 }
+{ "s_i_id": 97860, "ordercount": 1424 }
+{ "s_i_id": 8315, "ordercount": 1422 }
+{ "s_i_id": 86398, "ordercount": 1421 }
+{ "s_i_id": 529, "ordercount": 1420 }
+{ "s_i_id": 27265, "ordercount": 1419 }
+{ "s_i_id": 54318, "ordercount": 1416 }
+{ "s_i_id": 22407, "ordercount": 1414 }
+{ "s_i_id": 40562, "ordercount": 1414 }
+{ "s_i_id": 59353, "ordercount": 1414 }
+{ "s_i_id": 19673, "ordercount": 1412 }
+{ "s_i_id": 16105, "ordercount": 1411 }
+{ "s_i_id": 31314, "ordercount": 1410 }
+{ "s_i_id": 88027, "ordercount": 1408 }
+{ "s_i_id": 90476, "ordercount": 1401 }
+{ "s_i_id": 44724, "ordercount": 1400 }
+{ "s_i_id": 96481, "ordercount": 1399 }
+{ "s_i_id": 41068, "ordercount": 1389 }
+{ "s_i_id": 87489, "ordercount": 1389 }
+{ "s_i_id": 56733, "ordercount": 1387 }
+{ "s_i_id": 73746, "ordercount": 1383 }
+{ "s_i_id": 71824, "ordercount": 1381 }
+{ "s_i_id": 30529, "ordercount": 1378 }
+{ "s_i_id": 97194, "ordercount": 1378 }
+{ "s_i_id": 88798, "ordercount": 1377 }
+{ "s_i_id": 24664, "ordercount": 1376 }
+{ "s_i_id": 60184, "ordercount": 1375 }
+{ "s_i_id": 99404, "ordercount": 1372 }
+{ "s_i_id": 41807, "ordercount": 1371 }
+{ "s_i_id": 50767, "ordercount": 1370 }
+{ "s_i_id": 29249, "ordercount": 1367 }
+{ "s_i_id": 34724, "ordercount": 1367 }
+{ "s_i_id": 23029, "ordercount": 1366 }
+{ "s_i_id": 52989, "ordercount": 1366 }
+{ "s_i_id": 45655, "ordercount": 1364 }
+{ "s_i_id": 78695, "ordercount": 1364 }
+{ "s_i_id": 35860, "ordercount": 1361 }
+{ "s_i_id": 26383, "ordercount": 1360 }
+{ "s_i_id": 31540, "ordercount": 1359 }
+{ "s_i_id": 22742, "ordercount": 1352 }
+{ "s_i_id": 20056, "ordercount": 1351 }
+{ "s_i_id": 41826, "ordercount": 1351 }
+{ "s_i_id": 46992, "ordercount": 1345 }
+{ "s_i_id": 34963, "ordercount": 1342 }
+{ "s_i_id": 59632, "ordercount": 1341 }
+{ "s_i_id": 12478, "ordercount": 1339 }
+{ "s_i_id": 96172, "ordercount": 1339 }
+{ "s_i_id": 77860, "ordercount": 1338 }
+{ "s_i_id": 25860, "ordercount": 1337 }
+{ "s_i_id": 40476, "ordercount": 1337 }
+{ "s_i_id": 57194, "ordercount": 1336 }
+{ "s_i_id": 3835, "ordercount": 1333 }
+{ "s_i_id": 40602, "ordercount": 1333 }
+{ "s_i_id": 11697, "ordercount": 1331 }
+{ "s_i_id": 32383, "ordercount": 1329 }
+{ "s_i_id": 72924, "ordercount": 1329 }
+{ "s_i_id": 29406, "ordercount": 1328 }
+{ "s_i_id": 62462, "ordercount": 1328 }
+{ "s_i_id": 27337, "ordercount": 1326 }
+{ "s_i_id": 96398, "ordercount": 1325 }
+{ "s_i_id": 44856, "ordercount": 1323 }
+{ "s_i_id": 35138, "ordercount": 1322 }
+{ "s_i_id": 64724, "ordercount": 1321 }
+{ "s_i_id": 12957, "ordercount": 1320 }
+{ "s_i_id": 19632, "ordercount": 1320 }
+{ "s_i_id": 13210, "ordercount": 1319 }
+{ "s_i_id": 31807, "ordercount": 1319 }
+{ "s_i_id": 82742, "ordercount": 1319 }
+{ "s_i_id": 46796, "ordercount": 1318 }
+{ "s_i_id": 31697, "ordercount": 1317 }
+{ "s_i_id": 84349, "ordercount": 1313 }
+{ "s_i_id": 75623, "ordercount": 1311 }
+{ "s_i_id": 30056, "ordercount": 1310 }
+{ "s_i_id": 39673, "ordercount": 1310 }
+{ "s_i_id": 53746, "ordercount": 1304 }
+{ "s_i_id": 38687, "ordercount": 1303 }
+{ "s_i_id": 74538, "ordercount": 1303 }
+{ "s_i_id": 22924, "ordercount": 1302 }
+{ "s_i_id": 49648, "ordercount": 1301 }
+{ "s_i_id": 99422, "ordercount": 1301 }
+{ "s_i_id": 8378, "ordercount": 1300 }
+{ "s_i_id": 39568, "ordercount": 1300 }
+{ "s_i_id": 4234, "ordercount": 1297 }
+{ "s_i_id": 91837, "ordercount": 1297 }
+{ "s_i_id": 38021, "ordercount": 1292 }
+{ "s_i_id": 3383, "ordercount": 1288 }
+{ "s_i_id": 84792, "ordercount": 1287 }
+{ "s_i_id": 87265, "ordercount": 1284 }
+{ "s_i_id": 30838, "ordercount": 1283 }
+{ "s_i_id": 12939, "ordercount": 1280 }
+{ "s_i_id": 32945, "ordercount": 1277 }
+{ "s_i_id": 98074, "ordercount": 1273 }
+{ "s_i_id": 40868, "ordercount": 1271 }
+{ "s_i_id": 49422, "ordercount": 1269 }
+{ "s_i_id": 53234, "ordercount": 1269 }
+{ "s_i_id": 28502, "ordercount": 1267 }
+{ "s_i_id": 1837, "ordercount": 1259 }
+{ "s_i_id": 96250, "ordercount": 1259 }
+{ "s_i_id": 10891, "ordercount": 1257 }
+{ "s_i_id": 57860, "ordercount": 1255 }
+{ "s_i_id": 87759, "ordercount": 1254 }
+{ "s_i_id": 36796, "ordercount": 1248 }
+{ "s_i_id": 2355, "ordercount": 1247 }
+{ "s_i_id": 74024, "ordercount": 1247 }
+{ "s_i_id": 90422, "ordercount": 1247 }
+{ "s_i_id": 6105, "ordercount": 1245 }
+{ "s_i_id": 33677, "ordercount": 1243 }
+{ "s_i_id": 23234, "ordercount": 1241 }
+{ "s_i_id": 94792, "ordercount": 1241 }
+{ "s_i_id": 70838, "ordercount": 1236 }
+{ "s_i_id": 87803, "ordercount": 1235 }
+{ "s_i_id": 97265, "ordercount": 1234 }
+{ "s_i_id": 62685, "ordercount": 1233 }
+{ "s_i_id": 57028, "ordercount": 1232 }
+{ "s_i_id": 83153, "ordercount": 1232 }
+{ "s_i_id": 21431, "ordercount": 1227 }
+{ "s_i_id": 60414, "ordercount": 1227 }
+{ "s_i_id": 1754, "ordercount": 1224 }
+{ "s_i_id": 32939, "ordercount": 1221 }
+{ "s_i_id": 61903, "ordercount": 1217 }
+{ "s_i_id": 43153, "ordercount": 1216 }
+{ "s_i_id": 68798, "ordercount": 1215 }
+{ "s_i_id": 91406, "ordercount": 1214 }
+{ "s_i_id": 3029, "ordercount": 1211 }
+{ "s_i_id": 22148, "ordercount": 1209 }
+{ "s_i_id": 44349, "ordercount": 1209 }
+{ "s_i_id": 15623, "ordercount": 1202 }
+{ "s_i_id": 43744, "ordercount": 1202 }
+{ "s_i_id": 88502, "ordercount": 1202 }
+{ "s_i_id": 11824, "ordercount": 1200 }
+{ "s_i_id": 55666, "ordercount": 1199 }
+{ "s_i_id": 55455, "ordercount": 1189 }
+{ "s_i_id": 79107, "ordercount": 1187 }
+{ "s_i_id": 97138, "ordercount": 1186 }
+{ "s_i_id": 94946, "ordercount": 1184 }
+{ "s_i_id": 63744, "ordercount": 1180 }
+{ "s_i_id": 70767, "ordercount": 1179 }
+{ "s_i_id": 30868, "ordercount": 1178 }
+{ "s_i_id": 35794, "ordercount": 1177 }
+{ "s_i_id": 21837, "ordercount": 1176 }
+{ "s_i_id": 66250, "ordercount": 1173 }
+{ "s_i_id": 2986, "ordercount": 1170 }
+{ "s_i_id": 92318, "ordercount": 1169 }
+{ "s_i_id": 2939, "ordercount": 1168 }
+{ "s_i_id": 22685, "ordercount": 1167 }
+{ "s_i_id": 87164, "ordercount": 1166 }
+{ "s_i_id": 43029, "ordercount": 1162 }
+{ "s_i_id": 79366, "ordercount": 1159 }
+{ "s_i_id": 52148, "ordercount": 1155 }
+{ "s_i_id": 85455, "ordercount": 1154 }
+{ "s_i_id": 19249, "ordercount": 1153 }
+{ "s_i_id": 91306, "ordercount": 1153 }
+{ "s_i_id": 10653, "ordercount": 1150 }
+{ "s_i_id": 58462, "ordercount": 1148 }
+{ "s_i_id": 29404, "ordercount": 1147 }
+{ "s_i_id": 73677, "ordercount": 1147 }
+{ "s_i_id": 14664, "ordercount": 1146 }
+{ "s_i_id": 66889, "ordercount": 1146 }
+{ "s_i_id": 26733, "ordercount": 1144 }
+{ "s_i_id": 41314, "ordercount": 1144 }
+{ "s_i_id": 55138, "ordercount": 1144 }
+{ "s_i_id": 9648, "ordercount": 1143 }
+{ "s_i_id": 12989, "ordercount": 1143 }
+{ "s_i_id": 92945, "ordercount": 1142 }
+{ "s_i_id": 93586, "ordercount": 1142 }
+{ "s_i_id": 43378, "ordercount": 1135 }
+{ "s_i_id": 86889, "ordercount": 1134 }
+{ "s_i_id": 75655, "ordercount": 1132 }
+{ "s_i_id": 47180, "ordercount": 1130 }
+{ "s_i_id": 51826, "ordercount": 1130 }
+{ "s_i_id": 21697, "ordercount": 1128 }
+{ "s_i_id": 52111, "ordercount": 1125 }
+{ "s_i_id": 57803, "ordercount": 1124 }
+{ "s_i_id": 62148, "ordercount": 1123 }
+{ "s_i_id": 54538, "ordercount": 1120 }
+{ "s_i_id": 66148, "ordercount": 1119 }
+{ "s_i_id": 72685, "ordercount": 1119 }
+{ "s_i_id": 88687, "ordercount": 1107 }
+{ "s_i_id": 81068, "ordercount": 1106 }
+{ "s_i_id": 32478, "ordercount": 1105 }
+{ "s_i_id": 75455, "ordercount": 1103 }
+{ "s_i_id": 68074, "ordercount": 1102 }
+{ "s_i_id": 84419, "ordercount": 1102 }
+{ "s_i_id": 36481, "ordercount": 1100 }
+{ "s_i_id": 93153, "ordercount": 1098 }
+{ "s_i_id": 53210, "ordercount": 1097 }
+{ "s_i_id": 82558, "ordercount": 1095 }
+{ "s_i_id": 40422, "ordercount": 1092 }
+{ "s_i_id": 66653, "ordercount": 1092 }
+{ "s_i_id": 56383, "ordercount": 1090 }
+{ "s_i_id": 59673, "ordercount": 1090 }
+{ "s_i_id": 70414, "ordercount": 1089 }
+{ "s_i_id": 36442, "ordercount": 1083 }
+{ "s_i_id": 95770, "ordercount": 1081 }
+{ "s_i_id": 60562, "ordercount": 1074 }
+{ "s_i_id": 18007, "ordercount": 1069 }
+{ "s_i_id": 52383, "ordercount": 1069 }
+{ "s_i_id": 92957, "ordercount": 1069 }
+{ "s_i_id": 40623, "ordercount": 1068 }
+{ "s_i_id": 57180, "ordercount": 1066 }
+{ "s_i_id": 12318, "ordercount": 1064 }
+{ "s_i_id": 80444, "ordercount": 1064 }
+{ "s_i_id": 28462, "ordercount": 1063 }
+{ "s_i_id": 48027, "ordercount": 1062 }
+{ "s_i_id": 4419, "ordercount": 1058 }
+{ "s_i_id": 72939, "ordercount": 1054 }
+{ "s_i_id": 44538, "ordercount": 1053 }
+{ "s_i_id": 66992, "ordercount": 1053 }
+{ "s_i_id": 57018, "ordercount": 1052 }
+{ "s_i_id": 80529, "ordercount": 1052 }
+{ "s_i_id": 51068, "ordercount": 1049 }
+{ "s_i_id": 76231, "ordercount": 1049 }
+{ "s_i_id": 80184, "ordercount": 1048 }
+{ "s_i_id": 99250, "ordercount": 1048 }
+{ "s_i_id": 8462, "ordercount": 1046 }
+{ "s_i_id": 41431, "ordercount": 1044 }
+{ "s_i_id": 86383, "ordercount": 1044 }
+{ "s_i_id": 26062, "ordercount": 1043 }
+{ "s_i_id": 68958, "ordercount": 1041 }
+{ "s_i_id": 62478, "ordercount": 1040 }
+{ "s_i_id": 26859, "ordercount": 1037 }
+{ "s_i_id": 86859, "ordercount": 1036 }
+{ "s_i_id": 37028, "ordercount": 1034 }
+{ "s_i_id": 37759, "ordercount": 1029 }
+{ "s_i_id": 9353, "ordercount": 1022 }
+{ "s_i_id": 30422, "ordercount": 1019 }
+{ "s_i_id": 70179, "ordercount": 1019 }
+{ "s_i_id": 74234, "ordercount": 1018 }
+{ "s_i_id": 38027, "ordercount": 1017 }
+{ "s_i_id": 76250, "ordercount": 1016 }
+{ "s_i_id": 20444, "ordercount": 1014 }
+{ "s_i_id": 51693, "ordercount": 1013 }
+{ "s_i_id": 56796, "ordercount": 1010 }
+{ "s_i_id": 82148, "ordercount": 1005 }
+{ "s_i_id": 95688, "ordercount": 1001 }
+{ "s_i_id": 80562, "ordercount": 1000 }
+{ "s_i_id": 18910, "ordercount": 996 }
+{ "s_i_id": 42939, "ordercount": 996 }
+{ "s_i_id": 38591, "ordercount": 993 }
+{ "s_i_id": 12148, "ordercount": 987 }
+{ "s_i_id": 22939, "ordercount": 985 }
+{ "s_i_id": 53383, "ordercount": 983 }
+{ "s_i_id": 1365, "ordercount": 982 }
+{ "s_i_id": 34946, "ordercount": 982 }
+{ "s_i_id": 54792, "ordercount": 982 }
+{ "s_i_id": 56172, "ordercount": 980 }
+{ "s_i_id": 19648, "ordercount": 979 }
+{ "s_i_id": 27506, "ordercount": 979 }
+{ "s_i_id": 36494, "ordercount": 976 }
+{ "s_i_id": 10623, "ordercount": 974 }
+{ "s_i_id": 67506, "ordercount": 974 }
+{ "s_i_id": 2945, "ordercount": 972 }
+{ "s_i_id": 64192, "ordercount": 972 }
+{ "s_i_id": 16250, "ordercount": 971 }
+{ "s_i_id": 44946, "ordercount": 971 }
+{ "s_i_id": 59406, "ordercount": 968 }
+{ "s_i_id": 71826, "ordercount": 968 }
+{ "s_i_id": 4664, "ordercount": 959 }
+{ "s_i_id": 59348, "ordercount": 958 }
+{ "s_i_id": 70623, "ordercount": 958 }
+{ "s_i_id": 43746, "ordercount": 955 }
+{ "s_i_id": 58021, "ordercount": 955 }
+{ "s_i_id": 2607, "ordercount": 949 }
+{ "s_i_id": 38378, "ordercount": 946 }
+{ "s_i_id": 80476, "ordercount": 942 }
+{ "s_i_id": 32742, "ordercount": 937 }
+{ "s_i_id": 37164, "ordercount": 936 }
+{ "s_i_id": 99348, "ordercount": 936 }
+{ "s_i_id": 9632, "ordercount": 934 }
+{ "s_i_id": 47506, "ordercount": 931 }
+{ "s_i_id": 15770, "ordercount": 927 }
+{ "s_i_id": 16796, "ordercount": 925 }
+{ "s_i_id": 91540, "ordercount": 924 }
+{ "s_i_id": 91754, "ordercount": 922 }
+{ "s_i_id": 32607, "ordercount": 919 }
+{ "s_i_id": 70562, "ordercount": 918 }
+{ "s_i_id": 18290, "ordercount": 915 }
+{ "s_i_id": 24192, "ordercount": 911 }
+{ "s_i_id": 55655, "ordercount": 911 }
+{ "s_i_id": 61306, "ordercount": 911 }
+{ "s_i_id": 95642, "ordercount": 911 }
+{ "s_i_id": 32407, "ordercount": 910 }
+{ "s_i_id": 16653, "ordercount": 907 }
+{ "s_i_id": 15436, "ordercount": 906 }
+{ "s_i_id": 17138, "ordercount": 906 }
+{ "s_i_id": 11754, "ordercount": 900 }
+{ "s_i_id": 97923, "ordercount": 900 }
+{ "s_i_id": 74724, "ordercount": 899 }
+{ "s_i_id": 92383, "ordercount": 896 }
+{ "s_i_id": 87768, "ordercount": 895 }
+{ "s_i_id": 29348, "ordercount": 893 }
+{ "s_i_id": 17028, "ordercount": 892 }
+{ "s_i_id": 3234, "ordercount": 890 }
+{ "s_i_id": 26653, "ordercount": 890 }
+{ "s_i_id": 55770, "ordercount": 889 }
+{ "s_i_id": 5455, "ordercount": 887 }
+{ "s_i_id": 64792, "ordercount": 885 }
+{ "s_i_id": 36231, "ordercount": 883 }
+{ "s_i_id": 29422, "ordercount": 875 }
+{ "s_i_id": 179, "ordercount": 873 }
+{ "s_i_id": 29250, "ordercount": 871 }
+{ "s_i_id": 16148, "ordercount": 867 }
+{ "s_i_id": 9404, "ordercount": 858 }
+{ "s_i_id": 27028, "ordercount": 856 }
+{ "s_i_id": 33073, "ordercount": 856 }
+{ "s_i_id": 70422, "ordercount": 855 }
+{ "s_i_id": 98910, "ordercount": 854 }
+{ "s_i_id": 4024, "ordercount": 851 }
+{ "s_i_id": 14349, "ordercount": 850 }
+{ "s_i_id": 6733, "ordercount": 849 }
+{ "s_i_id": 23586, "ordercount": 849 }
+{ "s_i_id": 43383, "ordercount": 848 }
+{ "s_i_id": 50179, "ordercount": 846 }
+{ "s_i_id": 30184, "ordercount": 839 }
+{ "s_i_id": 57768, "ordercount": 839 }
+{ "s_i_id": 77691, "ordercount": 839 }
+{ "s_i_id": 40297, "ordercount": 838 }
+{ "s_i_id": 89107, "ordercount": 838 }
+{ "s_i_id": 43996, "ordercount": 836 }
+{ "s_i_id": 20184, "ordercount": 830 }
+{ "s_i_id": 81306, "ordercount": 830 }
+{ "s_i_id": 17164, "ordercount": 829 }
+{ "s_i_id": 84664, "ordercount": 825 }
+{ "s_i_id": 92742, "ordercount": 825 }
+{ "s_i_id": 19353, "ordercount": 824 }
+{ "s_i_id": 62355, "ordercount": 823 }
+{ "s_i_id": 79250, "ordercount": 823 }
+{ "s_i_id": 13744, "ordercount": 821 }
+{ "s_i_id": 86105, "ordercount": 819 }
+{ "s_i_id": 56062, "ordercount": 818 }
+{ "s_i_id": 82318, "ordercount": 816 }
+{ "s_i_id": 24538, "ordercount": 813 }
+{ "s_i_id": 38748, "ordercount": 809 }
+{ "s_i_id": 78958, "ordercount": 809 }
+{ "s_i_id": 69250, "ordercount": 807 }
+{ "s_i_id": 79568, "ordercount": 805 }
+{ "s_i_id": 18075, "ordercount": 804 }
+{ "s_i_id": 7164, "ordercount": 802 }
+{ "s_i_id": 14724, "ordercount": 800 }
+{ "s_i_id": 11327, "ordercount": 799 }
+{ "s_i_id": 19404, "ordercount": 798 }
+{ "s_i_id": 11903, "ordercount": 793 }
+{ "s_i_id": 17265, "ordercount": 793 }
+{ "s_i_id": 86992, "ordercount": 793 }
+{ "s_i_id": 34664, "ordercount": 790 }
+{ "s_i_id": 61540, "ordercount": 789 }
+{ "s_i_id": 80056, "ordercount": 788 }
+{ "s_i_id": 80767, "ordercount": 786 }
+{ "s_i_id": 51903, "ordercount": 785 }
+{ "s_i_id": 98748, "ordercount": 784 }
+{ "s_i_id": 3746, "ordercount": 780 }
+{ "s_i_id": 26231, "ordercount": 779 }
+{ "s_i_id": 31068, "ordercount": 778 }
+{ "s_i_id": 26172, "ordercount": 777 }
+{ "s_i_id": 36250, "ordercount": 774 }
+{ "s_i_id": 13746, "ordercount": 773 }
+{ "s_i_id": 33586, "ordercount": 770 }
+{ "s_i_id": 8798, "ordercount": 769 }
+{ "s_i_id": 36172, "ordercount": 768 }
+{ "s_i_id": 9406, "ordercount": 767 }
+{ "s_i_id": 80422, "ordercount": 764 }
+{ "s_i_id": 26889, "ordercount": 763 }
+{ "s_i_id": 74946, "ordercount": 763 }
+{ "s_i_id": 89406, "ordercount": 757 }
+{ "s_i_id": 48502, "ordercount": 756 }
+{ "s_i_id": 41365, "ordercount": 752 }
+{ "s_i_id": 77138, "ordercount": 748 }
+{ "s_i_id": 31824, "ordercount": 747 }
+{ "s_i_id": 77506, "ordercount": 743 }
+{ "s_i_id": 45455, "ordercount": 741 }
+{ "s_i_id": 1903, "ordercount": 740 }
+{ "s_i_id": 11368, "ordercount": 740 }
+{ "s_i_id": 93835, "ordercount": 740 }
+{ "s_i_id": 62558, "ordercount": 739 }
+{ "s_i_id": 92805, "ordercount": 739 }
+{ "s_i_id": 51773, "ordercount": 736 }
+{ "s_i_id": 98007, "ordercount": 736 }
+{ "s_i_id": 84724, "ordercount": 735 }
+{ "s_i_id": 22957, "ordercount": 734 }
+{ "s_i_id": 61807, "ordercount": 733 }
+{ "s_i_id": 76494, "ordercount": 733 }
+{ "s_i_id": 5436, "ordercount": 731 }
+{ "s_i_id": 48687, "ordercount": 730 }
+{ "s_i_id": 89377, "ordercount": 726 }
+{ "s_i_id": 74792, "ordercount": 722 }
+{ "s_i_id": 47018, "ordercount": 721 }
+{ "s_i_id": 67691, "ordercount": 720 }
+{ "s_i_id": 58958, "ordercount": 719 }
+{ "s_i_id": 12805, "ordercount": 717 }
+{ "s_i_id": 49673, "ordercount": 713 }
+{ "s_i_id": 48315, "ordercount": 710 }
+{ "s_i_id": 63073, "ordercount": 709 }
+{ "s_i_id": 63835, "ordercount": 709 }
+{ "s_i_id": 26442, "ordercount": 708 }
+{ "s_i_id": 19568, "ordercount": 707 }
+{ "s_i_id": 65455, "ordercount": 707 }
+{ "s_i_id": 58290, "ordercount": 706 }
+{ "s_i_id": 27860, "ordercount": 704 }
+{ "s_i_id": 37803, "ordercount": 699 }
+{ "s_i_id": 75436, "ordercount": 699 }
+{ "s_i_id": 30562, "ordercount": 698 }
+{ "s_i_id": 1540, "ordercount": 696 }
+{ "s_i_id": 47768, "ordercount": 694 }
+{ "s_i_id": 82462, "ordercount": 694 }
+{ "s_i_id": 10184, "ordercount": 691 }
+{ "s_i_id": 63378, "ordercount": 691 }
+{ "s_i_id": 22647, "ordercount": 688 }
+{ "s_i_id": 96494, "ordercount": 687 }
+{ "s_i_id": 6148, "ordercount": 686 }
+{ "s_i_id": 55794, "ordercount": 685 }
+{ "s_i_id": 42877, "ordercount": 682 }
+{ "s_i_id": 97337, "ordercount": 681 }
+{ "s_i_id": 31773, "ordercount": 680 }
+{ "s_i_id": 68502, "ordercount": 680 }
+{ "s_i_id": 37489, "ordercount": 678 }
+{ "s_i_id": 4538, "ordercount": 676 }
+{ "s_i_id": 83073, "ordercount": 676 }
+{ "s_i_id": 1807, "ordercount": 675 }
+{ "s_i_id": 297, "ordercount": 668 }
+{ "s_i_id": 78798, "ordercount": 668 }
+{ "s_i_id": 46546, "ordercount": 666 }
+{ "s_i_id": 68462, "ordercount": 662 }
+{ "s_i_id": 81557, "ordercount": 661 }
+{ "s_i_id": 82945, "ordercount": 661 }
+{ "s_i_id": 19366, "ordercount": 660 }
+{ "s_i_id": 42945, "ordercount": 659 }
+{ "s_i_id": 43210, "ordercount": 658 }
+{ "s_i_id": 94664, "ordercount": 654 }
+{ "s_i_id": 50056, "ordercount": 651 }
+{ "s_i_id": 60476, "ordercount": 651 }
+{ "s_i_id": 65794, "ordercount": 651 }
+{ "s_i_id": 50529, "ordercount": 649 }
+{ "s_i_id": 90767, "ordercount": 649 }
+{ "s_i_id": 16494, "ordercount": 647 }
+{ "s_i_id": 14963, "ordercount": 646 }
+{ "s_i_id": 41368, "ordercount": 646 }
+{ "s_i_id": 73996, "ordercount": 645 }
+{ "s_i_id": 46442, "ordercount": 644 }
+{ "s_i_id": 57489, "ordercount": 643 }
+{ "s_i_id": 46398, "ordercount": 640 }
+{ "s_i_id": 99568, "ordercount": 639 }
+{ "s_i_id": 61406, "ordercount": 638 }
+{ "s_i_id": 50184, "ordercount": 637 }
+{ "s_i_id": 53073, "ordercount": 637 }
+{ "s_i_id": 33746, "ordercount": 634 }
+{ "s_i_id": 80297, "ordercount": 630 }
+{ "s_i_id": 6653, "ordercount": 622 }
+{ "s_i_id": 78027, "ordercount": 619 }
+{ "s_i_id": 85655, "ordercount": 619 }
+{ "s_i_id": 28007, "ordercount": 611 }
+{ "s_i_id": 52355, "ordercount": 611 }
+{ "s_i_id": 90529, "ordercount": 609 }
+{ "s_i_id": 17691, "ordercount": 608 }
+{ "s_i_id": 60529, "ordercount": 608 }
+{ "s_i_id": 85770, "ordercount": 608 }
+{ "s_i_id": 54419, "ordercount": 602 }
+{ "s_i_id": 92685, "ordercount": 601 }
+{ "s_i_id": 94234, "ordercount": 601 }
+{ "s_i_id": 97489, "ordercount": 601 }
+{ "s_i_id": 95436, "ordercount": 600 }
+{ "s_i_id": 17337, "ordercount": 598 }
+{ "s_i_id": 30254, "ordercount": 598 }
+{ "s_i_id": 58687, "ordercount": 596 }
+{ "s_i_id": 623, "ordercount": 589 }
+{ "s_i_id": 11540, "ordercount": 589 }
+{ "s_i_id": 81365, "ordercount": 589 }
+{ "s_i_id": 94192, "ordercount": 589 }
+{ "s_i_id": 8502, "ordercount": 588 }
+{ "s_i_id": 43835, "ordercount": 588 }
+{ "s_i_id": 85436, "ordercount": 588 }
+{ "s_i_id": 88748, "ordercount": 585 }
+{ "s_i_id": 20529, "ordercount": 575 }
+{ "s_i_id": 80838, "ordercount": 575 }
+{ "s_i_id": 39632, "ordercount": 573 }
+{ "s_i_id": 81327, "ordercount": 573 }
+{ "s_i_id": 22383, "ordercount": 572 }
+{ "s_i_id": 2407, "ordercount": 568 }
+{ "s_i_id": 34538, "ordercount": 567 }
+{ "s_i_id": 12407, "ordercount": 566 }
+{ "s_i_id": 40414, "ordercount": 566 }
+{ "s_i_id": 45623, "ordercount": 566 }
+{ "s_i_id": 30052, "ordercount": 565 }
+{ "s_i_id": 85666, "ordercount": 564 }
+{ "s_i_id": 81824, "ordercount": 562 }
+{ "s_i_id": 52945, "ordercount": 560 }
+{ "s_i_id": 75688, "ordercount": 555 }
+{ "s_i_id": 82986, "ordercount": 553 }
+{ "s_i_id": 45770, "ordercount": 552 }
+{ "s_i_id": 38074, "ordercount": 549 }
+{ "s_i_id": 14946, "ordercount": 548 }
+{ "s_i_id": 83677, "ordercount": 547 }
+{ "s_i_id": 94724, "ordercount": 547 }
+{ "s_i_id": 8081, "ordercount": 544 }
+{ "s_i_id": 65770, "ordercount": 544 }
+{ "s_i_id": 13378, "ordercount": 537 }
+{ "s_i_id": 33234, "ordercount": 536 }
+{ "s_i_id": 8695, "ordercount": 533 }
+{ "s_i_id": 34192, "ordercount": 533 }
+{ "s_i_id": 18021, "ordercount": 531 }
+{ "s_i_id": 25794, "ordercount": 531 }
+{ "s_i_id": 48021, "ordercount": 531 }
+{ "s_i_id": 16546, "ordercount": 527 }
+{ "s_i_id": 42111, "ordercount": 526 }
+{ "s_i_id": 33996, "ordercount": 525 }
+{ "s_i_id": 96231, "ordercount": 523 }
+{ "s_i_id": 24234, "ordercount": 522 }
+{ "s_i_id": 99648, "ordercount": 519 }
+{ "s_i_id": 21824, "ordercount": 518 }
+{ "s_i_id": 25642, "ordercount": 517 }
+{ "s_i_id": 32924, "ordercount": 516 }
+{ "s_i_id": 91807, "ordercount": 514 }
+{ "s_i_id": 31826, "ordercount": 511 }
+{ "s_i_id": 38075, "ordercount": 510 }
+{ "s_i_id": 5138, "ordercount": 506 }
+{ "s_i_id": 45642, "ordercount": 505 }
+{ "s_i_id": 91826, "ordercount": 505 }
+{ "s_i_id": 42685, "ordercount": 503 }
+{ "s_i_id": 83744, "ordercount": 503 }
+{ "s_i_id": 59250, "ordercount": 502 }
+{ "s_i_id": 79353, "ordercount": 500 }
+{ "s_i_id": 88290, "ordercount": 500 }
+{ "s_i_id": 2989, "ordercount": 499 }
+{ "s_i_id": 35688, "ordercount": 499 }
+{ "s_i_id": 32957, "ordercount": 498 }
+{ "s_i_id": 82989, "ordercount": 493 }
+{ "s_i_id": 49632, "ordercount": 490 }
+{ "s_i_id": 5623, "ordercount": 489 }
+{ "s_i_id": 43073, "ordercount": 487 }
+{ "s_i_id": 6383, "ordercount": 485 }
+{ "s_i_id": 40444, "ordercount": 484 }
+{ "s_i_id": 40056, "ordercount": 478 }
+{ "s_i_id": 99366, "ordercount": 478 }
+{ "s_i_id": 12924, "ordercount": 477 }
+{ "s_i_id": 99673, "ordercount": 476 }
+{ "s_i_id": 2558, "ordercount": 475 }
+{ "s_i_id": 53744, "ordercount": 474 }
+{ "s_i_id": 6231, "ordercount": 470 }
+{ "s_i_id": 69366, "ordercount": 469 }
+{ "s_i_id": 20254, "ordercount": 466 }
+{ "s_i_id": 57164, "ordercount": 463 }
+{ "s_i_id": 65436, "ordercount": 463 }
+{ "s_i_id": 88910, "ordercount": 461 }
+{ "s_i_id": 47489, "ordercount": 458 }
+{ "s_i_id": 66383, "ordercount": 458 }
+{ "s_i_id": 71693, "ordercount": 455 }
+{ "s_i_id": 46172, "ordercount": 453 }
+{ "s_i_id": 63677, "ordercount": 453 }
+{ "s_i_id": 54192, "ordercount": 450 }
+{ "s_i_id": 81431, "ordercount": 450 }
+{ "s_i_id": 27489, "ordercount": 449 }
+{ "s_i_id": 45666, "ordercount": 448 }
+{ "s_i_id": 60838, "ordercount": 446 }
+{ "s_i_id": 60254, "ordercount": 444 }
+{ "s_i_id": 50653, "ordercount": 442 }
+{ "s_i_id": 69377, "ordercount": 441 }
+{ "s_i_id": 43586, "ordercount": 439 }
+{ "s_i_id": 4963, "ordercount": 438 }
+{ "s_i_id": 74349, "ordercount": 436 }
+{ "s_i_id": 8075, "ordercount": 434 }
+{ "s_i_id": 91824, "ordercount": 434 }
+{ "s_i_id": 77803, "ordercount": 433 }
+{ "s_i_id": 42318, "ordercount": 432 }
+{ "s_i_id": 8074, "ordercount": 431 }
+{ "s_i_id": 56, "ordercount": 429 }
+{ "s_i_id": 7337, "ordercount": 429 }
+{ "s_i_id": 53835, "ordercount": 427 }
+{ "s_i_id": 17489, "ordercount": 426 }
+{ "s_i_id": 34349, "ordercount": 426 }
+{ "s_i_id": 45688, "ordercount": 425 }
+{ "s_i_id": 6546, "ordercount": 424 }
+{ "s_i_id": 9422, "ordercount": 422 }
+{ "s_i_id": 48074, "ordercount": 420 }
+{ "s_i_id": 1314, "ordercount": 419 }
+{ "s_i_id": 15138, "ordercount": 419 }
+{ "s_i_id": 62957, "ordercount": 419 }
+{ "s_i_id": 29568, "ordercount": 418 }
+{ "s_i_id": 34234, "ordercount": 418 }
+{ "s_i_id": 71327, "ordercount": 415 }
+{ "s_i_id": 3744, "ordercount": 414 }
+{ "s_i_id": 56889, "ordercount": 411 }
+{ "s_i_id": 14856, "ordercount": 405 }
+{ "s_i_id": 21314, "ordercount": 405 }
+{ "s_i_id": 24856, "ordercount": 403 }
+{ "s_i_id": 99353, "ordercount": 403 }
+{ "s_i_id": 47164, "ordercount": 400 }
+{ "s_i_id": 37194, "ordercount": 399 }
+{ "s_i_id": 90056, "ordercount": 395 }
+{ "s_i_id": 32989, "ordercount": 388 }
+{ "s_i_id": 5860, "ordercount": 385 }
+{ "s_i_id": 61773, "ordercount": 383 }
+{ "s_i_id": 92647, "ordercount": 383 }
+{ "s_i_id": 87691, "ordercount": 377 }
+{ "s_i_id": 24024, "ordercount": 376 }
+{ "s_i_id": 11837, "ordercount": 374 }
+{ "s_i_id": 32647, "ordercount": 374 }
+{ "s_i_id": 73586, "ordercount": 373 }
+{ "s_i_id": 77759, "ordercount": 372 }
+{ "s_i_id": 70868, "ordercount": 371 }
+{ "s_i_id": 62111, "ordercount": 370 }
+{ "s_i_id": 85688, "ordercount": 369 }
+{ "s_i_id": 21826, "ordercount": 368 }
+{ "s_i_id": 71754, "ordercount": 368 }
+{ "s_i_id": 37768, "ordercount": 367 }
+{ "s_i_id": 7194, "ordercount": 363 }
+{ "s_i_id": 7489, "ordercount": 360 }
+{ "s_i_id": 80891, "ordercount": 358 }
+{ "s_i_id": 47028, "ordercount": 352 }
+{ "s_i_id": 67489, "ordercount": 346 }
+{ "s_i_id": 72945, "ordercount": 346 }
+{ "s_i_id": 58591, "ordercount": 344 }
+{ "s_i_id": 82383, "ordercount": 341 }
+{ "s_i_id": 86062, "ordercount": 338 }
+{ "s_i_id": 32355, "ordercount": 332 }
+{ "s_i_id": 84024, "ordercount": 329 }
+{ "s_i_id": 73744, "ordercount": 326 }
+{ "s_i_id": 68315, "ordercount": 325 }
+{ "s_i_id": 64664, "ordercount": 321 }
+{ "s_i_id": 68081, "ordercount": 319 }
+{ "s_i_id": 3153, "ordercount": 313 }
+{ "s_i_id": 9568, "ordercount": 313 }
+{ "s_i_id": 90562, "ordercount": 311 }
+{ "s_i_id": 67923, "ordercount": 309 }
+{ "s_i_id": 31306, "ordercount": 306 }
+{ "s_i_id": 38315, "ordercount": 306 }
+{ "s_i_id": 48462, "ordercount": 305 }
+{ "s_i_id": 23996, "ordercount": 304 }
+{ "s_i_id": 14318, "ordercount": 303 }
+{ "s_i_id": 51697, "ordercount": 301 }
+{ "s_i_id": 31693, "ordercount": 293 }
+{ "s_i_id": 6398, "ordercount": 292 }
+{ "s_i_id": 47759, "ordercount": 292 }
+{ "s_i_id": 61314, "ordercount": 291 }
+{ "s_i_id": 52939, "ordercount": 288 }
+{ "s_i_id": 75666, "ordercount": 288 }
+{ "s_i_id": 838, "ordercount": 286 }
+{ "s_i_id": 78074, "ordercount": 281 }
+{ "s_i_id": 254, "ordercount": 279 }
+{ "s_i_id": 63210, "ordercount": 279 }
+{ "s_i_id": 46859, "ordercount": 277 }
+{ "s_i_id": 52685, "ordercount": 277 }
+{ "s_i_id": 33153, "ordercount": 274 }
+{ "s_i_id": 31327, "ordercount": 273 }
+{ "s_i_id": 98502, "ordercount": 273 }
+{ "s_i_id": 17759, "ordercount": 272 }
+{ "s_i_id": 20562, "ordercount": 269 }
+{ "s_i_id": 93210, "ordercount": 262 }
+{ "s_i_id": 52877, "ordercount": 258 }
+{ "s_i_id": 69673, "ordercount": 257 }
+{ "s_i_id": 49366, "ordercount": 256 }
+{ "s_i_id": 48075, "ordercount": 250 }
+{ "s_i_id": 14024, "ordercount": 248 }
+{ "s_i_id": 42742, "ordercount": 247 }
+{ "s_i_id": 32986, "ordercount": 244 }
+{ "s_i_id": 69348, "ordercount": 236 }
+{ "s_i_id": 62939, "ordercount": 235 }
+{ "s_i_id": 63746, "ordercount": 235 }
+{ "s_i_id": 93677, "ordercount": 234 }
+{ "s_i_id": 82647, "ordercount": 232 }
+{ "s_i_id": 12111, "ordercount": 231 }
+{ "s_i_id": 93029, "ordercount": 227 }
+{ "s_i_id": 31903, "ordercount": 222 }
+{ "s_i_id": 97768, "ordercount": 214 }
+{ "s_i_id": 72742, "ordercount": 212 }
+{ "s_i_id": 65642, "ordercount": 211 }
+{ "s_i_id": 26148, "ordercount": 209 }
+{ "s_i_id": 88591, "ordercount": 206 }
+{ "s_i_id": 52607, "ordercount": 205 }
+{ "s_i_id": 38290, "ordercount": 204 }
+{ "s_i_id": 27194, "ordercount": 203 }
+{ "s_i_id": 95666, "ordercount": 200 }
+{ "s_i_id": 98958, "ordercount": 199 }
+{ "s_i_id": 5666, "ordercount": 198 }
+{ "s_i_id": 46250, "ordercount": 198 }
+{ "s_i_id": 44318, "ordercount": 194 }
+{ "s_i_id": 49249, "ordercount": 192 }
+{ "s_i_id": 2462, "ordercount": 189 }
+{ "s_i_id": 68007, "ordercount": 185 }
+{ "s_i_id": 93073, "ordercount": 185 }
+{ "s_i_id": 38462, "ordercount": 184 }
+{ "s_i_id": 6859, "ordercount": 183 }
+{ "s_i_id": 10529, "ordercount": 183 }
+{ "s_i_id": 2742, "ordercount": 182 }
+{ "s_i_id": 76442, "ordercount": 182 }
+{ "s_i_id": 81697, "ordercount": 182 }
+{ "s_i_id": 88021, "ordercount": 182 }
+{ "s_i_id": 52558, "ordercount": 181 }
+{ "s_i_id": 444, "ordercount": 177 }
+{ "s_i_id": 8687, "ordercount": 176 }
+{ "s_i_id": 562, "ordercount": 175 }
+{ "s_i_id": 1557, "ordercount": 175 }
+{ "s_i_id": 40184, "ordercount": 173 }
+{ "s_i_id": 86733, "ordercount": 173 }
+{ "s_i_id": 67164, "ordercount": 165 }
+{ "s_i_id": 15794, "ordercount": 164 }
+{ "s_i_id": 90444, "ordercount": 164 }
+{ "s_i_id": 476, "ordercount": 163 }
+{ "s_i_id": 61837, "ordercount": 162 }
+{ "s_i_id": 64024, "ordercount": 160 }
+{ "s_i_id": 2478, "ordercount": 159 }
+{ "s_i_id": 74419, "ordercount": 156 }
+{ "s_i_id": 87138, "ordercount": 156 }
+{ "s_i_id": 79377, "ordercount": 154 }
+{ "s_i_id": 12462, "ordercount": 150 }
+{ "s_i_id": 52647, "ordercount": 147 }
+{ "s_i_id": 83210, "ordercount": 147 }
+{ "s_i_id": 20476, "ordercount": 146 }
+{ "s_i_id": 26398, "ordercount": 145 }
+{ "s_i_id": 66105, "ordercount": 138 }
+{ "s_i_id": 68075, "ordercount": 135 }
+{ "s_i_id": 42558, "ordercount": 133 }
+{ "s_i_id": 51754, "ordercount": 132 }
+{ "s_i_id": 90414, "ordercount": 132 }
+{ "s_i_id": 26796, "ordercount": 131 }
+{ "s_i_id": 8027, "ordercount": 130 }
+{ "s_i_id": 90653, "ordercount": 130 }
+{ "s_i_id": 60422, "ordercount": 129 }
+{ "s_i_id": 66442, "ordercount": 129 }
+{ "s_i_id": 41693, "ordercount": 127 }
+{ "s_i_id": 90179, "ordercount": 126 }
+{ "s_i_id": 99406, "ordercount": 126 }
+{ "s_i_id": 42805, "ordercount": 124 }
+{ "s_i_id": 98462, "ordercount": 123 }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.14.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.14.adm
new file mode 100644
index 0000000..0ec8884
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.14.adm
@@ -0,0 +1,11 @@
+{ "high_line_COUNT": 244, "low_line_COUNT": 1064, "o_ol_cnt": 5 }
+{ "high_line_COUNT": 383, "low_line_COUNT": 1273, "o_ol_cnt": 6 }
+{ "high_line_COUNT": 387, "low_line_COUNT": 1626, "o_ol_cnt": 7 }
+{ "high_line_COUNT": 500, "low_line_COUNT": 1820, "o_ol_cnt": 8 }
+{ "high_line_COUNT": 640, "low_line_COUNT": 2091, "o_ol_cnt": 9 }
+{ "high_line_COUNT": 637, "low_line_COUNT": 2194, "o_ol_cnt": 10 }
+{ "high_line_COUNT": 631, "low_line_COUNT": 2595, "o_ol_cnt": 11 }
+{ "high_line_COUNT": 660, "low_line_COUNT": 2946, "o_ol_cnt": 12 }
+{ "high_line_COUNT": 704, "low_line_COUNT": 3176, "o_ol_cnt": 13 }
+{ "high_line_COUNT": 778, "low_line_COUNT": 3075, "o_ol_cnt": 14 }
+{ "high_line_COUNT": 872, "low_line_COUNT": 3188, "o_ol_cnt": 15 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.16.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.16.adm
new file mode 100644
index 0000000..b2e6c87
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.16.adm
@@ -0,0 +1 @@
+{ "promo_revenue": 0.020735498433451214 }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.17.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.17.adm
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.17.adm
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.18.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.18.adm
new file mode 100644
index 0000000..764def6
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.18.adm
@@ -0,0 +1,200 @@
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "acdsefpmxstbeejzabeoa", "i_price": 65.79 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "actalujqsujfmful", "i_price": 37.14 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "agvihqzfyctogc", "i_price": 2.03 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ajkwrgsnmixxjgkiqhxcgi", "i_price": 60.06 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "akfebarqnxubbctmklkmuhoo", "i_price": 49.98 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "anrqqzfpyzlfczxfa", "i_price": 58.4 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "apsqtslsqbxfjst", "i_price": 51.56 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "aubfpyqwzjzafmsvfs", "i_price": 46.95 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "aunzfapusxkakqifrzm", "i_price": 79.42 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "avpszyecjxxlfokehc", "i_price": 14.25 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bdpysnvyvfnvmxw", "i_price": 39.46 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bfeucrvmvxpdhw", "i_price": 5.53 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bfuhahdejrmnfydv", "i_price": 46.72 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bfurwrbdaecshwzqvfgdi", "i_price": 1.22 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bgkxyakxtijrkssfinymjn", "i_price": 88.79 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bisuxmdjnlqeptvndcsven", "i_price": 47.58 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bmiwkpmewjgadrgj", "i_price": 44.71 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "brsudlukejnlvltkknvwjxje", "i_price": 47.05 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bskqgmiefeipbrgmj", "i_price": 92.17 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "buajgdkomevijq", "i_price": 44.05 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bucnpyedybejyujisixmml", "i_price": 11.4 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bunkgzddthrlfawyzy", "i_price": 25.88 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bxszrqkvkhzcznqmuvmp", "i_price": 86.91 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "bxynijrpajvyqjkiyfam", "i_price": 11.47 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "capmmgzqbzzowfiucv", "i_price": 18.84 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ccueccsjkccyxknbi", "i_price": 47.06 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cghsymmofcdyli", "i_price": 73.81 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "chbsuhnmlsfwlat", "i_price": 21.78 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cimeeetarqrigkodje", "i_price": 6.67 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "clslsozoxfklgvwseqtkxvqk", "i_price": 27.39 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cmcflcbxxlvymweexfbf", "i_price": 22.74 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cnykbolnovuiljeqjgut", "i_price": 47.41 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cqgnedwrpiiwrisf", "i_price": 6.9 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cqmlcnqscnswfuydmfxqa", "i_price": 12.91 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cssexylxjsgdfzhrwwqqnol", "i_price": 17.31 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cuhtauewayjoffzfkrdvcgz", "i_price": 28.73 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cwkjzxtwzisogoon", "i_price": 30.67 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cwklfewqbuluqslbuxpvx", "i_price": 13.03 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "cygfgjvrhcrvmpvxmwy", "i_price": 46.8 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dabbpecsylvxye", "i_price": 29.34 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dagsxqojzbqxsf", "i_price": 32.46 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dbsnkrsdxvpqgzzhkelrz", "i_price": 62.81 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dewskhxtkvrxjakweieyus", "i_price": 9.31 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dhfbqidipmtqwox", "i_price": 88.38 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dhgazhrsqstevykptfdevzwv", "i_price": 42.8 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dhtshvggatnbyc", "i_price": 39.51 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dkwjwqcetibdbmtyipyi", "i_price": 49.55 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dmszygdscibkleuzxyqbt", "i_price": 66.36 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dpkpnhuftsdijfq", "i_price": 86.42 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dpqgneewkwzhtrtksqr", "i_price": 20.7 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dqjembdyzkevetgmqfo", "i_price": 49.13 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "drssioykcofbjv", "i_price": 69.76 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dsfbimbjnitbazbelurfeogs", "i_price": 16.43 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dthlzygbrqoekaubbay", "i_price": 1.55 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "dyweighzbfphpgv", "i_price": 77.98 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ecuzlfnefhivsvbrynsul", "i_price": 97.11 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ecvwagmdparwxnbrg", "i_price": 15.4 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "eddkljzeuunlradmjbx", "i_price": 6.28 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "egadcpdyuyqqok", "i_price": 74.73 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "eisehvupwnfqsrajguesymnc", "i_price": 50.77 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "eludanwokxjcchczgjxn", "i_price": 17.36 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "epookxlcdzlapotjtavrhg", "i_price": 35.28 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "eqfoznvgunwlgxjsd", "i_price": 67.93 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "erxljyatnqpgxjdmkfwfbau", "i_price": 18.84 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "eyqjaywwkkixirxct", "i_price": 49.13 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "favtbevzgccnpveg", "i_price": 23.44 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fbgizmrxgbmenrju", "i_price": 35.17 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fbrtjvsceyxkzgaoofejduln", "i_price": 47.61 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fchrurvpamdcmhjvftzrp", "i_price": 96.49 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fewiyxqshgjnazbsz", "i_price": 71.64 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fhbnjwuaosdqrefemrfmlsa", "i_price": 78.38 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fhsdrtkrqatxohhn", "i_price": 39.1 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fitblllwiwwoubxpung", "i_price": 31.81 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fkjtcafwmpllzzsyj", "i_price": 25.64 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fkmrfflbwwibykit", "i_price": 66.09 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "flypybisydvnwspzzlrrmvwa", "i_price": 30.71 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fnhujjrdaeychf", "i_price": 92.49 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fojfnbzjtrivisybgxtmgsq", "i_price": 70.47 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "foxpufjflpgoevbkkjbtooz", "i_price": 20.0 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fpotxvxzhxfdixp", "i_price": 90.63 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fryknezibgquwwj", "i_price": 79.69 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fsjvvfjcfscmfgof", "i_price": 89.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fuwwbkrpjwtdpp", "i_price": 70.82 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fvxuwutijrejhueqpnf", "i_price": 49.36 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fxfgfrrjtbydeumr", "i_price": 15.37 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "fxwnpuzsoavpscpogrt", "i_price": 3.39 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gcxhysalbiylsexlt", "i_price": 72.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ggdtpydoxymrvtzb", "i_price": 81.75 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gjsxdmwoykhaxhdnupjemf", "i_price": 68.13 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gkhjyiipustqga", "i_price": 31.6 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gkilzwcgjxkkrnfkns", "i_price": 41.14 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gkverljkjhzygjrhdznv", "i_price": 60.63 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gmgyntreiozfljfdxtuxz", "i_price": 76.89 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gmtfcxvcbqqfishvzsxw", "i_price": 35.26 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gnkenpomqttkghy", "i_price": 25.83 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "goicxiwlvczqsikik", "i_price": 97.07 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gpnmakmqzygivj", "i_price": 81.31 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gpoxnjwqthmpcvg", "i_price": 49.51 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "grrbtpsebjevptzurvujvf", "i_price": 14.85 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gvkmizaheboosqd", "i_price": 29.46 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gzboyadokluwjz", "i_price": 15.99 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gzbsbyweklkmebvrgsadc", "i_price": 15.36 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "gzmksrfkwqcmwxwfny", "i_price": 88.3 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hawjkvdxefynemtalqas", "i_price": 29.56 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hhdegwodnyepmcmvpvaztkg", "i_price": 95.61 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hlgfdkkjzhgksjbd", "i_price": 86.2 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hloxcatovulwvazhdgl", "i_price": 19.96 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hmadomomdzbbnepkgnxcv", "i_price": 87.35 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hoilgijuqsguzugshfmf", "i_price": 28.9 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hpsqjcrycabivc", "i_price": 98.24 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hqjkiblmziuxjjuzgsbam", "i_price": 64.51 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hqjqgncrohzguwzwyzsj", "i_price": 50.86 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hqthvoalrztywufl", "i_price": 28.76 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hqzypzpfdfiasdzjmezlam", "i_price": 49.74 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hrpaovfuojprxtpfrab", "i_price": 80.54 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "htlxqmcifhqrwtnymdmkx", "i_price": 90.56 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "hybksrtiwpwbpvxlsha", "i_price": 84.63 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "iffecyvnawmbiatpxxkj", "i_price": 66.09 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ijtxxjupatqioduli", "i_price": 10.63 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "imusttrvhlroaihadjo", "i_price": 61.95 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "inaipuwgbmdmeulbszx", "i_price": 34.98 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "isjzutlfawvvtqxkgrmj", "i_price": 85.93 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "iumxmjdsuzhaiiraf", "i_price": 1.41 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "iuvyftopkabajgmwvgtqbeo", "i_price": 50.08 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "iwwuhziovmkovvyccjpedq", "i_price": 52.68 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "izoapvedcfpcdvcyvnsjoo", "i_price": 9.08 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jahzdjfystumkftgadauzzo", "i_price": 97.5 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jaxjvzbqvtepmhgywdz", "i_price": 20.24 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jdpbwhwuqikngpyipgwngc", "i_price": 52.56 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jehayocuavsccrllnjpjght", "i_price": 35.92 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jgfjtcnruizwqpou", "i_price": 6.09 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jlqhqcueunotswebcjlpvva", "i_price": 82.78 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jmujayemawlvvbm", "i_price": 83.51 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jouroehensrjbuuvtljf", "i_price": 14.79 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jowvxuvqjrkzaa", "i_price": 22.86 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jqlqnttxuksmufecmql", "i_price": 64.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jszdndkruckvcqd", "i_price": 71.66 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jsziazkkrwyachoprceptd", "i_price": 67.61 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jtifdcwbemywphaoqg", "i_price": 22.06 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jtnjmygtrrfnsaz", "i_price": 98.27 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jtwrwkqmkphtbmmracyej", "i_price": 1.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jvbxbhwkmaodlaquchsrgzfw", "i_price": 18.67 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "jyezffhnvcdwdfn", "i_price": 24.86 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kamztdsxsikjeproutnc", "i_price": 72.86 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kecazqvgsfjklt", "i_price": 43.0 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kftnindjhgilvcodnzezkvay", "i_price": 69.21 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kheoetlahjyunjmrw", "i_price": 53.43 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kjghxppgrqbbtcaymbdmhxs", "i_price": 83.33 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "knihjbwtltrntsuxaovruyor", "i_price": 19.73 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kpjfqoeeyfxckykmcxl", "i_price": 91.13 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kqhzjvltggsazymyrh", "i_price": 18.35 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kqqrxikzbzcnpkwhhepvgho", "i_price": 69.05 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kqryfzcrwlueobmznkmygd", "i_price": 30.0 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ktwdvwftcsygdmhv", "i_price": 5.71 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kumeoeoumnxkfo", "i_price": 81.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kumevlrwbdikuqbeltcdknxc", "i_price": 16.01 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kvjxafxecmqyeydkfktsatjf", "i_price": 7.73 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kyxbgiwekbpwlsommw", "i_price": 36.2 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kzdwvouzbcntlgcdofml", "i_price": 86.95 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "kzyumyfgrqhfnstwvqgvhcm", "i_price": 76.85 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lchxcxldcoquerrvxttuda", "i_price": 17.68 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "legxtubqewfuxqatfjn", "i_price": 51.31 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lkcgzkedszruiualsh", "i_price": 70.64 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lloafkfoyxmqguysluyozbw", "i_price": 21.0 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lpaelhgzqgvtdv", "i_price": 70.37 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lphpqefzuezwyq", "i_price": 43.15 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lrdalefugvqvlktmdvglkk", "i_price": 96.38 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lrgayzzdjricrhukkhxt", "i_price": 76.72 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lssatkebhjsosohfsl", "i_price": 79.11 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lujqiiupklxifftoxnyxngca", "i_price": 41.6 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "luxprtebzgdxyym", "i_price": 3.34 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lvfmtzpsmxaxdkyitg", "i_price": 96.67 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lvhfoeqovgcfjdamzgnjgi", "i_price": 32.25 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lxmapbjueenmptvryrdyxv", "i_price": 65.28 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lxrythqqlxpqcveoez", "i_price": 33.03 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lyelqeyjsvgdtgdczozg", "i_price": 44.06 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "lzhfislbipdvgh", "i_price": 70.9 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mbmefelpowpqxs", "i_price": 21.06 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mdatcbyqchgkrapzn", "i_price": 44.29 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mdcnqcmzylyjypwhnbtgd", "i_price": 50.75 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "meqllrvyuozqqilevmjgpkol", "i_price": 16.82 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mewjfjjnlbbhuhjknrbaay", "i_price": 88.45 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mfckudxibtqmqweijomceozk", "i_price": 23.98 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mgjvndxvjtknyjxx", "i_price": 46.04 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mgthfbaxmurnxknjdg", "i_price": 77.83 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mlebfdrtqfmkdhm", "i_price": 42.59 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mloqumgdpbkqcuelqus", "i_price": 84.57 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mpvxsnqsbpocxqnt", "i_price": 68.09 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mquhlngqpaytuj", "i_price": 57.12 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "muylbgugftojciflbywsf", "i_price": 16.41 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mxcyjxqgkjdsksjpo", "i_price": 19.13 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "myzwndkegzomyvyml", "i_price": 67.72 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "mzmqjdficvtwjv", "i_price": 45.04 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "nanjnepobyifprodwjrbkaq", "i_price": 73.96 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "nbeoptzzwwtwiptyp", "i_price": 40.79 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "neasqhcrfqqtkdpiswkqlv", "i_price": 89.77 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "nggusfubfmmpwe", "i_price": 83.22 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ngkcdzcnslrmqrxihfilgegq", "i_price": 86.0 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "ngrezlcoyjfrxsgavqwbfisg", "i_price": 72.05 }
+{ "brand": "ORI", "supplier_cnt": 1, "i_name": "niokzjmnsbxjhvgdjrp", "i_price": 38.76 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.19.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.19.adm
new file mode 100644
index 0000000..e83527e
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.19.adm
@@ -0,0 +1 @@
+{ "AVG_yearly": 2856942.0349999997 }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.20.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.20.adm
new file mode 100644
index 0000000..fdc2492
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.20.adm
@@ -0,0 +1,100 @@
+{ "o_id": 987, "c_last": "EINGATIONANTI", "o_entry_d": "2018-08-10 16:26:18", "o_ol_cnt": 15, "$1": 54756.24 }
+{ "o_id": 2170, "c_last": "BARBARESE", "o_entry_d": "2018-10-28 07:47:13", "o_ol_cnt": 15, "$1": 53243.689999999995 }
+{ "o_id": 252, "c_last": "ABLEESEOUGHT", "o_entry_d": "2019-10-19 13:56:25", "o_ol_cnt": 15, "$1": 52248.76 }
+{ "o_id": 2247, "c_last": "OUGHTCALLYPRES", "o_entry_d": "2018-02-01 12:27:47", "o_ol_cnt": 15, "$1": 51970.91 }
+{ "o_id": 2023, "c_last": "CALLYESECALLY", "o_entry_d": "2019-07-28 11:38:24", "o_ol_cnt": 14, "$1": 51428.98 }
+{ "o_id": 2860, "c_last": "EINGESEPRI", "o_entry_d": "2019-04-14 04:56:37", "o_ol_cnt": 15, "$1": 50638.65 }
+{ "o_id": 4, "c_last": "BARBARPRI", "o_entry_d": "2014-07-22 11:56:27", "o_ol_cnt": 15, "$1": 50572.16 }
+{ "o_id": 2145, "c_last": "CALLYANTIOUGHT", "o_entry_d": "2014-05-19 13:31:35", "o_ol_cnt": 15, "$1": 50495.770000000004 }
+{ "o_id": 816, "c_last": "ATIONOUGHTESE", "o_entry_d": "2019-04-28 09:25:45", "o_ol_cnt": 15, "$1": 50454.409999999996 }
+{ "o_id": 2917, "c_last": "OUGHTATIONCALLY", "o_entry_d": "2015-04-26 17:15:27", "o_ol_cnt": 13, "$1": 50432.899999999994 }
+{ "o_id": 1455, "c_last": "CALLYATIONCALLY", "o_entry_d": "2018-10-02 02:28:16", "o_ol_cnt": 15, "$1": 50297.240000000005 }
+{ "o_id": 1642, "c_last": "PRESESEPRES", "o_entry_d": "2016-07-03 20:34:12", "o_ol_cnt": 15, "$1": 50257.520000000004 }
+{ "o_id": 1173, "c_last": "BARATIONABLE", "o_entry_d": "2016-08-15 04:38:52", "o_ol_cnt": 15, "$1": 50246.530000000006 }
+{ "o_id": 2183, "c_last": "PRICALLYATION", "o_entry_d": "2016-01-04 19:02:06", "o_ol_cnt": 14, "$1": 50184.61000000001 }
+{ "o_id": 1020, "c_last": "OUGHTABLECALLY", "o_entry_d": "2014-12-01 22:51:41", "o_ol_cnt": 15, "$1": 50170.47 }
+{ "o_id": 2965, "c_last": "BAROUGHTOUGHT", "o_entry_d": "2020-04-09 20:04:41", "o_ol_cnt": 15, "$1": 49950.7 }
+{ "o_id": 828, "c_last": "ATIONABLECALLY", "o_entry_d": "2015-03-30 11:40:05", "o_ol_cnt": 14, "$1": 49923.86 }
+{ "o_id": 2762, "c_last": "CALLYOUGHTEING", "o_entry_d": "2019-04-02 18:25:58", "o_ol_cnt": 14, "$1": 49916.81999999999 }
+{ "o_id": 1421, "c_last": "EINGABLECALLY", "o_entry_d": "2014-03-09 04:01:45", "o_ol_cnt": 15, "$1": 49779.06 }
+{ "o_id": 2702, "c_last": "ESEEINGOUGHT", "o_entry_d": "2017-06-15 21:27:34", "o_ol_cnt": 15, "$1": 49760.29 }
+{ "o_id": 1603, "c_last": "ABLEBARCALLY", "o_entry_d": "2016-01-22 21:17:36", "o_ol_cnt": 14, "$1": 49751.479999999996 }
+{ "o_id": 355, "c_last": "PRIESEPRES", "o_entry_d": "2019-06-08 10:46:25", "o_ol_cnt": 15, "$1": 49735.810000000005 }
+{ "o_id": 228, "c_last": "ABLEABLECALLY", "o_entry_d": "2018-04-13 05:54:21", "o_ol_cnt": 15, "$1": 49624.43999999999 }
+{ "o_id": 1791, "c_last": "ESEOUGHTOUGHT", "o_entry_d": "2019-01-14 08:31:42", "o_ol_cnt": 15, "$1": 49582.46000000001 }
+{ "o_id": 702, "c_last": "CALLYBAROUGHT", "o_entry_d": "2017-09-25 10:32:07", "o_ol_cnt": 14, "$1": 49561.670000000006 }
+{ "o_id": 2122, "c_last": "ABLEESEESE", "o_entry_d": "2016-01-22 07:55:52", "o_ol_cnt": 14, "$1": 49330.43 }
+{ "o_id": 1795, "c_last": "OUGHTATIONPRI", "o_entry_d": "2020-02-25 14:09:25", "o_ol_cnt": 14, "$1": 49000.57 }
+{ "o_id": 2601, "c_last": "ABLEPRIATION", "o_entry_d": "2016-07-14 21:42:26", "o_ol_cnt": 15, "$1": 48999.21000000001 }
+{ "o_id": 905, "c_last": "EINGBARPRES", "o_entry_d": "2016-07-01 21:32:10", "o_ol_cnt": 15, "$1": 48948.01000000001 }
+{ "o_id": 992, "c_last": "EINGEINGOUGHT", "o_entry_d": "2015-11-11 18:21:40", "o_ol_cnt": 13, "$1": 48892.71000000001 }
+{ "o_id": 888, "c_last": "ATIONATIONCALLY", "o_entry_d": "2017-10-06 23:36:58", "o_ol_cnt": 15, "$1": 48761.340000000004 }
+{ "o_id": 1636, "c_last": "OUGHTPRESCALLY", "o_entry_d": "2016-12-15 18:43:32", "o_ol_cnt": 15, "$1": 48659.51 }
+{ "o_id": 2785, "c_last": "CALLYANTIANTI", "o_entry_d": "2014-01-30 21:31:45", "o_ol_cnt": 15, "$1": 48594.01 }
+{ "o_id": 2013, "c_last": "CALLYESEEING", "o_entry_d": "2018-10-14 18:18:02", "o_ol_cnt": 15, "$1": 48592.68 }
+{ "o_id": 2325, "c_last": "EINGEINGBAR", "o_entry_d": "2014-04-22 08:41:36", "o_ol_cnt": 15, "$1": 48536.87 }
+{ "o_id": 2846, "c_last": "EINGEINGATION", "o_entry_d": "2015-11-05 11:42:52", "o_ol_cnt": 14, "$1": 48504.63 }
+{ "o_id": 2776, "c_last": "PRESABLEEING", "o_entry_d": "2020-07-01 15:40:29", "o_ol_cnt": 15, "$1": 48379.579999999994 }
+{ "o_id": 594, "c_last": "ESEEINGPRI", "o_entry_d": "2019-05-14 19:17:48", "o_ol_cnt": 14, "$1": 48351.01 }
+{ "o_id": 718, "c_last": "CALLYOUGHTCALLY", "o_entry_d": "2014-03-29 09:13:11", "o_ol_cnt": 15, "$1": 48243.79000000001 }
+{ "o_id": 1, "c_last": "BARBARBAR", "o_entry_d": "2017-08-20 18:30:56", "o_ol_cnt": 15, "$1": 48234.6 }
+{ "o_id": 1496, "c_last": "ABLEPRIOUGHT", "o_entry_d": "2020-02-20 11:55:39", "o_ol_cnt": 15, "$1": 48222.990000000005 }
+{ "o_id": 1303, "c_last": "OUGHTABLECALLY", "o_entry_d": "2016-10-24 14:32:09", "o_ol_cnt": 15, "$1": 48187.89 }
+{ "o_id": 2138, "c_last": "ANTIPRIATION", "o_entry_d": "2019-04-16 19:00:01", "o_ol_cnt": 14, "$1": 48184.88 }
+{ "o_id": 829, "c_last": "ATIONABLEATION", "o_entry_d": "2014-11-29 00:05:53", "o_ol_cnt": 15, "$1": 48156.549999999996 }
+{ "o_id": 785, "c_last": "CALLYATIONPRES", "o_entry_d": "2020-03-01 17:28:44", "o_ol_cnt": 14, "$1": 48137.45 }
+{ "o_id": 139, "c_last": "OUGHTPRIATION", "o_entry_d": "2020-05-25 00:08:49", "o_ol_cnt": 15, "$1": 48086.32 }
+{ "o_id": 364, "c_last": "PRIANTIPRI", "o_entry_d": "2019-11-02 14:05:58", "o_ol_cnt": 14, "$1": 48062.99 }
+{ "o_id": 997, "c_last": "EINGEINGANTI", "o_entry_d": "2014-06-11 16:04:48", "o_ol_cnt": 15, "$1": 48010.05 }
+{ "o_id": 2072, "c_last": "ANTIBARCALLY", "o_entry_d": "2019-01-17 05:57:11", "o_ol_cnt": 15, "$1": 48009.25 }
+{ "o_id": 2955, "c_last": "ESEOUGHTOUGHT", "o_entry_d": "2017-12-04 17:51:51", "o_ol_cnt": 15, "$1": 47939.18 }
+{ "o_id": 2481, "c_last": "EINGESEEING", "o_entry_d": "2020-05-03 07:25:17", "o_ol_cnt": 15, "$1": 47914.9 }
+{ "o_id": 721, "c_last": "CALLYABLEBAR", "o_entry_d": "2019-05-17 03:28:06", "o_ol_cnt": 15, "$1": 47733.82000000001 }
+{ "o_id": 227, "c_last": "ABLEABLEANTI", "o_entry_d": "2016-07-24 08:54:12", "o_ol_cnt": 15, "$1": 47726.950000000004 }
+{ "o_id": 2541, "c_last": "PRESANTIPRI", "o_entry_d": "2014-06-05 20:57:48", "o_ol_cnt": 15, "$1": 47646.100000000006 }
+{ "o_id": 618, "c_last": "ANTIOUGHTCALLY", "o_entry_d": "2016-03-27 03:43:33", "o_ol_cnt": 15, "$1": 47644.45 }
+{ "o_id": 2831, "c_last": "CALLYPRIEING", "o_entry_d": "2019-07-05 21:45:15", "o_ol_cnt": 15, "$1": 47637.479999999996 }
+{ "o_id": 817, "c_last": "ATIONOUGHTANTI", "o_entry_d": "2019-11-22 02:46:24", "o_ol_cnt": 15, "$1": 47617.75000000001 }
+{ "o_id": 2951, "c_last": "ANTICALLYOUGHT", "o_entry_d": "2017-04-12 11:11:19", "o_ol_cnt": 15, "$1": 47588.09999999999 }
+{ "o_id": 1779, "c_last": "PRIANTIANTI", "o_entry_d": "2018-03-29 08:35:03", "o_ol_cnt": 15, "$1": 47569.78000000001 }
+{ "o_id": 1015, "c_last": "PRESPRIOUGHT", "o_entry_d": "2015-07-23 19:05:26", "o_ol_cnt": 15, "$1": 47556.35999999999 }
+{ "o_id": 1664, "c_last": "ESEBARPRI", "o_entry_d": "2014-01-10 05:43:45", "o_ol_cnt": 15, "$1": 47527.229999999996 }
+{ "o_id": 787, "c_last": "CALLYATIONANTI", "o_entry_d": "2017-06-10 05:18:49", "o_ol_cnt": 15, "$1": 47505.15999999999 }
+{ "o_id": 812, "c_last": "ATIONOUGHTOUGHT", "o_entry_d": "2020-01-11 16:29:17", "o_ol_cnt": 13, "$1": 47481.33 }
+{ "o_id": 828, "c_last": "ATIONABLECALLY", "o_entry_d": "2014-12-07 15:39:50", "o_ol_cnt": 15, "$1": 47332.74 }
+{ "o_id": 2722, "c_last": "CALLYBARPRI", "o_entry_d": "2020-05-22 22:06:18", "o_ol_cnt": 13, "$1": 47309.19 }
+{ "o_id": 1154, "c_last": "EINGESEPRES", "o_entry_d": "2017-07-23 02:58:56", "o_ol_cnt": 14, "$1": 47291.98 }
+{ "o_id": 905, "c_last": "EINGBARPRES", "o_entry_d": "2017-04-20 16:55:13", "o_ol_cnt": 14, "$1": 47246.81 }
+{ "o_id": 2206, "c_last": "CALLYABLEPRI", "o_entry_d": "2016-02-03 03:45:18", "o_ol_cnt": 14, "$1": 47213.64999999999 }
+{ "o_id": 1194, "c_last": "ESEBARPRI", "o_entry_d": "2016-04-30 20:28:20", "o_ol_cnt": 13, "$1": 47165.27 }
+{ "o_id": 1434, "c_last": "ANTICALLYATION", "o_entry_d": "2018-07-10 06:28:38", "o_ol_cnt": 13, "$1": 47154.28999999999 }
+{ "o_id": 343, "c_last": "PRIPRESABLE", "o_entry_d": "2018-04-19 10:55:30", "o_ol_cnt": 14, "$1": 47138.99999999999 }
+{ "o_id": 2197, "c_last": "CALLYESEBAR", "o_entry_d": "2015-03-22 01:44:13", "o_ol_cnt": 15, "$1": 47083.149999999994 }
+{ "o_id": 976, "c_last": "EINGCALLYESE", "o_entry_d": "2019-06-06 16:11:43", "o_ol_cnt": 14, "$1": 47073.64 }
+{ "o_id": 2006, "c_last": "PRESPRESCALLY", "o_entry_d": "2016-01-04 17:39:42", "o_ol_cnt": 15, "$1": 47048.340000000004 }
+{ "o_id": 2752, "c_last": "ESEOUGHTOUGHT", "o_entry_d": "2020-04-19 20:37:04", "o_ol_cnt": 15, "$1": 47037.24 }
+{ "o_id": 1748, "c_last": "ANTIEINGABLE", "o_entry_d": "2015-08-20 13:33:09", "o_ol_cnt": 15, "$1": 47014.59 }
+{ "o_id": 670, "c_last": "ANTIANTIEING", "o_entry_d": "2016-09-12 21:47:29", "o_ol_cnt": 14, "$1": 46991.53 }
+{ "o_id": 2731, "c_last": "OUGHTBARANTI", "o_entry_d": "2015-05-17 16:17:17", "o_ol_cnt": 14, "$1": 46950.670000000006 }
+{ "o_id": 2230, "c_last": "CALLYANTIESE", "o_entry_d": "2017-03-04 21:28:19", "o_ol_cnt": 15, "$1": 46940.189999999995 }
+{ "o_id": 569, "c_last": "ESEANTIATION", "o_entry_d": "2014-08-26 04:43:55", "o_ol_cnt": 15, "$1": 46938.99 }
+{ "o_id": 790, "c_last": "CALLYATIONEING", "o_entry_d": "2018-11-24 08:25:49", "o_ol_cnt": 15, "$1": 46880.39000000001 }
+{ "o_id": 93, "c_last": "BAREINGABLE", "o_entry_d": "2018-03-05 11:27:14", "o_ol_cnt": 15, "$1": 46867.79 }
+{ "o_id": 459, "c_last": "PRESESEATION", "o_entry_d": "2016-05-14 14:30:38", "o_ol_cnt": 15, "$1": 46751.61999999999 }
+{ "o_id": 2393, "c_last": "ABLEABLEPRI", "o_entry_d": "2018-05-29 01:41:01", "o_ol_cnt": 15, "$1": 46694.47000000001 }
+{ "o_id": 1067, "c_last": "ATIONEINGPRI", "o_entry_d": "2015-09-03 21:40:47", "o_ol_cnt": 15, "$1": 46688.899999999994 }
+{ "o_id": 432, "c_last": "PRESPRIOUGHT", "o_entry_d": "2015-01-03 03:45:52", "o_ol_cnt": 15, "$1": 46672.87 }
+{ "o_id": 1217, "c_last": "BARESEEING", "o_entry_d": "2018-05-22 14:34:52", "o_ol_cnt": 15, "$1": 46637.03 }
+{ "o_id": 967, "c_last": "EINGANTIANTI", "o_entry_d": "2020-05-17 00:28:25", "o_ol_cnt": 14, "$1": 46631.29 }
+{ "o_id": 1230, "c_last": "ESEOUGHTOUGHT", "o_entry_d": "2016-03-06 01:20:17", "o_ol_cnt": 15, "$1": 46608.61 }
+{ "o_id": 2321, "c_last": "EINGEINGOUGHT", "o_entry_d": "2016-08-14 22:39:41", "o_ol_cnt": 15, "$1": 46597.030000000006 }
+{ "o_id": 2764, "c_last": "ATIONANTIPRI", "o_entry_d": "2017-03-28 12:19:02", "o_ol_cnt": 15, "$1": 46595.299999999996 }
+{ "o_id": 1736, "c_last": "ESEOUGHTOUGHT", "o_entry_d": "2017-02-04 13:12:22", "o_ol_cnt": 14, "$1": 46575.62000000001 }
+{ "o_id": 1047, "c_last": "EINGABLECALLY", "o_entry_d": "2017-04-29 15:46:06", "o_ol_cnt": 15, "$1": 46552.15999999999 }
+{ "o_id": 590, "c_last": "ESEATIONEING", "o_entry_d": "2019-04-06 00:07:24", "o_ol_cnt": 14, "$1": 46458.59 }
+{ "o_id": 225, "c_last": "ABLEABLEPRES", "o_entry_d": "2016-04-01 15:58:38", "o_ol_cnt": 15, "$1": 46454.119999999995 }
+{ "o_id": 2501, "c_last": "EINGESEOUGHT", "o_entry_d": "2015-09-03 16:25:09", "o_ol_cnt": 13, "$1": 46447.860000000015 }
+{ "o_id": 2531, "c_last": "BAROUGHTEING", "o_entry_d": "2014-11-25 19:54:25", "o_ol_cnt": 14, "$1": 46433.27999999999 }
+{ "o_id": 2259, "c_last": "PRESPRESESE", "o_entry_d": "2014-03-21 17:53:05", "o_ol_cnt": 14, "$1": 46429.5 }
+{ "o_id": 2279, "c_last": "OUGHTABLEESE", "o_entry_d": "2015-09-13 03:16:49", "o_ol_cnt": 14, "$1": 46404.54 }
+{ "o_id": 2819, "c_last": "OUGHTESEEING", "o_entry_d": "2015-03-06 02:40:31", "o_ol_cnt": 15, "$1": 46297.08 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.21.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.21.adm
new file mode 100644
index 0000000..b8a0dd8
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.21.adm
@@ -0,0 +1 @@
+{ "revenue": null }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.22.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.22.adm
new file mode 100644
index 0000000..3972a66
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.22.adm
@@ -0,0 +1 @@
+{ "su_name": "Supplier#000002383", "su_address": "ekqzetogqwsvnprsztsdysdz" }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.23.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.23.adm
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.23.adm
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.24.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.24.adm
new file mode 100644
index 0000000..8e19829
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.24.adm
@@ -0,0 +1,26 @@
+{ "country": "a", "numcust": 284, "totacctbal": 2.2662714791100006E9 }
+{ "country": "b", "numcust": 273, "totacctbal": 2.15204810873E9 }
+{ "country": "c", "numcust": 280, "totacctbal": 2.19901477654E9 }
+{ "country": "d", "numcust": 281, "totacctbal": 2.2295085611300006E9 }
+{ "country": "e", "numcust": 266, "totacctbal": 2.0898248573100004E9 }
+{ "country": "f", "numcust": 291, "totacctbal": 2.28895186263E9 }
+{ "country": "g", "numcust": 273, "totacctbal": 2.1751626313600006E9 }
+{ "country": "h", "numcust": 270, "totacctbal": 2.123874263980001E9 }
+{ "country": "i", "numcust": 314, "totacctbal": 2.5062579637700005E9 }
+{ "country": "j", "numcust": 272, "totacctbal": 2.1187015880100012E9 }
+{ "country": "k", "numcust": 262, "totacctbal": 2.0813587663100002E9 }
+{ "country": "l", "numcust": 309, "totacctbal": 2.450203296830001E9 }
+{ "country": "m", "numcust": 284, "totacctbal": 2.2022141295700006E9 }
+{ "country": "n", "numcust": 291, "totacctbal": 2.3207543341700006E9 }
+{ "country": "o", "numcust": 251, "totacctbal": 1.9998843986900005E9 }
+{ "country": "p", "numcust": 280, "totacctbal": 2.2331558207200007E9 }
+{ "country": "q", "numcust": 283, "totacctbal": 2.238249795950001E9 }
+{ "country": "r", "numcust": 301, "totacctbal": 2.3495850603400006E9 }
+{ "country": "s", "numcust": 295, "totacctbal": 2.3463836531400013E9 }
+{ "country": "t", "numcust": 301, "totacctbal": 2.3482144823500004E9 }
+{ "country": "u", "numcust": 287, "totacctbal": 2.2600798422600007E9 }
+{ "country": "v", "numcust": 302, "totacctbal": 2.3417551067600007E9 }
+{ "country": "w", "numcust": 279, "totacctbal": 2.216788361700001E9 }
+{ "country": "x", "numcust": 255, "totacctbal": 2.0362774238800004E9 }
+{ "country": "y", "numcust": 277, "totacctbal": 2.1461449209500005E9 }
+{ "country": "z", "numcust": 278, "totacctbal": 2.212398170400001E9 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.3.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.3.adm
new file mode 100644
index 0000000..d9ce783
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.3.adm
@@ -0,0 +1,15 @@
+{ "avg_qty": 25.550356306373647, "avg_amount": 494.32922758758156, "COUNT_order": 20067, "ol_number": 0, "sum_qty": 512719, "sum_amount": 9919704.61 }
+{ "avg_qty": 25.416147209893783, "avg_amount": 498.70511943350124, "COUNT_order": 20053, "ol_number": 1, "sum_qty": 509670, "sum_amount": 1.000053376E7 }
+{ "avg_qty": 25.562154076290202, "avg_amount": 496.7387574171028, "COUNT_order": 20055, "ol_number": 2, "sum_qty": 512649, "sum_amount": 9962095.779999997 }
+{ "avg_qty": 25.584070354269723, "avg_amount": 504.99520661569983, "COUNT_order": 20013, "ol_number": 3, "sum_qty": 512014, "sum_amount": 1.010646907E7 }
+{ "avg_qty": 25.512225548902194, "avg_amount": 499.89355439121755, "COUNT_order": 20040, "ol_number": 4, "sum_qty": 511265, "sum_amount": 1.001786683E7 }
+{ "avg_qty": 25.487558107738582, "avg_amount": 497.55933552091875, "COUNT_order": 18285, "ol_number": 5, "sum_qty": 466040, "sum_amount": 9097872.45 }
+{ "avg_qty": 25.646245661043785, "avg_amount": 505.4765994762804, "COUNT_order": 16421, "ol_number": 6, "sum_qty": 421137, "sum_amount": 8300431.24 }
+{ "avg_qty": 25.459164031348823, "avg_amount": 496.40666231266323, "COUNT_order": 14546, "ol_number": 7, "sum_qty": 370329, "sum_amount": 7220731.31 }
+{ "avg_qty": 25.257673540059816, "avg_amount": 499.69933968204, "COUNT_order": 12706, "ol_number": 8, "sum_qty": 320924, "sum_amount": 6349179.81 }
+{ "avg_qty": 25.40641907381935, "avg_amount": 500.69681613938553, "COUNT_order": 10905, "ol_number": 9, "sum_qty": 277057, "sum_amount": 5460098.779999999 }
+{ "avg_qty": 25.759796887073627, "avg_amount": 517.3336405784303, "COUNT_order": 9059, "ol_number": 10, "sum_qty": 233358, "sum_amount": 4686525.45 }
+{ "avg_qty": 25.982667775929006, "avg_amount": 492.8491528008874, "COUNT_order": 7212, "ol_number": 11, "sum_qty": 187387, "sum_amount": 3554428.09 }
+{ "avg_qty": 25.41370937616735, "avg_amount": 509.99584422861403, "COUNT_order": 5354, "ol_number": 12, "sum_qty": 136065, "sum_amount": 2730517.7499999995 }
+{ "avg_qty": 25.27172374752335, "avg_amount": 533.910868949901, "COUNT_order": 3533, "ol_number": 13, "sum_qty": 89285, "sum_amount": 1886307.1 }
+{ "avg_qty": 25.81267846944603, "avg_amount": 521.5469274700171, "COUNT_order": 1751, "ol_number": 14, "sum_qty": 45198, "sum_amount": 913228.6699999999 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.4.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.4.adm
new file mode 100644
index 0000000..eb8f791
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.4.adm
@@ -0,0 +1,100 @@
+{ "su_suppkey": 38, "i_id": 38, "su_name": "Supplier#000000038", "n_name": "Belgium", "i_name": "loqafmmyuupoiadclmmdhakg", "su_address": "nniwrmzmvnqxvjrunkojd", "su_phone": "8110681159238044", "su_comment": "kHJjr7sPN45UE2WNMzD8rffet2kYHbLko" }
+{ "su_suppkey": 58, "i_id": 60058, "su_name": "Supplier#000000058", "n_name": "Belgium", "i_name": "fstoablfptpylrbttsapnl", "su_address": "wiftxzfrywbshwpyrbjwattqlgr", "su_phone": "1889485472303856", "su_comment": "W8e3SHFSyVOGG2HXnCNFnQnrFU6nI75zlZjXOUePg2hyxX9Ab4C1kKrfwY90uXvhm9KAbIZhcn2EkAeAuY8NNab0vgUk4FkDv" }
+{ "su_suppkey": 115, "i_id": 70115, "su_name": "Supplier#000000115", "n_name": "Belgium", "i_name": "iisbdrpktiivcglgnf", "su_address": "qalwoieptqlr", "su_phone": "5633388291591980", "su_comment": "mZKolzjT486hSWDL2T8kzA9xJKpx1OoutfnwdcICPUBKwi8tJdpTxLOt17QvWdHemLqzjOuy2RZ6IiolJyuhjPRmgI" }
+{ "su_suppkey": 269, "i_id": 50269, "su_name": "Supplier#000000269", "n_name": "Belgium", "i_name": "ghwfrtibxbxpwbbf", "su_address": "nbvxscwmzgqiuypjfsdd", "su_phone": "6556831834242725", "su_comment": "DyqIsszonee7JdrB4NUXviLl1Ax5KyJR65O4UI1XYJabA4FQFwwMXKjCBW" }
+{ "su_suppkey": 298, "i_id": 80298, "su_name": "Supplier#000000298", "n_name": "Belgium", "i_name": "capsundwgympuir", "su_address": "hkhfgjjcelm", "su_phone": "1924251873456621", "su_comment": "UxfpFNqHuhS8eaD5SHhRyF2GGU59cSyzZ5YiKAgpEmPpRu0M2a7bLDGnhl" }
+{ "su_suppkey": 366, "i_id": 40366, "su_name": "Supplier#000000366", "n_name": "Belgium", "i_name": "qyxarwkkylotwsjcqkxzjut", "su_address": "gnbombhmdmcohvrjitzgvi", "su_phone": "7993089906577486", "su_comment": "9Ldu7mumrHiUFTd53Sao4J4JG5NX0WVEpAeIPEyI44XKrpNR52T" }
+{ "su_suppkey": 366, "i_id": 60366, "su_name": "Supplier#000000366", "n_name": "Belgium", "i_name": "xwtymhjhceachsig", "su_address": "gnbombhmdmcohvrjitzgvi", "su_phone": "7993089906577486", "su_comment": "9Ldu7mumrHiUFTd53Sao4J4JG5NX0WVEpAeIPEyI44XKrpNR52T" }
+{ "su_suppkey": 509, "i_id": 70509, "su_name": "Supplier#000000509", "n_name": "Belgium", "i_name": "vksnibblrfpaxnczw", "su_address": "xhyzwatvrrnge", "su_phone": "4654633658081208", "su_comment": "okw2ngAHHYHplYgsauJrRf5oTLl5D2JRnjImVWTBfrEVHHjgqtrQSAMVt1sF0G9jBgPQyRoBCkDDmmnhza8ANzdWfDTC7h" }
+{ "su_suppkey": 551, "i_id": 551, "su_name": "Supplier#000000551", "n_name": "Belgium", "i_name": "uehhklfuywnpxvga", "su_address": "asqjhvsgixtbvwwbxdbtwgovugbjaad", "su_phone": "9217346889481655", "su_comment": "9gTJjY5ofeMIJiJeWIuVtsLxTKaZ0hAzmyWZKU151ISvDOkDSgF9e9BCQXym8mRERDfGk8Le7WEM" }
+{ "su_suppkey": 588, "i_id": 50588, "su_name": "Supplier#000000588", "n_name": "Belgium", "i_name": "fpjrhbhwigotzmlb", "su_address": "hhjlcxmzdtpiucqdwwysigmpwklhjscvlxwoxeot", "su_phone": "1679126091596002", "su_comment": "zUnd3Dazz2g0N04xOGmkrTlwCDHvrom0OOMPJ1VimwhCV7jK5m6LGmmzQ6ACGGILT0Q5YdrHhRWPOGRs2x2d2NuEFKe" }
+{ "su_suppkey": 1362, "i_id": 1362, "su_name": "Supplier#000001362", "n_name": "Belgium", "i_name": "emldnbzmicyegmigmi", "su_address": "vqluraazcinzwwqetixcxyajctnpxdb", "su_phone": "4562577335242360", "su_comment": "J8lWu5eIQeY4OzKyLVfn0Xs4Q1wUCc0DuPIFMkosetwtmQncM2773Rcai6gXWszbMiGXALoZ" }
+{ "su_suppkey": 1373, "i_id": 41373, "su_name": "Supplier#000001373", "n_name": "Belgium", "i_name": "kjlpkgrsyzdxktwqbuwmveu", "su_address": "xxzqqdsrpqcyycncudm", "su_phone": "0841049970537255", "su_comment": "NqE2Y1lvPTAKiTR50Yuh9MRWpwn1zwMRKTJce4QojsEbEHMwz1jtGrUNHn0IF4EDFHQOayl97faaHr1" }
+{ "su_suppkey": 1416, "i_id": 11416, "su_name": "Supplier#000001416", "n_name": "Belgium", "i_name": "yjvteoynykctakkr", "su_address": "uevklasteyvpfzadudiahfszexxsdvjhvo", "su_phone": "7949037840349441", "su_comment": "RkF0CD696rVzurDphxgIKRTljg" }
+{ "su_suppkey": 1562, "i_id": 51562, "su_name": "Supplier#000001562", "n_name": "Belgium", "i_name": "qpzajrwpotmgtbk", "su_address": "bgkgkjmuinwrvergrjjszidxzmpzl", "su_phone": "7238731099751680", "su_comment": "VUYwWueTvV2YXXUgAb0NQf3ITZhws1lp1AXvy7tjxmflQNjKnwp08Iwwc4POQzb50G24ihujs5wNT9NG0VnM1rzMj" }
+{ "su_suppkey": 1626, "i_id": 81626, "su_name": "Supplier#000001626", "n_name": "Belgium", "i_name": "bvnnpzylichikjytulcbd", "su_address": "hsgbmhlbmiwvgzbhvdvfvpqvjthahjx", "su_phone": "5818204596789800", "su_comment": "wXUW6v2ddZMyYFDxGiio2U0Jw08zE2GBZKLyuIpvUv6NkRK" }
+{ "su_suppkey": 1859, "i_id": 51859, "su_name": "Supplier#000001859", "n_name": "Belgium", "i_name": "aycaalpdocywcvtcoznix", "su_address": "yybnrkhxgjqebuyk", "su_phone": "1563040022667159", "su_comment": "UquenbErfasbJYbaQ2KacP33y3hVvrGLH5TbP5k3ra1lbUA9NHjkj6KyXj5b" }
+{ "su_suppkey": 1862, "i_id": 11862, "su_name": "Supplier#000001862", "n_name": "Belgium", "i_name": "swwjcgjbtbyghm", "su_address": "pyketmtzmiqfbyyrzhtxfcysazsdnxffdopx", "su_phone": "6463438966724237", "su_comment": "qQy7dM0Vq3zNTPFI978P2LZuGgs1ns67MimWUr98KuZuE" }
+{ "su_suppkey": 1862, "i_id": 91862, "su_name": "Supplier#000001862", "n_name": "Belgium", "i_name": "jwcfymfpksuudiqi", "su_address": "pyketmtzmiqfbyyrzhtxfcysazsdnxffdopx", "su_phone": "6463438966724237", "su_comment": "qQy7dM0Vq3zNTPFI978P2LZuGgs1ns67MimWUr98KuZuE" }
+{ "su_suppkey": 1868, "i_id": 51868, "su_name": "Supplier#000001868", "n_name": "Belgium", "i_name": "asafpeloqhaoezdhkryy", "su_address": "bfbcphxnqfuyslabddjr", "su_phone": "4501789571549130", "su_comment": "FDrIVU9hbLry6bP2vMFA36X3SS7g" }
+{ "su_suppkey": 2049, "i_id": 82049, "su_name": "Supplier#000002049", "n_name": "Belgium", "i_name": "qppcokwkblskiewuqq", "su_address": "dacvajpfjidmjmjaleohojmvac", "su_phone": "0920437329367033", "su_comment": "rIbYE9coEooJQ4Y0X9gkIXcwAeg0VOELObqK0OrrPo6GulaJ8rngJZWptRnx0" }
+{ "su_suppkey": 2536, "i_id": 32536, "su_name": "Supplier#000002536", "n_name": "Belgium", "i_name": "zasuxutvjrjpjq", "su_address": "cqghpskjcsgwdzjia", "su_phone": "3428560065666390", "su_comment": "N0xjrZZTIo9KKPk3AaxATztcpQ7s1u69GgMXqEFiKY9rXWZv67NmNBSKNmjATM4Vv" }
+{ "su_suppkey": 2851, "i_id": 42851, "su_name": "Supplier#000002851", "n_name": "Belgium", "i_name": "eefqhuodgbuiaolkak", "su_address": "trenknsunggonqcbxsvvpgutbpllysiu", "su_phone": "3126153397367209", "su_comment": "SLD0SqeU01h5eEP7jbyyWkiK3PmS0SxFdv39rdDZf6wELyoSW57LPqrUo3yx6bpTRkk8SDrRN3a" }
+{ "su_suppkey": 2851, "i_id": 52851, "su_name": "Supplier#000002851", "n_name": "Belgium", "i_name": "qeqznqunkwccdnir", "su_address": "trenknsunggonqcbxsvvpgutbpllysiu", "su_phone": "3126153397367209", "su_comment": "SLD0SqeU01h5eEP7jbyyWkiK3PmS0SxFdv39rdDZf6wELyoSW57LPqrUo3yx6bpTRkk8SDrRN3a" }
+{ "su_suppkey": 2851, "i_id": 62851, "su_name": "Supplier#000002851", "n_name": "Belgium", "i_name": "vuprtojagssmnmhprvfeukc", "su_address": "trenknsunggonqcbxsvvpgutbpllysiu", "su_phone": "3126153397367209", "su_comment": "SLD0SqeU01h5eEP7jbyyWkiK3PmS0SxFdv39rdDZf6wELyoSW57LPqrUo3yx6bpTRkk8SDrRN3a" }
+{ "su_suppkey": 3504, "i_id": 33504, "su_name": "Supplier#000003504", "n_name": "Belgium", "i_name": "qttjfnbgjaerpbjarbtlymtr", "su_address": "ojdbgtozeijaojnqxjvjdoyirnnspuiiyrimssun", "su_phone": "9717182698764956", "su_comment": "zrI9mznIQvAkDI0O6lrfajFIqNR1Fydf9rNLKAHLNr0cRhDgFzdNL05AS1VbsytSon9WAOEyMeyvnpSb06lBp" }
+{ "su_suppkey": 3504, "i_id": 53504, "su_name": "Supplier#000003504", "n_name": "Belgium", "i_name": "ihupnltvrvfbafoiuyaves", "su_address": "ojdbgtozeijaojnqxjvjdoyirnnspuiiyrimssun", "su_phone": "9717182698764956", "su_comment": "zrI9mznIQvAkDI0O6lrfajFIqNR1Fydf9rNLKAHLNr0cRhDgFzdNL05AS1VbsytSon9WAOEyMeyvnpSb06lBp" }
+{ "su_suppkey": 3708, "i_id": 33708, "su_name": "Supplier#000003708", "n_name": "Belgium", "i_name": "efkhxvkqzopqrksohf", "su_address": "xubsetoqhqqjhlhbbbqwxqcelsmzhuvjakygecxe", "su_phone": "1323645182238533", "su_comment": "dNqHjdLM2UK384BngN1coKpK95dq4FG7Oo1Nka5mHWLQong68V5Kof8oC3OL5YVgdSR1Fpru6" }
+{ "su_suppkey": 4131, "i_id": 74131, "su_name": "Supplier#000004131", "n_name": "Belgium", "i_name": "nvutvddkpttckhakdr", "su_address": "debsnmtwpbkqcuqartpfbbkf", "su_phone": "7624467086286782", "su_comment": "fR9yR9S7BejHmIoAoizgEXQz5Z2JHaqHe4U2VyfdQURmxBdxdX2qG8NNmQq2V0c0d4J09sqQ7jRUpZUmciQxcwm" }
+{ "su_suppkey": 4148, "i_id": 74148, "su_name": "Supplier#000004148", "n_name": "Belgium", "i_name": "wdxcnxvyjammbqrtwwd", "su_address": "qyyqnfznyaaohlzftvmwikdohqyx", "su_phone": "2073904689361309", "su_comment": "P6kVjiTj2qEsd6nFbFFgUD9FD2T9hBI5WzdayreFOmSP42hQPMpFnRNYVeW8Nvof7ogt7NPeogU6006FWdCrvOzdkGo3nbOLM1" }
+{ "su_suppkey": 4291, "i_id": 64291, "su_name": "Supplier#000004291", "n_name": "Belgium", "i_name": "xycvxhudmzujynlctap", "su_address": "wfllkfkuseia", "su_phone": "0289472645384373", "su_comment": "gJk0ijSRWgIsYb5OxHjXVZgcvZ93oG1nzL5NM8yOlSzSCFWOLx" }
+{ "su_suppkey": 4306, "i_id": 64306, "su_name": "Supplier#000004306", "n_name": "Belgium", "i_name": "eplpbljmgziofbcwrv", "su_address": "apmirfowloparpdchieusknvypeyajq", "su_phone": "0038720206627873", "su_comment": "kD7QQjKjN0s4RjMJGkIb5BSHBK88ZuZHLzFCua" }
+{ "su_suppkey": 4355, "i_id": 74355, "su_name": "Supplier#000004355", "n_name": "Belgium", "i_name": "smymwwlylorvse", "su_address": "apechnyzmnctxdophzecsjhljxcu", "su_phone": "0878734110726220", "su_comment": "rqRanBOm3XAZ6EhgBiV0yZUG7KBvoHKTC2h" }
+{ "su_suppkey": 4543, "i_id": 24543, "su_name": "Supplier#000004543", "n_name": "Belgium", "i_name": "xvrhwbfukzlbbvjzcizzj", "su_address": "uhpxxdwvmkyvligodczhgbxjxhmdokfd", "su_phone": "2792234233112732", "su_comment": "UdMbnFHrJfpx9rxyDXxPCsgn5px2douBATCyzxtsK7Bbl7u5D3OT3BaZaTNPtgPMdHYFbVzul6" }
+{ "su_suppkey": 4955, "i_id": 84955, "su_name": "Supplier#000004955", "n_name": "Belgium", "i_name": "cwlcqdniqfhoild", "su_address": "foyxpdabvfcyvrsyjhijijvxnshcbsbp", "su_phone": "2711110412745062", "su_comment": "zXFgJZrlmgGqRHKp1RUgpKs6JHqZPDuvjf5cbUfrCKQ7quUrZ9E" }
+{ "su_suppkey": 4981, "i_id": 64981, "su_name": "Supplier#000004981", "n_name": "Belgium", "i_name": "bctijqyctzcepbpnak", "su_address": "kltugzxdzhobxle", "su_phone": "6551131900980141", "su_comment": "vXgdiP2YG24h08OdP6QuAyyj6fEPJZkd70lvGFmf2JsBPoudM6pQeBZJI9BeUOemwB" }
+{ "su_suppkey": 4981, "i_id": 84981, "su_name": "Supplier#000004981", "n_name": "Belgium", "i_name": "oczlfadgxfjnifbqxcp", "su_address": "kltugzxdzhobxle", "su_phone": "6551131900980141", "su_comment": "vXgdiP2YG24h08OdP6QuAyyj6fEPJZkd70lvGFmf2JsBPoudM6pQeBZJI9BeUOemwB" }
+{ "su_suppkey": 5026, "i_id": 55026, "su_name": "Supplier#000005026", "n_name": "Belgium", "i_name": "yqcxcodazjinufbnbkvi", "su_address": "ogrtwldcrryhtbnjtczpaydsx", "su_phone": "3690407677313626", "su_comment": "1bC3if6XWn6U1KLbEjcQXlKCWu5QLgYxafZ2rCR0u8MdyYpnRFAyvLPz7yAwJBiywG3LpMv" }
+{ "su_suppkey": 5829, "i_id": 15829, "su_name": "Supplier#000005829", "n_name": "Belgium", "i_name": "oatvhatnlbtpszkx", "su_address": "cioatshxtsqmmibbbskwwpuimdwbfhrjvu", "su_phone": "8750410808077788", "su_comment": "4RDHfk3Rsfttnn1P8fK9ZGgNkLsJAOnJC692IBNKqLwEsK3inFyg3S8039NY9bdba3QNbj1WN2Aq5ANm" }
+{ "su_suppkey": 6216, "i_id": 96216, "su_name": "Supplier#000006216", "n_name": "Belgium", "i_name": "sxiutllncypixb", "su_address": "rqvnflbdpvwctbnvsoykrvmessvabzsfjymhgwg", "su_phone": "1536628983958080", "su_comment": "bwc5uMhIXUbCoHIktv1GLBQB8JHiK5qqpYBHgP8Dwcb" }
+{ "su_suppkey": 6261, "i_id": 76261, "su_name": "Supplier#000006261", "n_name": "Belgium", "i_name": "dpdjnbsnmaawsfjpdsolq", "su_address": "yphvtqxemfgrenvjjubjpcpgftvpevubjxdmevd", "su_phone": "9020594284082930", "su_comment": "XPNk4IdGtJAoBM32cGZn4nQtQyA2ZRjQ4ur3KlM175yHB2Z" }
+{ "su_suppkey": 6555, "i_id": 86555, "su_name": "Supplier#000006555", "n_name": "Belgium", "i_name": "wwowcnhbaxjaxdnpugq", "su_address": "hicfuatnyhkgnzbcdeflqxqlxdkszp", "su_phone": "6581159030485934", "su_comment": "qhVYqDMIGjbPPcrZnVbQynSJObtuF91yFnUzuN2HQuHscWVgaEw" }
+{ "su_suppkey": 6593, "i_id": 76593, "su_name": "Supplier#000006593", "n_name": "Belgium", "i_name": "lzazocefgflyxytvfnsovssl", "su_address": "phsnnhzwrpejoeftoxnygatteemzqiikryqmhf", "su_phone": "4097428795395357", "su_comment": "DHeTCrjKKf2oJtL3T2SyPE5bw88ImEAbcWulk1UifO8jzsjMRRPoGkGWBVDOuDh2HhZl" }
+{ "su_suppkey": 6688, "i_id": 6688, "su_name": "Supplier#000006688", "n_name": "Belgium", "i_name": "eddzuzuskbqmhvavbxyqxhs", "su_address": "cxcatycudjseqzgghkyq", "su_phone": "3122976231020682", "su_comment": "F1FlXhIkNTRthCMryOPtzootqe3VxTxYYKQP7992hosZIyjH" }
+{ "su_suppkey": 6688, "i_id": 76688, "su_name": "Supplier#000006688", "n_name": "Belgium", "i_name": "sgomzoqmvmemgfhgebvuano", "su_address": "cxcatycudjseqzgghkyq", "su_phone": "3122976231020682", "su_comment": "F1FlXhIkNTRthCMryOPtzootqe3VxTxYYKQP7992hosZIyjH" }
+{ "su_suppkey": 7720, "i_id": 67720, "su_name": "Supplier#000007720", "n_name": "Belgium", "i_name": "mmlblhnoetyjllpemta", "su_address": "sskijyfbltihheeauydzzuqvm", "su_phone": "8220603510140602", "su_comment": "n2FM1FpzBKqUQO7g57dbfEXrTbN3G" }
+{ "su_suppkey": 7836, "i_id": 77836, "su_name": "Supplier#000007836", "n_name": "Belgium", "i_name": "ubnppwtpceadaebzmboa", "su_address": "dzybzildbblmmbn", "su_phone": "1283696223272711", "su_comment": "1w3QBvatllzL2BNSc8ZPRJOAjTEGX1qnRh2XAiyJ5Uu7t" }
+{ "su_suppkey": 7924, "i_id": 87924, "su_name": "Supplier#000007924", "n_name": "Belgium", "i_name": "kjvlegbqiwahdpvegup", "su_address": "rbskspxuqvfhsawqswnyaenbhwfkudrek", "su_phone": "4116059239483382", "su_comment": "mNzQYM89ig7u2G8Z6PaNbtmt6XAxUAWVLDKvflYRy7p7mCibmeLZpZuASUqP1FTOPJ5l4eMsHvj7BNxJGPsV" }
+{ "su_suppkey": 8156, "i_id": 58156, "su_name": "Supplier#000008156", "n_name": "Belgium", "i_name": "zaeywhkmiljqootbluvh", "su_address": "xqirdvyvlukrzkteryzmpmeexhcyxojsht", "su_phone": "1910335113335999", "su_comment": "I8LTL3A4Cog3Kh0wSGXX12zkzZnq5evE5ROiRIJ8e3hjp9LcXoFTwABmHr2YrLQHX2U2Pjls8zSvtps3wWpjp" }
+{ "su_suppkey": 8260, "i_id": 8260, "su_name": "Supplier#000008260", "n_name": "Belgium", "i_name": "argyliwpfkmdba", "su_address": "qdyuyjpdzzrgfstrvipbqaapsluanmm", "su_phone": "6096364703369590", "su_comment": "OOxVCEU2X3M5I9HSyWecbeshCaG0wolVIMtYoAV" }
+{ "su_suppkey": 8430, "i_id": 68430, "su_name": "Supplier#000008430", "n_name": "Belgium", "i_name": "nvpxnkcqqtlklecozhddezwj", "su_address": "nffqqtkaxpzlkvynwxzvzsfgezrghnxmpdcpxb", "su_phone": "1156931936202578", "su_comment": "gB2cd2MIoAMqZNnR0Sqi7kzovPikGsne7QO0dahTOImhErGezQ2" }
+{ "su_suppkey": 8466, "i_id": 28466, "su_name": "Supplier#000008466", "n_name": "Belgium", "i_name": "jxpibgsizhujpy", "su_address": "qriaxafthqsfpgxtdgrzbjfifruwtsprog", "su_phone": "8366735306271372", "su_comment": "5yY2TibTgPRoXke9hX3rIemFWvFCJKQPEbJ6rqQOBZ9nmu0XtMNkV5s7hknWJ" }
+{ "su_suppkey": 8466, "i_id": 48466, "su_name": "Supplier#000008466", "n_name": "Belgium", "i_name": "cqxqkhwbfcjrzyvkzmhhnb", "su_address": "qriaxafthqsfpgxtdgrzbjfifruwtsprog", "su_phone": "8366735306271372", "su_comment": "5yY2TibTgPRoXke9hX3rIemFWvFCJKQPEbJ6rqQOBZ9nmu0XtMNkV5s7hknWJ" }
+{ "su_suppkey": 8471, "i_id": 28471, "su_name": "Supplier#000008471", "n_name": "Belgium", "i_name": "zewuhblwzpwbxl", "su_address": "dbcgpzyuusapebwb", "su_phone": "7531953469662938", "su_comment": "gVyxlW3MuCUztFWPxk20ydohRNiifwBec" }
+{ "su_suppkey": 8638, "i_id": 28638, "su_name": "Supplier#000008638", "n_name": "Belgium", "i_name": "mhjvdlvsnxjozgmsizl", "su_address": "qffoopjqxwioggeetuyssvxxwtlttcleb", "su_phone": "7591505287111100", "su_comment": "9PKeisDW4DgbrSwA0RsT76C6a6aOEXZg0T81qT6FqWVQVJWPVjUikVzWbwrnFWWNWmN" }
+{ "su_suppkey": 9286, "i_id": 39286, "su_name": "Supplier#000009286", "n_name": "Belgium", "i_name": "zenouydxiumhawqb", "su_address": "rqvehajiuqzqoficxrrgbnupceyphqqyecm", "su_phone": "0476178654570575", "su_comment": "h1zcmkP4EMLhInQXKAF2bl4V6qxYynkwYjWKZyRfrx9ROrnKZZwTEzKgAOs1ddDm2TnZF3e2NYXTduqWtATl2Wr75I4Ri" }
+{ "su_suppkey": 9286, "i_id": 89286, "su_name": "Supplier#000009286", "n_name": "Belgium", "i_name": "mumykzaryiytsniwpldf", "su_address": "rqvehajiuqzqoficxrrgbnupceyphqqyecm", "su_phone": "0476178654570575", "su_comment": "h1zcmkP4EMLhInQXKAF2bl4V6qxYynkwYjWKZyRfrx9ROrnKZZwTEzKgAOs1ddDm2TnZF3e2NYXTduqWtATl2Wr75I4Ri" }
+{ "su_suppkey": 9418, "i_id": 79418, "su_name": "Supplier#000009418", "n_name": "Belgium", "i_name": "tlplkjpmmacieqdu", "su_address": "welyvqrphnjtkgfzutmvnbpngjqmzurkqpcv", "su_phone": "6285087572945876", "su_comment": "zF731zWQN1dxtEzDGk4RXArqpObGYBu59zG3V2gaF6aFO3uM3BxCc5DqDU27UNzYoTgyvGoyKk1" }
+{ "su_suppkey": 9531, "i_id": 19531, "su_name": "Supplier#000009531", "n_name": "Belgium", "i_name": "qnyelhvatbgofila", "su_address": "nhvyffyifontxukjra", "su_phone": "4704861606182249", "su_comment": "yF8F3EC425wBnwwDlPaO6wo7BTBbiVXQVvE4YNNSfViiVAacr465rI1xHEp" }
+{ "su_suppkey": 9744, "i_id": 99744, "su_name": "Supplier#000009744", "n_name": "Belgium", "i_name": "qgjkdssndikvjaz", "su_address": "xrohyxzvwozvtalyzwvwvvavtniwfp", "su_phone": "6212284110379269", "su_comment": "XPFbxgmyBUe2fOMGq4RTaI5CktLpHl6j8BtzNaorPBoRfQcZoKhUwXMRotanGvAxabmxRO4VeEd0M9C" }
+{ "su_suppkey": 9846, "i_id": 99846, "su_name": "Supplier#000009846", "n_name": "Belgium", "i_name": "urfjicocrfvlcilu", "su_address": "lxyqkskraujyvh", "su_phone": "9446663439679621", "su_comment": "yAC8QodEA6xh4i5CMH7rHejVz5lD3iWIGz0c1zjK0w8VKhlV7zPacuq6FFU1R63raE549pPIQs4GlgiqA4Tu0mg1BfwT4EOM8y" }
+{ "su_suppkey": 9940, "i_id": 79940, "su_name": "Supplier#000009940", "n_name": "Belgium", "i_name": "jfxbleletulioqsnkasb", "su_address": "hppjuiwiqdze", "su_phone": "6195077997954524", "su_comment": "Ig3rxreBKsoZIgvyMmm3e9sqFLXKsmtynX69xBxu8SAXbcdy982" }
+{ "su_suppkey": 9947, "i_id": 29947, "su_name": "Supplier#000009947", "n_name": "Belgium", "i_name": "ecuyfclcctdhhujnj", "su_address": "xuatcqdgufxdtokqfcvbtjdaxnxclxrxgm", "su_phone": "7227873663726760", "su_comment": "95BiM63SdBmogE6uAsDSYQZyfvvzieoRwXmF4DLxTXaC3PW05xeiNxJVY0IugBug0zwS6z0M82HHCAtjDgIU98EejNE" }
+{ "su_suppkey": 456, "i_id": 60456, "su_name": "Supplier#000000456", "n_name": "Finland", "i_name": "lhnepnhvtzcjjudjxqtebsh", "su_address": "mqocnuxnmrbzuomiimjodcuqttrydta", "su_phone": "0845626029655670", "su_comment": "GMDgWXRkfkI8Zta8lTrbQNi1uCr0qqxLogEPUr28ILjROEVcNd" }
+{ "su_suppkey": 456, "i_id": 70456, "su_name": "Supplier#000000456", "n_name": "Finland", "i_name": "xsfbmhawalwqmpt", "su_address": "mqocnuxnmrbzuomiimjodcuqttrydta", "su_phone": "0845626029655670", "su_comment": "GMDgWXRkfkI8Zta8lTrbQNi1uCr0qqxLogEPUr28ILjROEVcNd" }
+{ "su_suppkey": 569, "i_id": 20569, "su_name": "Supplier#000000569", "n_name": "Finland", "i_name": "gsfgyefqhynjhlmdidlcgtfl", "su_address": "picbuujampdepizex", "su_phone": "1553942623898142", "su_comment": "5JXelhIRJo8g6uoNc9T9NALqoLZSUvdYxSimI78fkGUEOwr45hkBZ4ZbHFPcPU3L" }
+{ "su_suppkey": 594, "i_id": 80594, "su_name": "Supplier#000000594", "n_name": "Finland", "i_name": "ldhlbtagzvcloiv", "su_address": "jxnpfslppjqlofubduksbmjdensmxwvnduok", "su_phone": "9265866480610057", "su_comment": "3wjKesc3dqXwbHsYhaQanP0WEZExaQcbVeo" }
+{ "su_suppkey": 789, "i_id": 40789, "su_name": "Supplier#000000789", "n_name": "Finland", "i_name": "cgedmrgumhrzvjsgzw", "su_address": "ilujvozetzgjkeqqhiadiaidwtfcc", "su_phone": "5791419417899962", "su_comment": "afLleTXPaqHRdBExUFZrR7eyAMtCeZHf91mpNJI4VFNb6kLsgYcUMYyo2C3fA9hI6IkaySWm7VrSkh7a7" }
+{ "su_suppkey": 1487, "i_id": 41487, "su_name": "Supplier#000001487", "n_name": "Finland", "i_name": "ifezfdijjnwpkwo", "su_address": "nosziyvlcgdq", "su_phone": "0665183101355704", "su_comment": "3jBUrwRTaK8x5dYgxFAIc8UBdg5RGAxIzxyMvNtNFS6Im148yYoDEATjT8JhhbvGyUfFS8aVlxoHM7DwF9" }
+{ "su_suppkey": 1487, "i_id": 51487, "su_name": "Supplier#000001487", "n_name": "Finland", "i_name": "gemaxjhoggisdynldpeuevz", "su_address": "nosziyvlcgdq", "su_phone": "0665183101355704", "su_comment": "3jBUrwRTaK8x5dYgxFAIc8UBdg5RGAxIzxyMvNtNFS6Im148yYoDEATjT8JhhbvGyUfFS8aVlxoHM7DwF9" }
+{ "su_suppkey": 2212, "i_id": 72212, "su_name": "Supplier#000002212", "n_name": "Finland", "i_name": "vqgxxihvjwtygskoocx", "su_address": "kpxfkdoxlizcexycxwarjtea", "su_phone": "2239985843533052", "su_comment": "nk9GzMeRqWmfbXoNOlkTdPVuLRvxDTbukSzw4Ljsqh5LzbkG8tGoXJsxNNbSSO7W7MthyCkqQMKDofRqF2lrzJXgAPv6lWvM59" }
+{ "su_suppkey": 2459, "i_id": 42459, "su_name": "Supplier#000002459", "n_name": "Finland", "i_name": "ygqapcuthosldcuso", "su_address": "vwjwbvbmscqctgfxo", "su_phone": "3495429847532161", "su_comment": "XbBS9yzCkmJ0yMeBT6P3AxjnGs0BMgIHjzedCKcuqRrteI36TQX3Yzu" }
+{ "su_suppkey": 2734, "i_id": 42734, "su_name": "Supplier#000002734", "n_name": "Finland", "i_name": "tlagsozizfxxxcwnsyeddo", "su_address": "wggngblykokbviioxfcuoknejbvoxklau", "su_phone": "4532489164262997", "su_comment": "p6Rs6yVHGdZLYMD0LL1gPaQJ5DzdcVlipJ20dZzuGVmK43myfPGTKFjloKS" }
+{ "su_suppkey": 2996, "i_id": 92996, "su_name": "Supplier#000002996", "n_name": "Finland", "i_name": "moirvwnnzjmoeifulvf", "su_address": "yilqnylzpqkvtcslv", "su_phone": "0747198360511561", "su_comment": "RxPUOIp8Gvrw2UzPpvtN3Ih2dVeq0mPsSQKq" }
+{ "su_suppkey": 3252, "i_id": 23252, "su_name": "Supplier#000003252", "n_name": "Finland", "i_name": "hkilqoywahzfqe", "su_address": "lhjiizdeayoheetmjd", "su_phone": "3149608164398812", "su_comment": "9wkeAkrtTJ4vj6u46Dh29SEOa4LGKlxSdxPgU" }
+{ "su_suppkey": 3302, "i_id": 3302, "su_name": "Supplier#000003302", "n_name": "Finland", "i_name": "wyagqsysxgpvxvphgvjzc", "su_address": "claabfaopdlomlsvrpkrgempamulslwkahcegcfm", "su_phone": "3650275630074116", "su_comment": "3mimLfbJcN5jxZXqatM8BkCU8lVHz6rrcIJVt5sYmJ8W0cNEeBzwzbX7Q6AbRlpbUxg0XbVSt4ITeQsxgpIKFAlLi5P9hw" }
+{ "su_suppkey": 3460, "i_id": 23460, "su_name": "Supplier#000003460", "n_name": "Finland", "i_name": "xdvrzrspvqyirqqsdmmdmvwz", "su_address": "jphhppbbloobrzigsarglqiu", "su_phone": "9198288671639487", "su_comment": "sL4g9gJc32TJX0C0Z2PFSo8g8AwGQH6bm6zbgX0cwySskL5UmWJuvMzHBrxAY6uA5wA4cOBuIa6xTwjlQ8" }
+{ "su_suppkey": 3597, "i_id": 13597, "su_name": "Supplier#000003597", "n_name": "Finland", "i_name": "etbxpwnaipuxuh", "su_address": "jhvikwtfgvroeeuxeknetnouujfgeqb", "su_phone": "1118811424997738", "su_comment": "dSFBVwidRp2sejaKsHGkR19iKo7aLJMWIs3Bvx8A7w4lPy6e53JwCDXdEapEMa4w2tbgouObc79DZsIRPwEiGNK6Hxq" }
+{ "su_suppkey": 3597, "i_id": 33597, "su_name": "Supplier#000003597", "n_name": "Finland", "i_name": "uxoqlsauwlmlxgtsbmhfc", "su_address": "jhvikwtfgvroeeuxeknetnouujfgeqb", "su_phone": "1118811424997738", "su_comment": "dSFBVwidRp2sejaKsHGkR19iKo7aLJMWIs3Bvx8A7w4lPy6e53JwCDXdEapEMa4w2tbgouObc79DZsIRPwEiGNK6Hxq" }
+{ "su_suppkey": 3626, "i_id": 53626, "su_name": "Supplier#000003626", "n_name": "Finland", "i_name": "flgafmwzkkufuwjlpfcgmaf", "su_address": "asidxstgmakidmarpr", "su_phone": "7219237012504660", "su_comment": "9u3SZ8wnpKeKt5E12YmlPed400VD1AiORgeEjgIEHjZrZKuy7POhMCLtOwGmyyvd6sy8EUINNTiMIsLPv49MJo" }
+{ "su_suppkey": 5539, "i_id": 55539, "su_name": "Supplier#000005539", "n_name": "Finland", "i_name": "nsscezkpjzfpqurymzzs", "su_address": "srfmyyltinevy", "su_phone": "5408884501227847", "su_comment": "7sW48gsC40EHo6gfdcWIsVk1daLFVzmNCKFNwaIIe8YEcDZ4pS8iq0smIkQ69ecSaQYdfUn3Djo4T9PN3X9dQWO8a8W" }
+{ "su_suppkey": 5701, "i_id": 15701, "su_name": "Supplier#000005701", "n_name": "Finland", "i_name": "qpltstucytljhbfdybtmu", "su_address": "gohymctpqjmrwebanzvbq", "su_phone": "6252970293226495", "su_comment": "bXGSernkhtLJS8ItfgrR1VoFjXV9mz3won0E53zp4Gklfy3U2VHguFiF0YwhM9XE0BxkpaJJGPRQZWnJLcWCazLlgwmxDjVr5Fz" }
+{ "su_suppkey": 5701, "i_id": 55701, "su_name": "Supplier#000005701", "n_name": "Finland", "i_name": "lexsglthobyamrannbinjmqi", "su_address": "gohymctpqjmrwebanzvbq", "su_phone": "6252970293226495", "su_comment": "bXGSernkhtLJS8ItfgrR1VoFjXV9mz3won0E53zp4Gklfy3U2VHguFiF0YwhM9XE0BxkpaJJGPRQZWnJLcWCazLlgwmxDjVr5Fz" }
+{ "su_suppkey": 5715, "i_id": 25715, "su_name": "Supplier#000005715", "n_name": "Finland", "i_name": "xctuasaieksmomzyxktbtx", "su_address": "zattbvktzpp", "su_phone": "1643093229529279", "su_comment": "M5AfaLt2Z7qmC0RFhTEP0wyMojHEsMMK4LyIKsh6v1NLiRrQh" }
+{ "su_suppkey": 5715, "i_id": 45715, "su_name": "Supplier#000005715", "n_name": "Finland", "i_name": "cpbdguzwcsunulwuzkhby", "su_address": "zattbvktzpp", "su_phone": "1643093229529279", "su_comment": "M5AfaLt2Z7qmC0RFhTEP0wyMojHEsMMK4LyIKsh6v1NLiRrQh" }
+{ "su_suppkey": 5800, "i_id": 35800, "su_name": "Supplier#000005800", "n_name": "Finland", "i_name": "jzwvriuozdesabg", "su_address": "fypmyzufpykodcqirqocvqi", "su_phone": "0159637844005424", "su_comment": "J2vAEQzCErfAMd4k0vSty3XKhNXRXPUKkG4TfCUl3y3OBXGzP9mug7XJfbktV7wLU2HFbHhyCN7MGWO06CMmH" }
+{ "su_suppkey": 5894, "i_id": 75894, "su_name": "Supplier#000005894", "n_name": "Finland", "i_name": "xoshlgvvlcybppcfoaflxskq", "su_address": "lsjovsowzuhrihy", "su_phone": "5171879235753608", "su_comment": "iCf8OSor3Bku7kqIfYiwMQnEAGKEOgoe7Lfd24l0vYREJzLyw7dDt4QoMGphLH60gg2" }
+{ "su_suppkey": 5909, "i_id": 65909, "su_name": "Supplier#000005909", "n_name": "Finland", "i_name": "gjvdyfgchwsjwloubudadxvu", "su_address": "lzbkujfbrsirxsgfbggwzxdp", "su_phone": "6777692686111677", "su_comment": "f64PPp7W04clLrGYE9MuOV2Y5TM0WF9mphoZFJmsXy2wg7VqW7" }
+{ "su_suppkey": 6010, "i_id": 46010, "su_name": "Supplier#000006010", "n_name": "Finland", "i_name": "ggcdpuljkcqvnjzfqo", "su_address": "eedemwxbkrtcoslkkuufujyjualrqsls", "su_phone": "6744361621020728", "su_comment": "uuE9Pd4vItFgPEyA6l9u4gaSKbPZlJ99yyMHqe45KVB0Byf0t7xPzTKDBVAG7" }
+{ "su_suppkey": 6385, "i_id": 46385, "su_name": "Supplier#000006385", "n_name": "Finland", "i_name": "uhlewnxrejyyylahwi", "su_address": "kzhrnuadbsesqxmpandwwggdrshtsojdtpaikpk", "su_phone": "2056437950120142", "su_comment": "VdYyJK1XV5bLMsgiOJ1sTGiQIUYYizQJRQXxrGP4MajqB3hAKl4Ch15lcmnRVPDRQkkK0faY" }
+{ "su_suppkey": 6496, "i_id": 56496, "su_name": "Supplier#000006496", "n_name": "Finland", "i_name": "gnixvcywsqgzlxmthmnhf", "su_address": "ucnbspedqywifygjugg", "su_phone": "5318578064611853", "su_comment": "un1GHvhsOoSrfp504z7aYrfrZVnWBhZS7m" }
+{ "su_suppkey": 6597, "i_id": 96597, "su_name": "Supplier#000006597", "n_name": "Finland", "i_name": "hooyixphnkuxweu", "su_address": "yaahpnsahxotqfffab", "su_phone": "2698283311849710", "su_comment": "EyLUAedIwyfRDDizUndFx425IVCrpK82Rddd" }
+{ "su_suppkey": 6711, "i_id": 36711, "su_name": "Supplier#000006711", "n_name": "Finland", "i_name": "afisllfebdozvsqsuvb", "su_address": "cqevjyzxnipcwjfgkknehundmrntnrqwyun", "su_phone": "6629671679874614", "su_comment": "S6DDntNkq4M3cK3qveP9CnQlkfWIhnvRgk92MLSQZouqKPgAbzLeQhz1XagqrThHRd7O4EbRKen" }
+{ "su_suppkey": 6711, "i_id": 96711, "su_name": "Supplier#000006711", "n_name": "Finland", "i_name": "spzwgkjhmrdwcxhydw", "su_address": "cqevjyzxnipcwjfgkknehundmrntnrqwyun", "su_phone": "6629671679874614", "su_comment": "S6DDntNkq4M3cK3qveP9CnQlkfWIhnvRgk92MLSQZouqKPgAbzLeQhz1XagqrThHRd7O4EbRKen" }
+{ "su_suppkey": 6850, "i_id": 16850, "su_name": "Supplier#000006850", "n_name": "Finland", "i_name": "vnhbwvhrpvficubsozz", "su_address": "mwxsjtekpxxzpgcuylhuowidmcfw", "su_phone": "9639185416811450", "su_comment": "XduWBYGfiEBK0HThqMeL94Xf64xwtiTKdY2B8Gyo89jwaMEjq" }
+{ "su_suppkey": 6976, "i_id": 46976, "su_name": "Supplier#000006976", "n_name": "Finland", "i_name": "jpyxjmnjdtbfjcomsnjeimz", "su_address": "ycrxzpeolnvkromjb", "su_phone": "0598831630936003", "su_comment": "JzBf6TooGYJwTSf8kgx8IE66LEc9SM19u6NA0N5LrjLPgoNUrWdT5H2sjtqWTEp4uB5ttUo9TZQ3M" }
+{ "su_suppkey": 7052, "i_id": 27052, "su_name": "Supplier#000007052", "n_name": "Finland", "i_name": "lxqcrhjbzllkmxusuujd", "su_address": "syfnutckpwxexbqmhtigucbr", "su_phone": "5428950106184730", "su_comment": "5FFAJ1cmpVoLWX2Ds5LcdO4ldKry9uNjrzkTCVqKFZGHkR" }
+{ "su_suppkey": 7052, "i_id": 87052, "su_name": "Supplier#000007052", "n_name": "Finland", "i_name": "dlthgxownyorviyxays", "su_address": "syfnutckpwxexbqmhtigucbr", "su_phone": "5428950106184730", "su_comment": "5FFAJ1cmpVoLWX2Ds5LcdO4ldKry9uNjrzkTCVqKFZGHkR" }
+{ "su_suppkey": 7151, "i_id": 87151, "su_name": "Supplier#000007151", "n_name": "Finland", "i_name": "cbzcqbewljqqfnprddtrsqfq", "su_address": "qxhbvcmymanswlcilwexwukfjlguino", "su_phone": "8393337575966552", "su_comment": "SdxLs2YpFdIsJc3ehiYA0OqAFgK2JldgYqAaU2awqhceBZ9TlpbIpNxPdKVqtdJcZVHlIS2udLCR4kIwV9xDIN8bb8U2CD" }
+{ "su_suppkey": 7707, "i_id": 27707, "su_name": "Supplier#000007707", "n_name": "Finland", "i_name": "ogkddaeapzziwitox", "su_address": "kweoavhuzkcuhnipkucvchwf", "su_phone": "4567822435321819", "su_comment": "05XAPcHp13Ei5zphGzHgwCRd2KFeO6OAY455wbvxCOZjMSqe8KVZbVAEJ0KzC10GPiirFcLXgprcldhbtODSpc383TA58BU" }
+{ "su_suppkey": 7844, "i_id": 77844, "su_name": "Supplier#000007844", "n_name": "Finland", "i_name": "cfoltnopnyszivhnfucrkz", "su_address": "bvasrkrwdqrfafzidzmnslcdfeodozghtjws", "su_phone": "9401005349104978", "su_comment": "3Dot7USpIxKnxKUdzAYnfLhbEpYu7kpkwvnsf0S6KeUxyAlZ3654GyuKoPsH" }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.5.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.5.adm
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.5.adm
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.6.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.6.adm
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.6.adm
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.7.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.7.adm
new file mode 100644
index 0000000..3c00660
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.7.adm
@@ -0,0 +1,7 @@
+{ "n_name": "Cambodia", "revenue": 46414.95 }
+{ "n_name": "Afghanistan", "revenue": 39124.81 }
+{ "n_name": "Singapore", "revenue": 32132.35 }
+{ "n_name": "Malaysia", "revenue": 29123.23 }
+{ "n_name": "Uzbekistan", "revenue": 26007.01 }
+{ "n_name": "North Korea", "revenue": 23113.33 }
+{ "n_name": "Taiwan", "revenue": 16556.39 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.8.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.8.adm
new file mode 100644
index 0000000..a5db511
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.8.adm
@@ -0,0 +1 @@
+{ "revenue": 1.5046590150000013E7 }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.9.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.9.adm
new file mode 100644
index 0000000..df0f8a7
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/ch2/ch2.9.adm
@@ -0,0 +1 @@
+{ "cust_nation": "s", "l_year": null, "supp_nation": 55, "revenue": 8272.67 }
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
index 288a310..9ca46d7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
@@ -22,6 +22,7 @@
<!ENTITY AsyncDeferredQueries SYSTEM "queries_sqlpp/async-deferred/AsyncDeferredQueries.xml">
<!ENTITY GeoQueries SYSTEM "queries_sqlpp/geojson/GeoJSONQueries.xml">
<!ENTITY TemporalQueries SYSTEM "queries_sqlpp/temporal/TemporalQueries.xml">
+ <!ENTITY CBOJoinQueries SYSTEM "queries_sqlpp/cbo-join/CBOJoinQueries.xml">
]>
<test-suite xmlns="urn:xml.testframework.asterix.apache.org" ResultOffsetPath="results" QueryOffsetPath="queries_sqlpp" QueryFileExtension=".sqlpp" SourceLocation="true">
&ObjectsQueries;
@@ -29,4 +30,5 @@
&GeoQueries;
&TemporalQueries;
&SqlppQueries;
+ &CBOJoinQueries;
</test-suite>