Ошибка при запуске msproducts

[[!msProducts?
	&parents=`2`
	&class=`msCategory`
	&where=`{
	"class_key":"msCategory"
	}`
	
	&tpl=`@INLINE <p>[[+idx]]. <a href="/[[+product_uri]]">[[+product_pagetitle]]</a></p>`
	&select=`{
		"msCategory":"*"
		,"msProduct":"msProduct.id as product_id, msProduct.uri as product_uri, msProduct.pagetitle as product_pagetitle"
		,"msProductData":"*"
		,"500x500":"500x500.url as 500x500"
	}`
	&innerJoin=`{
		"msProduct": {
		"class":"msProduct", "alias":"msProduct", "on":"msProduct.parent = msCategory.id AND msProduct.class_key = 'msProduct'"
		},
		"msProductData": {
		"class":"msProductData", "alias":"msProductData", "on":"msProduct.id = msProductData.id"
		}
	}`
	&leftJoin=`{
		"500x500": {
		"class":"msProductFile","alias":"500x500", "on": "500x500.product_id = msProduct.id AND 500x500.path LIKE '%/500x500/' AND 500x500.rank=0"
		}
	}`
	&sortby=`msCategory.menuindex`
	&sortdir=`asc`
	&showLog=`1`
]]

0.0001411: pdoTools loaded.
0.0003250: Conditions prepared
0.0000370: xPDO query object created
0.0001550: innerJoined msProduct as msProduct
0.0001271: innerJoined msProductData as msProductData
0.0006590: leftJoined msProductData as Data
0.0001349: leftJoined msVendor as Vendor
0.0001299: leftJoined msProductFile as 500x500
0.0000041: Grouped by msProduct.id
0.0000210: Added selection of msProduct: msProduct.id as product_id, msProduct.uri as product_uri, msProduct.pagetitle as product_pagetitle
0.0000219: Added selection of msProductData: `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`
0.0000160: Added selection of msVendor: `name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`
0.0001800: Added selection of msCategory: `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000880: Added selection of msProductData: `id`, `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`
0.0000169: Added selection of msProductFile: 500x500.url as 500x500
0.0008011: Processed additional conditions
0.0010469: Added where condition: class_key=msCategory, msCategory.parent:IN(2,11,17,24,28,12,13,23,19,20,21,22,18,25,26), msCategory.published=1, msCategory.deleted=0
0.0000682: Sorted by msCategory.menuindex, asc
0.0000031: Limited to 10, offset 0
0.0004029: SQL prepared "SELECT msProduct.id as product_id, msProduct.uri as product_uri, msProduct.pagetitle as product_pagetitle, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties`, `msCategory`.`id`, `msCategory`.`type`, `msCategory`.`contentType`, `msCategory`.`pagetitle`, `msCategory`.`longtitle`, `msCategory`.`description`, `msCategory`.`alias`, `msCategory`.`link_attributes`, `msCategory`.`published`, `msCategory`.`pub_date`, `msCategory`.`unpub_date`, `msCategory`.`parent`, `msCategory`.`isfolder`, `msCategory`.`introtext`, `msCategory`.`content`, `msCategory`.`richtext`, `msCategory`.`template`, `msCategory`.`menuindex`, `msCategory`.`searchable`, `msCategory`.`cacheable`, `msCategory`.`createdby`, `msCategory`.`createdon`, `msCategory`.`editedby`, `msCategory`.`editedon`, `msCategory`.`deleted`, `msCategory`.`deletedon`, `msCategory`.`deletedby`, `msCategory`.`publishedon`, `msCategory`.`publishedby`, `msCategory`.`menutitle`, `msCategory`.`donthit`, `msCategory`.`privateweb`, `msCategory`.`privatemgr`, `msCategory`.`content_dispo`, `msCategory`.`hidemenu`, `msCategory`.`class_key`, `msCategory`.`context_key`, `msCategory`.`content_type`, `msCategory`.`uri`, `msCategory`.`uri_override`, `msCategory`.`hide_children_in_tree`, `msCategory`.`show_in_tree`, `msCategory`.`properties`, `msProductData`.`id`, `msProductData`.`article`, `msProductData`.`price`, `msProductData`.`old_price`, `msProductData`.`weight`, `msProductData`.`image`, `msProductData`.`thumb`, `msProductData`.`vendor`, `msProductData`.`made_in`, `msProductData`.`new`, `msProductData`.`popular`, `msProductData`.`favorite`, `msProductData`.`tags`, `msProductData`.`color`, `msProductData`.`size`, `msProductData`.`source`, 500x500.url as 500x500 FROM `modx_site_content` AS `msCategory` JOIN `modx_site_content` `msProduct` ON msProduct.parent = msCategory.id AND msProduct.class_key = 'msProduct' JOIN `modx_ms2_products` `msProductData` ON msProduct.id = msProductData.id LEFT JOIN `modx_ms2_products` `Data` ON  LEFT JOIN `modx_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `modx_ms2_product_files` `500x500` ON 500x500.product_id = msProduct.id AND 500x500.path LIKE '%/500x500/' AND 500x500.rank=0 WHERE  ( `msCategory`.`class_key` = 'msCategory' AND `msCategory`.`parent` IN (2,11,17,24,28,12,13,23,19,20,21,22,18,25,26) AND `msCategory`.`published` = 1 AND `msCategory`.`deleted` = 0 )  GROUP BY msProduct.id ORDER BY msCategory.menuindex asc LIMIT 10 "
0.0003669: Could not process query, error #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN `modx_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `modx_ms2_pr' at line 1
0.0041511: Total time
9 699 328: Memory usage