SELECT s0_.id AS id0,
s0_.articleID AS articleID1,
s0_.unitID AS unitID2,
s0_.ordernumber AS ordernumber3,
s0_.suppliernumber AS suppliernumber4,
s0_.kind AS kind5,
s0_.additionaltext AS additionaltext6,
s0_.active AS active7,
s0_.instock AS instock8,
s0_.stockmin AS stockmin9,
s0_.weight AS weight10,
s0_.width AS width11,
s0_.length AS length12,
s0_.height AS height13,
s0_.ean AS ean14,
s0_.position AS position15,
s0_.minpurchase AS minpurchase16,
s0_.purchasesteps AS purchasesteps17,
s0_.maxpurchase AS maxpurchase18,
s0_.purchaseunit AS purchaseunit19,
s0_.referenceunit AS referenceunit20,
s0_.packunit AS packunit21,
s0_.shippingfree AS shippingfree22,
s0_.releasedate AS releasedate23,
s0_.shippingtime AS shippingtime24,
s1_.id AS id25,
s1_.main_detail_id AS main_detail_id26,
s1_.supplierID AS supplierID27,
s1_.taxID AS taxID28,
s1_.pricegroupID AS pricegroupID29,
s1_.filtergroupID AS filtergroupID30,
s1_.configurator_set_id AS configurator_set_id31,
s1_.name AS name32,
s1_.description AS description33,
s1_.description_long AS description_long34,
s1_.datum AS datum35,
s1_.active AS active36,
s1_.pseudosales AS pseudosales37,
s1_.topseller AS topseller38,
s1_.keywords AS keywords39,
s1_.metaTitle AS metaTitle40,
s1_.changetime AS changetime41,
s1_.pricegroupActive AS pricegroupActive42,
s1_.laststock AS laststock43,
s1_.crossbundlelook AS crossbundlelook44,
s1_.notification AS notification45,
s1_.template AS template46,
s1_.mode AS mode47,
s1_.available_from AS available_from48,
s1_.available_to AS available_to49,
s2_.id AS id50,
s2_.articleID AS articleID51,
s2_.articledetailsID AS articledetailsID52,
s2_.pricegroup AS pricegroup53,
s2_.`from` AS from54,
s2_.`to` AS to55,
s2_.price AS price56,
s2_.pseudoprice AS pseudoprice57,
s2_.baseprice AS baseprice58,
s2_.percent AS percent59,
s3_.id AS id60,
s3_.unit AS unit61,
s3_.description AS description62,
s4_.id AS id63,
s4_.tax AS tax64,
s4_.description AS description65,
s5_.id AS id66,
s5_.parent AS parent67,
s5_.description AS description68,
s5_.position AS position69,
s5_.metakeywords AS metakeywords70,
s5_.metadescription AS metadescription71,
s5_.cmsheadline AS cmsheadline72,
s5_.cmstext AS cmstext73,
s5_.active AS active74,
s5_.template AS template75,
s5_.blog AS blog76,
s5_.path AS path77,
s5_.showfiltergroups AS showfiltergroups78,
s5_.external AS external79,
s5_.hidefilter AS hidefilter80,
s5_.hidetop AS hidetop81,
s5_.noviewselect AS noviewselect82,
s5_.changed AS changed83,
s5_.added AS added84,
s6_.id AS id85,
s6_.articleID AS articleID86,
s6_.unitID AS unitID87,
s6_.ordernumber AS ordernumber88,
s6_.suppliernumber AS suppliernumber89,
s6_.kind AS kind90,
s6_.additionaltext AS additionaltext91,
s6_.active AS active92,
s6_.instock AS instock93,
s6_.stockmin AS stockmin94,
s6_.weight AS weight95,
s6_.width AS width96,
s6_.length AS length97,
s6_.height AS height98,
s6_.ean AS ean99,
s6_.position AS position100,
s6_.minpurchase AS minpurchase101,
s6_.purchasesteps AS purchasesteps102,
s6_.maxpurchase AS maxpurchase103,
s6_.purchaseunit AS purchaseunit104,
s6_.referenceunit AS referenceunit105,
s6_.packunit AS packunit106,
s6_.shippingfree AS shippingfree107,
s6_.releasedate AS releasedate108,
s6_.shippingtime AS shippingtime109,
s7_.id AS id110,
s7_.articleID AS articleID111,
s7_.articledetailsID AS articledetailsID112,
s7_.pricegroup AS pricegroup113,
s7_.`from` AS from114,
s7_.`to` AS to115,
s7_.price AS price116,
s7_.pseudoprice AS pseudoprice117,
s7_.baseprice AS baseprice118,
s7_.percent AS percent119,
s8_.id AS id120,
s8_.articleID AS articleID121,
s8_.description AS description122,
s8_.link AS link123,
s8_.target AS target124,
s9_.id AS id125,
s9_.articleID AS articleID126,
s9_.articledetailsID AS articledetailsID127,
s9_.attr1 AS attr1128,
s9_.attr2 AS attr2129,
s9_.attr3 AS attr3130,
s9_.attr4 AS attr4131,
s9_.attr5 AS attr5132,
s9_.attr6 AS attr6133,
s9_.attr7 AS attr7134,
s9_.attr8 AS attr8135,
s9_.attr9 AS attr9136,
s9_.attr10 AS attr10137,
s9_.attr11 AS attr11138,
s9_.attr12 AS attr12139,
s9_.attr13 AS attr13140,
s9_.attr14 AS attr14141,
s9_.attr15 AS attr15142,
s9_.attr16 AS attr16143,
s9_.attr17 AS attr17144,
s9_.attr18 AS attr18145,
s9_.attr19 AS attr19146,
s9_.attr20 AS attr20147,
s10_.id AS id148,
s10_.articleID AS articleID149,
s10_.description AS description150,
s10_.filename AS filename151,
s10_.size AS size152,
s11_.id AS id153,
s11_.name AS name154,
s11_.img AS img155,
s11_.link AS link156,
s11_.description AS description157,
s11_.meta_title AS meta_title158,
s11_.meta_description AS meta_description159,
s11_.meta_keywords AS meta_keywords160,
s12_.id AS id161,
s12_.description AS description162,
s13_.id AS id163,
s13_.discount AS discount164,
s13_.discountstart AS discountstart165,
s13_.customergroupID AS customergroupID166,
s13_.groupID AS groupID167,
s14_.id AS id168,
s14_.groupkey AS groupkey169,
s14_.description AS description170,
s14_.tax AS tax171,
s14_.taxinput AS taxinput172,
s14_.mode AS mode173,
s14_.discount AS discount174,
s14_.minimumorder AS minimumorder175,
s14_.minimumordersurcharge AS minimumordersurcharge176,
s15_.id AS id177,
s15_.group_id AS group_id178,
s15_.name AS name179,
s15_.position AS position180,
s16_.id AS id181,
s16_.name AS name182,
s16_.position AS position183,
s16_.comparable AS comparable184,
s16_.sortMode AS sortMode185,
s17_.id AS id186,
s17_.name AS name187,
s17_.filterable AS filterable188,
s18_.id AS id189,
s18_.value AS value190,
s18_.position AS position191,
s18_.optionID AS optionID192,
s18_.value_numeric AS value_numeric193,
s0_.articleID AS articleID194,
s0_.unitID AS unitID195,
s1_.taxID AS taxID196,
s1_.filtergroupID AS filtergroupID197,
s1_.supplierID AS supplierID198,
s1_.main_detail_id AS main_detail_id199,
s1_.pricegroupID AS pricegroupID200,
s1_.configurator_set_id AS configurator_set_id201,
s2_.articledetailsID AS articledetailsID202,
s2_.pricegroup AS pricegroup203,
s2_.articleID AS articleID204,
s5_.parent AS parent205,
s5_.mediaID AS mediaID206,
s6_.articleID AS articleID207,
s6_.unitID AS unitID208,
s7_.articledetailsID AS articledetailsID209,
s7_.pricegroup AS pricegroup210,
s7_.articleID AS articleID211,
s8_.articleID AS articleID212,
s9_.articleID AS articleID213,
s9_.articledetailsID AS articledetailsID214,
s10_.articleID AS articleID215,
s13_.groupID AS groupID216,
s13_.customergroupID AS customergroupID217,
s15_.group_id AS group_id218,
s18_.optionID AS optionID219
FROM s_articles_details s0_
LEFT JOIN jtl_connector_link_detail j19_ ON s0_.id = j19_.detail_id
LEFT JOIN s_articles s1_ ON s0_.articleID = s1_.id
LEFT JOIN s_articles_prices s2_ ON s0_.id = s2_.articledetailsID
LEFT JOIN s_core_units s3_ ON s0_.unitID = s3_.id
LEFT JOIN s_core_tax s4_ ON s1_.taxID = s4_.id
LEFT JOIN s_articles_categories s20_ ON s1_.id = s20_.articleID
LEFT JOIN s_categories s5_ ON s5_.id = s20_.categoryID
LEFT JOIN s_articles_details s6_ ON s1_.main_detail_id = s6_.id
LEFT JOIN s_articles_prices s7_ ON s6_.id = s7_.articledetailsID
LEFT JOIN s_articles_information s8_ ON s1_.id = s8_.articleID
LEFT JOIN s_articles_attributes s9_ ON s1_.id = s9_.articleID AND (s9_.articledetailsID = s0_.id)
LEFT JOIN s_articles_downloads s10_ ON s1_.id = s10_.articleID
LEFT JOIN s_articles_supplier s11_ ON s1_.supplierID = s11_.id
LEFT JOIN s_core_pricegroups s12_ ON s1_.pricegroupID = s12_.id
LEFT JOIN s_core_pricegroups_discounts s13_ ON s12_.id = s13_.groupID
LEFT JOIN s_articles_avoid_customergroups s21_ ON s1_.id = s21_.articleID
LEFT JOIN s_core_customergroups s14_ ON s14_.id = s21_.customergroupID
LEFT JOIN s_article_configurator_option_relations s22_ ON s0_.id = s22_.article_id
LEFT JOIN s_article_configurator_options s15_ ON s15_.id = s22_.option_id
LEFT JOIN s_filter s16_ ON s1_.filtergroupID = s16_.id
LEFT JOIN s_filter_relations s23_ ON s16_.id = s23_.groupID
LEFT JOIN s_filter_options s17_ ON s17_.id = s23_.optionID
LEFT JOIN s_filter_values s18_ ON s17_.id = s18_.optionID
WHERE j19_.host_id IS NULL
ORDER BY s0_.kind ASC
LIMIT 50 OFFSET 0
