Hallo,
Ich habe Windows neu aufgesetzt.
und alles neu Installiert jetzt geht der Shop Abgleich nicht mehr.
Ich hoffe ihr könnt mir Helfen.
wenn ich Shop Abgleich mache kommt immer nur der Fehler:
Abgleich-Protokoll:
Onlineshop-Abgleich beendet für 'Dartshop- Shopware'.
Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
Exception bei Category.statistic: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
Response: {"result":null,"error":{"code":0,"message":"An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_
Ich habe Windows neu aufgesetzt.
und alles neu Installiert jetzt geht der Shop Abgleich nicht mehr.
Ich hoffe ihr könnt mir Helfen.
wenn ich Shop Abgleich mache kommt immer nur der Fehler:
Abgleich-Protokoll:
Onlineshop-Abgleich beendet für 'Dartshop- Shopware'.
Fehler:
Exception: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
Exception bei Category.statistic: An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_core_customergroups s3_ ON s3_.id = s5_.customergroupID WHERE j4_.host_id IS NULL ORDER BY j1_.level ASC) dctrn_result) dctrn_table':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dartshop.jtl_connector_category_level' doesn't exist
Response: {"result":null,"error":{"code":0,"message":"An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT s0_.sorting_ids AS sorting_ids_0, s0_.hide_sortings AS hide_sortings_1, s0_.facet_ids AS facet_ids_2, s0_.id AS id_3, s0_.parent AS parent_4, s0_.stream_id AS stream_id_5, s0_.description AS description_6, s0_.position AS position_7, s0_.meta_title AS meta_title_8, s0_.metakeywords AS metakeywords_9, s0_.metadescription AS metadescription_10, s0_.cmsheadline AS cmsheadline_11, s0_.cmstext AS cmstext_12, s0_.active AS active_13, s0_.template AS template_14, s0_.product_box_layout AS product_box_layout_15, s0_.blog AS blog_16, s0_.path AS path_17, s0_.external AS external_18, s0_.external_target AS external_target_19, s0_.hidefilter AS hidefilter_20, s0_.hidetop AS hidetop_21, s0_.changed AS changed_22, s0_.added AS added_23, s0_.mediaID AS mediaID_24, j1_.level AS level_25, s2_.id AS id_26, s2_.categoryID AS categoryID_27, s2_.attribute1 AS attribute1_28, s2_.attribute2 AS attribute2_29, s2_.attribute3 AS attribute3_30, s2_.attribute4 AS attribute4_31, s2_.attribute5 AS attribute5_32, s2_.attribute6 AS attribute6_33, s3_.id AS id_34, s3_.groupkey AS groupkey_35, s3_.description AS description_36, s3_.tax AS tax_37, s3_.taxinput AS taxinput_38, s3_.mode AS mode_39, s3_.discount AS discount_40, s3_.minimumorder AS minimumorder_41, s3_.minimumordersurcharge AS minimumordersurcharge_42, j1_.category_id AS category_id_43 FROM s_categories s0_ LEFT JOIN jtl_connector_link_category j4_ ON s0_.id = j4_.category_id INNER JOIN jtl_connector_category_level j1_ ON s0_.id = j1_.category_id LEFT JOIN s_categories_attributes s2_ ON s0_.id = s2_.categoryID LEFT JOIN s_categories_avoid_customergroups s5_ ON s0_.id = s5_.categoryID LEFT JOIN s_