Изображения miniShop2 через mSearch

[[!pdoPage?
    &parents=`4`
&class=`msProductFile`
    &element=`mSearch2`
    &leftJoin=`{
	"120x90": {
		"class": "msProductFile",
		"alias": "120x90"
		"on": "modResource.id = msProductFile.id AND VoteFormThread.form = 1"
	 }
    }`
&select=`{
	"modResource": "*",
	"120x90": "120x90.thumb as 120x90"
}`
    &includeMS=`1`
    &processTVs=`1`
&tpl=``
&showLog=`1`
  ]]

Showlog:

0.0060711: Query parameters are prepared.
0.0000620: xPDO query object created
0.0002189: leftJoined mseIntro as Intro
0.0000050: Grouped by modResource.id
0.0004289: Added selection of modResource: SQL_CALC_FOUND_ROWS `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.0000260: Added selection of mseIntro: intro
0.0000200: Added selection of 120x90: 120x90.thumb as 120x90
0.0000529: Sorted by msProductFile.id, ASC
0.0000072: Limited to 10, offset 
0.0003850: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, `intro`, 120x90.thumb as 120x90 FROM `modx_ms2_product_files` AS `msProductFile` LEFT JOIN `modx_mse2_intro` `Intro` ON `modResource`.`id`=`Intro`.`resource` GROUP BY modResource.id ORDER BY msProductFile.id ASC LIMIT 10 "
0.0015969: Could not process query, error #1054: Unknown column 'modResource.id' in 'field list'
0.0358939: Total time
16 252 928: Memory usage

Ммм. Удалите &class — он, все-таки, лишний. Без него должно заджоинить.

Вы правы, заджоинил, однако:

0.0029719: Could not process query, error #1054: Unknown column '120x90.thumb' in 'field list'

"alias": "120x90"
"on"

— добавьте запятую после «120х90».

[[!pdoPage?
    &parents=`4`
    &element=`mSearch2`
    &leftJoin=`{
	"120x90": {
		"class": "msProductFile",
		"alias": "120x90",
		"on": "modResource.id = msProductFile.id AND VoteFormThread.form = 1"
	 }
    }`
&select=`{
	"modResource": "*",
	"120x90": "120x90.thumb as 120x90"
}`
    &includeMS=`1`
    &processTVs=`1`
&tpl=``
&showLog=`1`
  ]]

Ошибка та же:

Could not process query, error #1054: Unknown column '120x90.thumb' in 'field list'

обновите ваш leftJoin — вы, видимо, подставили его раньше, чем я обновил..)

AND VoteFormThread.form = 1 — это нужно удалить.

Убрал, ошибка та же!

Ок… Последнее предположение — «on»: «modResource.id = msProductFile.id» здесь msProductFile.id заменить на 120х90.id

Если не поможет — сдаюсь..)

Вот блин, тут остался один — два шага…
Не помогло, ошибка та же:

0.0084169: Could not process query, error #1054: Unknown column '120x90.thumb' in 'field list'

Всё равно, спасибо Вам огромное, теперь у меня есть объемный пример кода leftjoin PdoTools!

Скиньте лог последней версии…
Да пока не за что.

0.0001900: pdoTools loaded.
0.0006421: [mSearch2] Filtered search query: "котлы"
0.0109179: [mSearch2] Search query with processed aliases: "котлы"
0.0096691: [mSearch2] Found results by words INDEX (КОТЛЫ,КОТЕЛ): 447
0.0015969: [mSearch2] Added resources by LIKE search: 0
0.0114319: Query parameters are prepared.
0.0000591: xPDO query object created
0.0009549: leftJoined mseIntro as Intro
0.0025461: leftJoined msProductFile as 120x90
0.0000079: Grouped by modResource.id
0.0006671: Added selection of modResource: SQL_CALC_FOUND_ROWS `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.0000510: Added selection of mseIntro: intro
0.0000498: Added selection of msProductFile: 120x90.thumb as 120x90
0.0266910: Processed additional conditions
0.0315289: Added where condition: modResource.id:IN(5250,5249,5248,5247,5251,5252,5255,5254,5253,1024,1025,1021,1023,1022,361,144,420,425,423,422,424,421,1020,294,296,293,582,197,162,84,292,589,156,950,951,952,571,868,545,2293,588,298,297,300,301,1053,1054,362,581,1078,139,299,543,1052,1050,1072,509,471,587,987,1058,946,944,1057,1055,1056,541,83,508,295,943,1075,1080,1059,158,945,817,814,819,544,2289,542,2291,1228,145,142,947,948,982,1043,1042,1041,1044,1049,949,806,5422,161,159,157,637,737,818,816,583,5283,5404,5405,5403,5401,5399,5400,5406,5407,5412,5413,5414,5411,5410,5408,5409,5398,5402,5389,5396,5397,1176,1180,1179,843,815,1177,1178,143,154,151,639,153,636,160,152,1040,1039,1017,4248,641,644,640,1016,1047,645,836,838,205,146,5099,5192,105,147,148,150,149,155,1209,638,841,570,807,518,519,447,968,970,971,1184,1186,1183,1185,840,359,844,837,839,820,825,724,4753,826,1216,5034,107,108,821,106,104,103,109,110,5331,5098,5330,5329,46,5236,646,5239,1076,1239,2294,5238,1074,1077,1113,5480,1182,1181,167,165,855,2284,823,824,610,580,430,822,5136,953,611,612,723,2299,861,773,1069,1070,981,978,973,977,1232,1225,980,976,983,979,975,974,5244,972,1236,985,5235,5245,1015,5234,355,5240,5418,5243,5242,5241,5420,984,5233,986,354,5246,5232,1014,498,5191,4754,4752,90,47,5142,5141,4757,4756,854,1208,5381,5382,5383,280,860,2285,5221,4750,281,2288,5380,2287,2290,5231,2295,2292,363,5108,50,849,847,851,201,49,497,45,499,4751,48,4748,358,356,869,5481,282,279,89,166,501,858,930,875,842,827,429,163,82,2286,576,831,511,248,357,5219,575,828,1073,5229,5230,9,51,829,373,5333,374,283,871,845,846,252,850,377,378,379,375,5332,872,859,1,830,500,857,856,376,5388,5387,5227,5391,5392,274,5390,5393,5386,5367,5415,5362,5363,5366,5364,5368,5369,5384,5385,5416,5417,5419,5370,5365,5228,5373,5374,5375,5376,5372,5371,276,5111,275,4230,5144,5112,4249,277,4250,4252,643,4251,5377,5378,5379,1188,1187,4231,1189,1190,219,245,246,5137,5140,5139,5138,249,242,5100,1018,1019,5036,244,5215,775,5226,259,923,1112,926,1118,465,1105,463,835,464,4,69,5395), modResource.parent:IN(4,8,9,13,10,16,14,12,11,58,15,1139,1218,1234,1232,1237,1238,5112,17,18,19,5337,20,21,5022,79,80,81,85,86,87,88,97,117,118,119,120,121,122,123,124,125,127,128,130,131,132,134,135,136,137,138,380,433,516,517,522,548,549,550,551,552,553,554,555,867,876,877,895,954,955,1029,1205,1126,1129,1130,2297,4234,4235,5021,5205,5206,5207,5208,232,234,236,237,238,239,240,241,431,432,448,449,577,578,579,584,585,586,763,764,765,766,767,768,1200,1201,1203,1204,1206,1207,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5284,5313,5285,5314,5286,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,547,1131,1133,1134,1135,5113,5114,5115,5116,5117,5118,5119,959,896,897,5023,5024,5031,5032,5033,45,46,47,48,49,50,51,69,5120,103,104,105,106,107,108,109,110,163,165,166,167,279,280,281,282,420,421,422,423,424,425,429,430,497,498,499,500,501,508,509,580,581,582,583,640,641,644,645,646,773,943,944,945,946,947,948,949,950,951,952,1014,1015,1016,1017,4748,4750,4751,4752,4753,4754,4756,4757,5108,5191,5192,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5381,5382,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5419,5422,82,83,84,89,90,139,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,197,201,205,447,471,570,571,575,576,610,611,612,723,724,737,836,837,838,839,840,841,842,843,844,845,846,847,849,850,851,868,869,871,872,875,930,953,968,970,971,1039,1040,1041,1042,1043,1044,1047,1049,1050,1052,1053,1054,1055,1056,1057,1058,1069,1070,1072,1073,1074,1075,1076,1077,1078,1080,1208,2284,2285,1176,2286,2288,2287,2289,2290,2291,2292,2294,2299,4249,4250,4251,4252,5034,5098,5136,5141,5142,5231,5232,5233,5234,5235,5236,5238,5239,5240,5241,5242,5243,5244,5245,5246,292,293,294,295,296,297,298,299,300,301,518,519,541,542,543,544,545,822,823,824,825,826,827,828,829,830,831,835,1020,1021,1022,1023,1024,1025,1059,1209,1224,1225,354,355,356,357,358,359,361,362,363,511,5247,5248,5249,5250,5251,5252,5253,5254,5255,587,588,589,643,806,807,814,815,816,817,818,819,820,821,854,855,856,857,858,859,860,861,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,4248,1183,1184,1185,1186,987,5420,5418,636,637,638,639,1177,1178,1179,1180,1181,1182,5099,5480,274,275,276,277,283,373,374,375,376,377,378,379,463,464,465,466,502,503,1187,1188,1189,1190,5100,5137,5138,5139,5140,5329,5330,5331,5332,5333,39,40,52,53,54,56,57,75,55,702,703,704,705,706,792,793,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,649,1060,1061,1062,1063,1064,1066,1067,1068,95,96,98,99,100,101,102,168,169,170,172,173,174,175,176,181,188,189,190,191,192,193,194,195,291,329,330,331,332,333,334,335,336,337,339,340,341,342,343,344,350,351,352,353,505,506,507,745,746,747,748,749,750,751,752,1005,1006,1007,1008,1009,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,4232,4238,4242,4243,4244,4245,4246,4749,4755,4758,4760,4761,4762,4763,4764,4765,4766,656,657,658,659,660,661,833,863,864,865,866,495,496,504,512,513,515,756,757,794,795,800,801,802,803,804,805,5160,5161,450,451,452,453,454,455,456,457,458,459,460,461,462,467,468,469,470,796,797,798,799,1010,1011,1012,1013,2279,2280,2281,2282,4767,4768,4769,4770,5026,5027,5028,5029,5030,988,989,990,991,992,993,994,997,998,999,1000,1001,1002,1003,1004,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,727,728,729,42,60,61,62,5360,714,715,716,717,718,719,720,721,722,730,731,732,733,734,735,736,740,741,744,769,770,111,112,113,182,183,184,185,186,187,198,199,213,214,215,216,217,225,226,227,228,262,263,264,265,266,267,268,269,271,272,273,284,384,385,386,387,388,417,418,419,434,435,436,437,438,480,481,482,488,489,490,491,492,493,494,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,556,557,572,573,616,617,710,711,712,713,758,759,760,761,762,771,772,786,787,788,790,791,898,899,931,932,933,934,935,936,940,941,1026,1027,1028,5461,5431,5459,1210,1211,1212,1213,1214,5182,5187,5188,5186,5189,5190,5193,5194,5195,5196,5197,5198,5358,5359,5394,5432,5433,5434,5435,5436,5437,5438,5439,5440,5442,5443,5444,5446,5447,5448,5449,5450,5451,5452,5453,5454,5455,5456,5457,5462,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5482,5483,221,270,487,5146,5477,5430,5445,5458,5476,5460,5475,43,44,76,72,68,5336,5361,5479,242,243,244,245,246,247,248,249,250,252,257,258,259,260,261,775,1018,1019,5478,5481,776,777,779,780,781,782,783,785,834,5227,5228,5229,5230,1030,1031,1032,1033,1034,1035,1036,1037,1038,900,901,902,903,904,905,906,907,473,474,707,41,70,71,889,890,891,892,893,894,960,961,962,963,964,965,966,1170,1171,1172,1173,882,883,1174,1175,884,885,886,887,888,908,909,910,911,63,64,65,74,5101,5102,5103,5104,5105,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,408,409,410,411,412,413,414,415,416,618,619,620,621,622,624,625,626,627,628,629,630,631,632,633,880,5277,5278,5279,5280,5281,5282,406,407,472,623,634,635,725,726,5271,5272,5273,5274,5275,5276,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,66,67,366,367,368,381,382,402,403,439,440,590,591,604,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,369,370,371,372,383,389,390,391,392,393,394,395,396,397,398,399,400,401,441,442,443,444,592,593,594,595,596,597,598,599,600,601,602,603,605,606,607,608,609,59,38,613,614,995,996,5334,5335,114,115,218,219,220,222,223,224,229,230,231,233,235,520,521,558,559,560,561,563,564,567,568,1045,1046,5338,5345,5346,5347,5349,5350,5351,5352,5353,5354,5355,5357,5395,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1219,1220,1221,1222,1223,5425,5426,5427,5428,5429,5424,5423,5199,5200,5201,5202,5209,5210,5214,5203,5216,5217,5224,5215,5211,5212,5213), OR:modResource.id:IN(5286,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5313,5314,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,5418), modResource.published=1, modResource.deleted=0
0.0005422: Sorted by FIELD(`modResource`.`id`,'5250','5249','5248','5247','5251','5252','5255','5254','5253','1024','1025','1021','1023','1022','361','144','420','425','423','422','424','421','1020','294','296','293','582','197','162','84','292','589','156','950','951','952','571','868','545','2293','588','298','297','300','301','1053','1054','362','581','1078','139','299','543','1052','1050','1072','509','471','587','987','1058','946','944','1057','1055','1056','541','83','508','295','943','1075','1080','1059','158','945','817','814','819','544','2289','542','2291','1228','145','142','947','948','982','1043','1042','1041','1044','1049','949','806','5422','161','159','157','637','737','818','816','583','5283','5404','5405','5403','5401','5399','5400','5406','5407','5412','5413','5414','5411','5410','5408','5409','5398','5402','5389','5396','5397','1176','1180','1179','843','815','1177','1178','143','154','151','639','153','636','160','152','1040','1039','1017','4248','641','644','640','1016','1047','645','836','838','205','146','5099','5192','105','147','148','150','149','155','1209','638','841','570','807','518','519','447','968','970','971','1184','1186','1183','1185','840','359','844','837','839','820','825','724','4753','826','1216','5034','107','108','821','106','104','103','109','110','5331','5098','5330','5329','46','5236','646','5239','1076','1239','2294','5238','1074','1077','1113','5480','1182','1181','167','165','855','2284','823','824','610','580','430','822','5136','953','611','612','723','2299','861','773','1069','1070','981','978','973','977','1232','1225','980','976','983','979','975','974','5244','972','1236','985','5235','5245','1015','5234','355','5240','5418','5243','5242','5241','5420','984','5233','986','354','5246','5232','1014','498','5191','4754','4752','90','47','5142','5141','4757','4756','854','1208','5381','5382','5383','280','860','2285','5221','4750','281','2288','5380','2287','2290','5231','2295','2292','363','5108','50','849','847','851','201','49','497','45','499','4751','48','4748','358','356','869','5481','282','279','89','166','501','858','930','875','842','827','429','163','82','2286','576','831','511','248','357','5219','575','828','1073','5229','5230','9','51','829','373','5333','374','283','871','845','846','252','850','377','378','379','375','5332','872','859','1','830','500','857','856','376','5388','5387','5227','5391','5392','274','5390','5393','5386','5367','5415','5362','5363','5366','5364','5368','5369','5384','5385','5416','5417','5419','5370','5365','5228','5373','5374','5375','5376','5372','5371','276','5111','275','4230','5144','5112','4249','277','4250','4252','643','4251','5377','5378','5379','1188','1187','4231','1189','1190','219','245','246','5137','5140','5139','5138','249','242','5100','1018','1019','5036','244','5215','775','5226','259','923','1112','926','1118','465','1105','463','835','464','4','69','5395'), 
0.0000110: Limited to 10, offset 
0.0008202: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, `intro`, 120x90.thumb as 120x90 FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_mse2_intro` `Intro` ON `modResource`.`id`=`Intro`.`resource` LEFT JOIN `modx_ms2_product_files` `120x90` ON modResource.id = 120х90.id WHERE  ( `modResource`.`id` IN (5250,5249,5248,5247,5251,5252,5255,5254,5253,1024,1025,1021,1023,1022,361,144,420,425,423,422,424,421,1020,294,296,293,582,197,162,84,292,589,156,950,951,952,571,868,545,2293,588,298,297,300,301,1053,1054,362,581,1078,139,299,543,1052,1050,1072,509,471,587,987,1058,946,944,1057,1055,1056,541,83,508,295,943,1075,1080,1059,158,945,817,814,819,544,2289,542,2291,1228,145,142,947,948,982,1043,1042,1041,1044,1049,949,806,5422,161,159,157,637,737,818,816,583,5283,5404,5405,5403,5401,5399,5400,5406,5407,5412,5413,5414,5411,5410,5408,5409,5398,5402,5389,5396,5397,1176,1180,1179,843,815,1177,1178,143,154,151,639,153,636,160,152,1040,1039,1017,4248,641,644,640,1016,1047,645,836,838,205,146,5099,5192,105,147,148,150,149,155,1209,638,841,570,807,518,519,447,968,970,971,1184,1186,1183,1185,840,359,844,837,839,820,825,724,4753,826,1216,5034,107,108,821,106,104,103,109,110,5331,5098,5330,5329,46,5236,646,5239,1076,1239,2294,5238,1074,1077,1113,5480,1182,1181,167,165,855,2284,823,824,610,580,430,822,5136,953,611,612,723,2299,861,773,1069,1070,981,978,973,977,1232,1225,980,976,983,979,975,974,5244,972,1236,985,5235,5245,1015,5234,355,5240,5418,5243,5242,5241,5420,984,5233,986,354,5246,5232,1014,498,5191,4754,4752,90,47,5142,5141,4757,4756,854,1208,5381,5382,5383,280,860,2285,5221,4750,281,2288,5380,2287,2290,5231,2295,2292,363,5108,50,849,847,851,201,49,497,45,499,4751,48,4748,358,356,869,5481,282,279,89,166,501,858,930,875,842,827,429,163,82,2286,576,831,511,248,357,5219,575,828,1073,5229,5230,9,51,829,373,5333,374,283,871,845,846,252,850,377,378,379,375,5332,872,859,1,830,500,857,856,376,5388,5387,5227,5391,5392,274,5390,5393,5386,5367,5415,5362,5363,5366,5364,5368,5369,5384,5385,5416,5417,5419,5370,5365,5228,5373,5374,5375,5376,5372,5371,276,5111,275,4230,5144,5112,4249,277,4250,4252,643,4251,5377,5378,5379,1188,1187,4231,1189,1190,219,245,246,5137,5140,5139,5138,249,242,5100,1018,1019,5036,244,5215,775,5226,259,923,1112,926,1118,465,1105,463,835,464,4,69,5395) AND  ( `modResource`.`parent` IN (4,8,9,13,10,16,14,12,11,58,15,1139,1218,1234,1232,1237,1238,5112,17,18,19,5337,20,21,5022,79,80,81,85,86,87,88,97,117,118,119,120,121,122,123,124,125,127,128,130,131,132,134,135,136,137,138,380,433,516,517,522,548,549,550,551,552,553,554,555,867,876,877,895,954,955,1029,1205,1126,1129,1130,2297,4234,4235,5021,5205,5206,5207,5208,232,234,236,237,238,239,240,241,431,432,448,449,577,578,579,584,585,586,763,764,765,766,767,768,1200,1201,1203,1204,1206,1207,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5284,5313,5285,5314,5286,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,547,1131,1133,1134,1135,5113,5114,5115,5116,5117,5118,5119,959,896,897,5023,5024,5031,5032,5033,45,46,47,48,49,50,51,69,5120,103,104,105,106,107,108,109,110,163,165,166,167,279,280,281,282,420,421,422,423,424,425,429,430,497,498,499,500,501,508,509,580,581,582,583,640,641,644,645,646,773,943,944,945,946,947,948,949,950,951,952,1014,1015,1016,1017,4748,4750,4751,4752,4753,4754,4756,4757,5108,5191,5192,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5381,5382,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5419,5422,82,83,84,89,90,139,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,197,201,205,447,471,570,571,575,576,610,611,612,723,724,737,836,837,838,839,840,841,842,843,844,845,846,847,849,850,851,868,869,871,872,875,930,953,968,970,971,1039,1040,1041,1042,1043,1044,1047,1049,1050,1052,1053,1054,1055,1056,1057,1058,1069,1070,1072,1073,1074,1075,1076,1077,1078,1080,1208,2284,2285,1176,2286,2288,2287,2289,2290,2291,2292,2294,2299,4249,4250,4251,4252,5034,5098,5136,5141,5142,5231,5232,5233,5234,5235,5236,5238,5239,5240,5241,5242,5243,5244,5245,5246,292,293,294,295,296,297,298,299,300,301,518,519,541,542,543,544,545,822,823,824,825,826,827,828,829,830,831,835,1020,1021,1022,1023,1024,1025,1059,1209,1224,1225,354,355,356,357,358,359,361,362,363,511,5247,5248,5249,5250,5251,5252,5253,5254,5255,587,588,589,643,806,807,814,815,816,817,818,819,820,821,854,855,856,857,858,859,860,861,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,4248,1183,1184,1185,1186,987,5420,5418,636,637,638,639,1177,1178,1179,1180,1181,1182,5099,5480,274,275,276,277,283,373,374,375,376,377,378,379,463,464,465,466,502,503,1187,1188,1189,1190,5100,5137,5138,5139,5140,5329,5330,5331,5332,5333,39,40,52,53,54,56,57,75,55,702,703,704,705,706,792,793,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,649,1060,1061,1062,1063,1064,1066,1067,1068,95,96,98,99,100,101,102,168,169,170,172,173,174,175,176,181,188,189,190,191,192,193,194,195,291,329,330,331,332,333,334,335,336,337,339,340,341,342,343,344,350,351,352,353,505,506,507,745,746,747,748,749,750,751,752,1005,1006,1007,1008,1009,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,4232,4238,4242,4243,4244,4245,4246,4749,4755,4758,4760,4761,4762,4763,4764,4765,4766,656,657,658,659,660,661,833,863,864,865,866,495,496,504,512,513,515,756,757,794,795,800,801,802,803,804,805,5160,5161,450,451,452,453,454,455,456,457,458,459,460,461,462,467,468,469,470,796,797,798,799,1010,1011,1012,1013,2279,2280,2281,2282,4767,4768,4769,4770,5026,5027,5028,5029,5030,988,989,990,991,992,993,994,997,998,999,1000,1001,1002,1003,1004,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,727,728,729,42,60,61,62,5360,714,715,716,717,718,719,720,721,722,730,731,732,733,734,735,736,740,741,744,769,770,111,112,113,182,183,184,185,186,187,198,199,213,214,215,216,217,225,226,227,228,262,263,264,265,266,267,268,269,271,272,273,284,384,385,386,387,388,417,418,419,434,435,436,437,438,480,481,482,488,489,490,491,492,493,494,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,556,557,572,573,616,617,710,711,712,713,758,759,760,761,762,771,772,786,787,788,790,791,898,899,931,932,933,934,935,936,940,941,1026,1027,1028,5461,5431,5459,1210,1211,1212,1213,1214,5182,5187,5188,5186,5189,5190,5193,5194,5195,5196,5197,5198,5358,5359,5394,5432,5433,5434,5435,5436,5437,5438,5439,5440,5442,5443,5444,5446,5447,5448,5449,5450,5451,5452,5453,5454,5455,5456,5457,5462,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5482,5483,221,270,487,5146,5477,5430,5445,5458,5476,5460,5475,43,44,76,72,68,5336,5361,5479,242,243,244,245,246,247,248,249,250,252,257,258,259,260,261,775,1018,1019,5478,5481,776,777,779,780,781,782,783,785,834,5227,5228,5229,5230,1030,1031,1032,1033,1034,1035,1036,1037,1038,900,901,902,903,904,905,906,907,473,474,707,41,70,71,889,890,891,892,893,894,960,961,962,963,964,965,966,1170,1171,1172,1173,882,883,1174,1175,884,885,886,887,888,908,909,910,911,63,64,65,74,5101,5102,5103,5104,5105,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,408,409,410,411,412,413,414,415,416,618,619,620,621,622,624,625,626,627,628,629,630,631,632,633,880,5277,5278,5279,5280,5281,5282,406,407,472,623,634,635,725,726,5271,5272,5273,5274,5275,5276,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,66,67,366,367,368,381,382,402,403,439,440,590,591,604,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,369,370,371,372,383,389,390,391,392,393,394,395,396,397,398,399,400,401,441,442,443,444,592,593,594,595,596,597,598,599,600,601,602,603,605,606,607,608,609,59,38,613,614,995,996,5334,5335,114,115,218,219,220,222,223,224,229,230,231,233,235,520,521,558,559,560,561,563,564,567,568,1045,1046,5338,5345,5346,5347,5349,5350,5351,5352,5353,5354,5355,5357,5395,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1219,1220,1221,1222,1223,5425,5426,5427,5428,5429,5424,5423,5199,5200,5201,5202,5209,5210,5214,5203,5216,5217,5224,5215,5211,5212,5213) OR `modResource`.`id` IN (5286,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5313,5314,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,5418) )  AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 )  GROUP BY modResource.id ORDER BY FIELD(`modResource`.`id`,'5250','5249','5248','5247','5251','5252','5255','5254','5253','1024','1025','1021','1023','1022','361','144','420','425','423','422','424','421','1020','294','296','293','582','197','162','84','292','589','156','950','951','952','571','868','545','2293','588','298','297','300','301','1053','1054','362','581','1078','139','299','543','1052','1050','1072','509','471','587','987','1058','946','944','1057','1055','1056','541','83','508','295','943','1075','1080','1059','158','945','817','814','819','544','2289','542','2291','1228','145','142','947','948','982','1043','1042','1041','1044','1049','949','806','5422','161','159','157','637','737','818','816','583','5283','5404','5405','5403','5401','5399','5400','5406','5407','5412','5413','5414','5411','5410','5408','5409','5398','5402','5389','5396','5397','1176','1180','1179','843','815','1177','1178','143','154','151','639','153','636','160','152','1040','1039','1017','4248','641','644','640','1016','1047','645','836','838','205','146','5099','5192','105','147','148','150','149','155','1209','638','841','570','807','518','519','447','968','970','971','1184','1186','1183','1185','840','359','844','837','839','820','825','724','4753','826','1216','5034','107','108','821','106','104','103','109','110','5331','5098','5330','5329','46','5236','646','5239','1076','1239','2294','5238','1074','1077','1113','5480','1182','1181','167','165','855','2284','823','824','610','580','430','822','5136','953','611','612','723','2299','861','773','1069','1070','981','978','973','977','1232','1225','980','976','983','979','975','974','5244','972','1236','985','5235','5245','1015','5234','355','5240','5418','5243','5242','5241','5420','984','5233','986','354','5246','5232','1014','498','5191','4754','4752','90','47','5142','5141','4757','4756','854','1208','5381','5382','5383','280','860','2285','5221','4750','281','2288','5380','2287','2290','5231','2295','2292','363','5108','50','849','847','851','201','49','497','45','499','4751','48','4748','358','356','869','5481','282','279','89','166','501','858','930','875','842','827','429','163','82','2286','576','831','511','248','357','5219','575','828','1073','5229','5230','9','51','829','373','5333','374','283','871','845','846','252','850','377','378','379','375','5332','872','859','1','830','500','857','856','376','5388','5387','5227','5391','5392','274','5390','5393','5386','5367','5415','5362','5363','5366','5364','5368','5369','5384','5385','5416','5417','5419','5370','5365','5228','5373','5374','5375','5376','5372','5371','276','5111','275','4230','5144','5112','4249','277','4250','4252','643','4251','5377','5378','5379','1188','1187','4231','1189','1190','219','245','246','5137','5140','5139','5138','249','242','5100','1018','1019','5036','244','5215','775','5226','259','923','1112','926','1118','465','1105','463','835','464','4','69','5395') LIMIT 10 "
0.0084169: Could not process query, error #1054: Unknown column '120x90.thumb' in 'field list'
0.0803649: Total time
17 563 648: Memory usage

[[!pdoPage?
    &parents=`4`
    &element=`mSearch2`
    &leftJoin=`{
		"120x90": {
			"class": "msProductFile",
			"on": "modResource.id = 120x90.id"
		 }
    }`
	&select=`{
		"modResource": "*",
		"120x90": "thumb as 120x90"
	}`
    &includeMS=`1`
    &processTVs=`1`
	&tpl=``
	&showLog=`1`
]]

Опачки, вот что выдало:

0.0169799: Query parameters are prepared.
0.0000820: xPDO query object created
0.0011160: leftJoined mseIntro as Intro
0.0024970: leftJoined msProductFile as 120x90
0.0000091: Grouped by modResource.id
0.0007021: Added selection of modResource: SQL_CALC_FOUND_ROWS `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.0000422: Added selection of mseIntro: intro
0.0000379: Added selection of msProductFile: thumb as 120x90
0.0376561: Processed additional conditions
0.0419400: Added where condition: modResource.id:IN(5250,5249,5248,5247,5251,5252,5255,5254,5253,1024,1025,1021,1023,1022,361,144,420,425,423,422,424,421,1020,294,296,293,582,197,162,84,292,589,156,950,951,952,571,868,545,2293,588,298,297,300,301,1053,1054,362,581,1078,139,299,543,1052,1050,1072,509,471,587,987,1058,946,944,1057,1055,1056,541,83,508,295,943,1075,1080,1059,158,945,817,814,819,544,2289,542,2291,1228,145,142,947,948,982,1043,1042,1041,1044,1049,949,806,5422,161,159,157,637,737,818,816,583,5283,5404,5405,5403,5401,5399,5400,5406,5407,5412,5413,5414,5411,5410,5408,5409,5398,5402,5389,5396,5397,1176,1180,1179,843,815,1177,1178,143,154,151,639,153,636,160,152,1040,1039,1017,4248,641,644,640,1016,1047,645,836,838,205,146,5099,5192,105,147,148,150,149,155,1209,638,841,570,807,518,519,447,968,970,971,1184,1186,1183,1185,840,359,844,837,839,820,825,724,4753,826,1216,5034,107,108,821,106,104,103,109,110,5331,5098,5330,5329,46,5236,646,5239,1076,1239,2294,5238,1074,1077,1113,5480,1182,1181,167,165,855,2284,823,824,610,580,430,822,5136,953,611,612,723,2299,861,773,1069,1070,981,978,973,977,1232,1225,980,976,983,979,975,974,5244,972,1236,985,5235,5245,1015,5234,355,5240,5418,5243,5242,5241,5420,984,5233,986,354,5246,5232,1014,498,5191,4754,4752,90,47,5142,5141,4757,4756,854,1208,5381,5382,5383,280,860,2285,5221,4750,281,2288,5380,2287,2290,5231,2295,2292,363,5108,50,849,847,851,201,49,497,45,499,4751,48,4748,358,356,869,5481,282,279,89,166,501,858,930,875,842,827,429,163,82,2286,576,831,511,248,357,5219,575,828,1073,5229,5230,9,51,829,373,5333,374,283,871,845,846,252,850,377,378,379,375,5332,872,859,1,830,500,857,856,376,5388,5387,5227,5391,5392,274,5390,5393,5386,5367,5415,5362,5363,5366,5364,5368,5369,5384,5385,5416,5417,5419,5370,5365,5228,5373,5374,5375,5376,5372,5371,276,5111,275,4230,5144,5112,4249,277,4250,4252,643,4251,5377,5378,5379,1188,1187,4231,1189,1190,219,245,246,5137,5140,5139,5138,249,242,5100,1018,1019,5036,244,5215,775,5226,259,923,1112,926,1118,465,1105,463,835,464,4,69,5395), modResource.parent:IN(4,8,9,13,10,16,14,12,11,58,15,1139,1218,1234,1232,1237,1238,5112,17,18,19,5337,20,21,5022,79,80,81,85,86,87,88,97,117,118,119,120,121,122,123,124,125,127,128,130,131,132,134,135,136,137,138,380,433,516,517,522,548,549,550,551,552,553,554,555,867,876,877,895,954,955,1029,1205,1126,1129,1130,2297,4234,4235,5021,5205,5206,5207,5208,232,234,236,237,238,239,240,241,431,432,448,449,577,578,579,584,585,586,763,764,765,766,767,768,1200,1201,1203,1204,1206,1207,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5284,5313,5285,5314,5286,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,547,1131,1133,1134,1135,5113,5114,5115,5116,5117,5118,5119,959,896,897,5023,5024,5031,5032,5033,45,46,47,48,49,50,51,69,5120,103,104,105,106,107,108,109,110,163,165,166,167,279,280,281,282,420,421,422,423,424,425,429,430,497,498,499,500,501,508,509,580,581,582,583,640,641,644,645,646,773,943,944,945,946,947,948,949,950,951,952,1014,1015,1016,1017,4748,4750,4751,4752,4753,4754,4756,4757,5108,5191,5192,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5381,5382,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5419,5422,82,83,84,89,90,139,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,197,201,205,447,471,570,571,575,576,610,611,612,723,724,737,836,837,838,839,840,841,842,843,844,845,846,847,849,850,851,868,869,871,872,875,930,953,968,970,971,1039,1040,1041,1042,1043,1044,1047,1049,1050,1052,1053,1054,1055,1056,1057,1058,1069,1070,1072,1073,1074,1075,1076,1077,1078,1080,1208,2284,2285,1176,2286,2288,2287,2289,2290,2291,2292,2294,2299,4249,4250,4251,4252,5034,5098,5136,5141,5142,5231,5232,5233,5234,5235,5236,5238,5239,5240,5241,5242,5243,5244,5245,5246,292,293,294,295,296,297,298,299,300,301,518,519,541,542,543,544,545,822,823,824,825,826,827,828,829,830,831,835,1020,1021,1022,1023,1024,1025,1059,1209,1224,1225,354,355,356,357,358,359,361,362,363,511,5247,5248,5249,5250,5251,5252,5253,5254,5255,587,588,589,643,806,807,814,815,816,817,818,819,820,821,854,855,856,857,858,859,860,861,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,4248,1183,1184,1185,1186,987,5420,5418,636,637,638,639,1177,1178,1179,1180,1181,1182,5099,5480,274,275,276,277,283,373,374,375,376,377,378,379,463,464,465,466,502,503,1187,1188,1189,1190,5100,5137,5138,5139,5140,5329,5330,5331,5332,5333,39,40,52,53,54,56,57,75,55,702,703,704,705,706,792,793,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,649,1060,1061,1062,1063,1064,1066,1067,1068,95,96,98,99,100,101,102,168,169,170,172,173,174,175,176,181,188,189,190,191,192,193,194,195,291,329,330,331,332,333,334,335,336,337,339,340,341,342,343,344,350,351,352,353,505,506,507,745,746,747,748,749,750,751,752,1005,1006,1007,1008,1009,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,4232,4238,4242,4243,4244,4245,4246,4749,4755,4758,4760,4761,4762,4763,4764,4765,4766,656,657,658,659,660,661,833,863,864,865,866,495,496,504,512,513,515,756,757,794,795,800,801,802,803,804,805,5160,5161,450,451,452,453,454,455,456,457,458,459,460,461,462,467,468,469,470,796,797,798,799,1010,1011,1012,1013,2279,2280,2281,2282,4767,4768,4769,4770,5026,5027,5028,5029,5030,988,989,990,991,992,993,994,997,998,999,1000,1001,1002,1003,1004,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,727,728,729,42,60,61,62,5360,714,715,716,717,718,719,720,721,722,730,731,732,733,734,735,736,740,741,744,769,770,111,112,113,182,183,184,185,186,187,198,199,213,214,215,216,217,225,226,227,228,262,263,264,265,266,267,268,269,271,272,273,284,384,385,386,387,388,417,418,419,434,435,436,437,438,480,481,482,488,489,490,491,492,493,494,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,556,557,572,573,616,617,710,711,712,713,758,759,760,761,762,771,772,786,787,788,790,791,898,899,931,932,933,934,935,936,940,941,1026,1027,1028,5461,5431,5459,1210,1211,1212,1213,1214,5182,5187,5188,5186,5189,5190,5193,5194,5195,5196,5197,5198,5358,5359,5394,5432,5433,5434,5435,5436,5437,5438,5439,5440,5442,5443,5444,5446,5447,5448,5449,5450,5451,5452,5453,5454,5455,5456,5457,5462,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5482,5483,221,270,487,5146,5477,5430,5445,5458,5476,5460,5475,43,44,76,72,68,5336,5361,5479,242,243,244,245,246,247,248,249,250,252,257,258,259,260,261,775,1018,1019,5478,5481,776,777,779,780,781,782,783,785,834,5227,5228,5229,5230,1030,1031,1032,1033,1034,1035,1036,1037,1038,900,901,902,903,904,905,906,907,473,474,707,41,70,71,889,890,891,892,893,894,960,961,962,963,964,965,966,1170,1171,1172,1173,882,883,1174,1175,884,885,886,887,888,908,909,910,911,63,64,65,74,5101,5102,5103,5104,5105,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,408,409,410,411,412,413,414,415,416,618,619,620,621,622,624,625,626,627,628,629,630,631,632,633,880,5277,5278,5279,5280,5281,5282,406,407,472,623,634,635,725,726,5271,5272,5273,5274,5275,5276,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,66,67,366,367,368,381,382,402,403,439,440,590,591,604,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,369,370,371,372,383,389,390,391,392,393,394,395,396,397,398,399,400,401,441,442,443,444,592,593,594,595,596,597,598,599,600,601,602,603,605,606,607,608,609,59,38,613,614,995,996,5334,5335,114,115,218,219,220,222,223,224,229,230,231,233,235,520,521,558,559,560,561,563,564,567,568,1045,1046,5338,5345,5346,5347,5349,5350,5351,5352,5353,5354,5355,5357,5395,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1219,1220,1221,1222,1223,5425,5426,5427,5428,5429,5424,5423,5199,5200,5201,5202,5209,5210,5214,5203,5216,5217,5224,5215,5211,5212,5213), OR:modResource.id:IN(5286,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5313,5314,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,5418), modResource.published=1, modResource.deleted=0
0.0005391: Sorted by FIELD(`modResource`.`id`,'5250','5249','5248','5247','5251','5252','5255','5254','5253','1024','1025','1021','1023','1022','361','144','420','425','423','422','424','421','1020','294','296','293','582','197','162','84','292','589','156','950','951','952','571','868','545','2293','588','298','297','300','301','1053','1054','362','581','1078','139','299','543','1052','1050','1072','509','471','587','987','1058','946','944','1057','1055','1056','541','83','508','295','943','1075','1080','1059','158','945','817','814','819','544','2289','542','2291','1228','145','142','947','948','982','1043','1042','1041','1044','1049','949','806','5422','161','159','157','637','737','818','816','583','5283','5404','5405','5403','5401','5399','5400','5406','5407','5412','5413','5414','5411','5410','5408','5409','5398','5402','5389','5396','5397','1176','1180','1179','843','815','1177','1178','143','154','151','639','153','636','160','152','1040','1039','1017','4248','641','644','640','1016','1047','645','836','838','205','146','5099','5192','105','147','148','150','149','155','1209','638','841','570','807','518','519','447','968','970','971','1184','1186','1183','1185','840','359','844','837','839','820','825','724','4753','826','1216','5034','107','108','821','106','104','103','109','110','5331','5098','5330','5329','46','5236','646','5239','1076','1239','2294','5238','1074','1077','1113','5480','1182','1181','167','165','855','2284','823','824','610','580','430','822','5136','953','611','612','723','2299','861','773','1069','1070','981','978','973','977','1232','1225','980','976','983','979','975','974','5244','972','1236','985','5235','5245','1015','5234','355','5240','5418','5243','5242','5241','5420','984','5233','986','354','5246','5232','1014','498','5191','4754','4752','90','47','5142','5141','4757','4756','854','1208','5381','5382','5383','280','860','2285','5221','4750','281','2288','5380','2287','2290','5231','2295','2292','363','5108','50','849','847','851','201','49','497','45','499','4751','48','4748','358','356','869','5481','282','279','89','166','501','858','930','875','842','827','429','163','82','2286','576','831','511','248','357','5219','575','828','1073','5229','5230','9','51','829','373','5333','374','283','871','845','846','252','850','377','378','379','375','5332','872','859','1','830','500','857','856','376','5388','5387','5227','5391','5392','274','5390','5393','5386','5367','5415','5362','5363','5366','5364','5368','5369','5384','5385','5416','5417','5419','5370','5365','5228','5373','5374','5375','5376','5372','5371','276','5111','275','4230','5144','5112','4249','277','4250','4252','643','4251','5377','5378','5379','1188','1187','4231','1189','1190','219','245','246','5137','5140','5139','5138','249','242','5100','1018','1019','5036','244','5215','775','5226','259','923','1112','926','1118','465','1105','463','835','464','4','69','5395'), 
0.0000119: Limited to 10, offset 
0.0017400: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, `intro`, thumb as 120x90 FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_mse2_intro` `Intro` ON `modResource`.`id`=`Intro`.`resource` LEFT JOIN `modx_ms2_product_files` `120x90` ON modResource.id = 120x90.id WHERE  ( `modResource`.`id` IN (5250,5249,5248,5247,5251,5252,5255,5254,5253,1024,1025,1021,1023,1022,361,144,420,425,423,422,424,421,1020,294,296,293,582,197,162,84,292,589,156,950,951,952,571,868,545,2293,588,298,297,300,301,1053,1054,362,581,1078,139,299,543,1052,1050,1072,509,471,587,987,1058,946,944,1057,1055,1056,541,83,508,295,943,1075,1080,1059,158,945,817,814,819,544,2289,542,2291,1228,145,142,947,948,982,1043,1042,1041,1044,1049,949,806,5422,161,159,157,637,737,818,816,583,5283,5404,5405,5403,5401,5399,5400,5406,5407,5412,5413,5414,5411,5410,5408,5409,5398,5402,5389,5396,5397,1176,1180,1179,843,815,1177,1178,143,154,151,639,153,636,160,152,1040,1039,1017,4248,641,644,640,1016,1047,645,836,838,205,146,5099,5192,105,147,148,150,149,155,1209,638,841,570,807,518,519,447,968,970,971,1184,1186,1183,1185,840,359,844,837,839,820,825,724,4753,826,1216,5034,107,108,821,106,104,103,109,110,5331,5098,5330,5329,46,5236,646,5239,1076,1239,2294,5238,1074,1077,1113,5480,1182,1181,167,165,855,2284,823,824,610,580,430,822,5136,953,611,612,723,2299,861,773,1069,1070,981,978,973,977,1232,1225,980,976,983,979,975,974,5244,972,1236,985,5235,5245,1015,5234,355,5240,5418,5243,5242,5241,5420,984,5233,986,354,5246,5232,1014,498,5191,4754,4752,90,47,5142,5141,4757,4756,854,1208,5381,5382,5383,280,860,2285,5221,4750,281,2288,5380,2287,2290,5231,2295,2292,363,5108,50,849,847,851,201,49,497,45,499,4751,48,4748,358,356,869,5481,282,279,89,166,501,858,930,875,842,827,429,163,82,2286,576,831,511,248,357,5219,575,828,1073,5229,5230,9,51,829,373,5333,374,283,871,845,846,252,850,377,378,379,375,5332,872,859,1,830,500,857,856,376,5388,5387,5227,5391,5392,274,5390,5393,5386,5367,5415,5362,5363,5366,5364,5368,5369,5384,5385,5416,5417,5419,5370,5365,5228,5373,5374,5375,5376,5372,5371,276,5111,275,4230,5144,5112,4249,277,4250,4252,643,4251,5377,5378,5379,1188,1187,4231,1189,1190,219,245,246,5137,5140,5139,5138,249,242,5100,1018,1019,5036,244,5215,775,5226,259,923,1112,926,1118,465,1105,463,835,464,4,69,5395) AND  ( `modResource`.`parent` IN (4,8,9,13,10,16,14,12,11,58,15,1139,1218,1234,1232,1237,1238,5112,17,18,19,5337,20,21,5022,79,80,81,85,86,87,88,97,117,118,119,120,121,122,123,124,125,127,128,130,131,132,134,135,136,137,138,380,433,516,517,522,548,549,550,551,552,553,554,555,867,876,877,895,954,955,1029,1205,1126,1129,1130,2297,4234,4235,5021,5205,5206,5207,5208,232,234,236,237,238,239,240,241,431,432,448,449,577,578,579,584,585,586,763,764,765,766,767,768,1200,1201,1203,1204,1206,1207,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5284,5313,5285,5314,5286,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,547,1131,1133,1134,1135,5113,5114,5115,5116,5117,5118,5119,959,896,897,5023,5024,5031,5032,5033,45,46,47,48,49,50,51,69,5120,103,104,105,106,107,108,109,110,163,165,166,167,279,280,281,282,420,421,422,423,424,425,429,430,497,498,499,500,501,508,509,580,581,582,583,640,641,644,645,646,773,943,944,945,946,947,948,949,950,951,952,1014,1015,1016,1017,4748,4750,4751,4752,4753,4754,4756,4757,5108,5191,5192,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5381,5382,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5419,5422,82,83,84,89,90,139,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,197,201,205,447,471,570,571,575,576,610,611,612,723,724,737,836,837,838,839,840,841,842,843,844,845,846,847,849,850,851,868,869,871,872,875,930,953,968,970,971,1039,1040,1041,1042,1043,1044,1047,1049,1050,1052,1053,1054,1055,1056,1057,1058,1069,1070,1072,1073,1074,1075,1076,1077,1078,1080,1208,2284,2285,1176,2286,2288,2287,2289,2290,2291,2292,2294,2299,4249,4250,4251,4252,5034,5098,5136,5141,5142,5231,5232,5233,5234,5235,5236,5238,5239,5240,5241,5242,5243,5244,5245,5246,292,293,294,295,296,297,298,299,300,301,518,519,541,542,543,544,545,822,823,824,825,826,827,828,829,830,831,835,1020,1021,1022,1023,1024,1025,1059,1209,1224,1225,354,355,356,357,358,359,361,362,363,511,5247,5248,5249,5250,5251,5252,5253,5254,5255,587,588,589,643,806,807,814,815,816,817,818,819,820,821,854,855,856,857,858,859,860,861,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,4248,1183,1184,1185,1186,987,5420,5418,636,637,638,639,1177,1178,1179,1180,1181,1182,5099,5480,274,275,276,277,283,373,374,375,376,377,378,379,463,464,465,466,502,503,1187,1188,1189,1190,5100,5137,5138,5139,5140,5329,5330,5331,5332,5333,39,40,52,53,54,56,57,75,55,702,703,704,705,706,792,793,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,649,1060,1061,1062,1063,1064,1066,1067,1068,95,96,98,99,100,101,102,168,169,170,172,173,174,175,176,181,188,189,190,191,192,193,194,195,291,329,330,331,332,333,334,335,336,337,339,340,341,342,343,344,350,351,352,353,505,506,507,745,746,747,748,749,750,751,752,1005,1006,1007,1008,1009,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,4232,4238,4242,4243,4244,4245,4246,4749,4755,4758,4760,4761,4762,4763,4764,4765,4766,656,657,658,659,660,661,833,863,864,865,866,495,496,504,512,513,515,756,757,794,795,800,801,802,803,804,805,5160,5161,450,451,452,453,454,455,456,457,458,459,460,461,462,467,468,469,470,796,797,798,799,1010,1011,1012,1013,2279,2280,2281,2282,4767,4768,4769,4770,5026,5027,5028,5029,5030,988,989,990,991,992,993,994,997,998,999,1000,1001,1002,1003,1004,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,727,728,729,42,60,61,62,5360,714,715,716,717,718,719,720,721,722,730,731,732,733,734,735,736,740,741,744,769,770,111,112,113,182,183,184,185,186,187,198,199,213,214,215,216,217,225,226,227,228,262,263,264,265,266,267,268,269,271,272,273,284,384,385,386,387,388,417,418,419,434,435,436,437,438,480,481,482,488,489,490,491,492,493,494,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,556,557,572,573,616,617,710,711,712,713,758,759,760,761,762,771,772,786,787,788,790,791,898,899,931,932,933,934,935,936,940,941,1026,1027,1028,5461,5431,5459,1210,1211,1212,1213,1214,5182,5187,5188,5186,5189,5190,5193,5194,5195,5196,5197,5198,5358,5359,5394,5432,5433,5434,5435,5436,5437,5438,5439,5440,5442,5443,5444,5446,5447,5448,5449,5450,5451,5452,5453,5454,5455,5456,5457,5462,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5482,5483,221,270,487,5146,5477,5430,5445,5458,5476,5460,5475,43,44,76,72,68,5336,5361,5479,242,243,244,245,246,247,248,249,250,252,257,258,259,260,261,775,1018,1019,5478,5481,776,777,779,780,781,782,783,785,834,5227,5228,5229,5230,1030,1031,1032,1033,1034,1035,1036,1037,1038,900,901,902,903,904,905,906,907,473,474,707,41,70,71,889,890,891,892,893,894,960,961,962,963,964,965,966,1170,1171,1172,1173,882,883,1174,1175,884,885,886,887,888,908,909,910,911,63,64,65,74,5101,5102,5103,5104,5105,5256,5257,5258,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,408,409,410,411,412,413,414,415,416,618,619,620,621,622,624,625,626,627,628,629,630,631,632,633,880,5277,5278,5279,5280,5281,5282,406,407,472,623,634,635,725,726,5271,5272,5273,5274,5275,5276,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,66,67,366,367,368,381,382,402,403,439,440,590,591,604,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,369,370,371,372,383,389,390,391,392,393,394,395,396,397,398,399,400,401,441,442,443,444,592,593,594,595,596,597,598,599,600,601,602,603,605,606,607,608,609,59,38,613,614,995,996,5334,5335,114,115,218,219,220,222,223,224,229,230,231,233,235,520,521,558,559,560,561,563,564,567,568,1045,1046,5338,5345,5346,5347,5349,5350,5351,5352,5353,5354,5355,5357,5395,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1219,1220,1221,1222,1223,5425,5426,5427,5428,5429,5424,5423,5199,5200,5201,5202,5209,5210,5214,5203,5216,5217,5224,5215,5211,5212,5213) OR `modResource`.`id` IN (5286,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,5312,5313,5314,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,5418) )  AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 )  GROUP BY modResource.id ORDER BY FIELD(`modResource`.`id`,'5250','5249','5248','5247','5251','5252','5255','5254','5253','1024','1025','1021','1023','1022','361','144','420','425','423','422','424','421','1020','294','296','293','582','197','162','84','292','589','156','950','951','952','571','868','545','2293','588','298','297','300','301','1053','1054','362','581','1078','139','299','543','1052','1050','1072','509','471','587','987','1058','946','944','1057','1055','1056','541','83','508','295','943','1075','1080','1059','158','945','817','814','819','544','2289','542','2291','1228','145','142','947','948','982','1043','1042','1041','1044','1049','949','806','5422','161','159','157','637','737','818','816','583','5283','5404','5405','5403','5401','5399','5400','5406','5407','5412','5413','5414','5411','5410','5408','5409','5398','5402','5389','5396','5397','1176','1180','1179','843','815','1177','1178','143','154','151','639','153','636','160','152','1040','1039','1017','4248','641','644','640','1016','1047','645','836','838','205','146','5099','5192','105','147','148','150','149','155','1209','638','841','570','807','518','519','447','968','970','971','1184','1186','1183','1185','840','359','844','837','839','820','825','724','4753','826','1216','5034','107','108','821','106','104','103','109','110','5331','5098','5330','5329','46','5236','646','5239','1076','1239','2294','5238','1074','1077','1113','5480','1182','1181','167','165','855','2284','823','824','610','580','430','822','5136','953','611','612','723','2299','861','773','1069','1070','981','978','973','977','1232','1225','980','976','983','979','975','974','5244','972','1236','985','5235','5245','1015','5234','355','5240','5418','5243','5242','5241','5420','984','5233','986','354','5246','5232','1014','498','5191','4754','4752','90','47','5142','5141','4757','4756','854','1208','5381','5382','5383','280','860','2285','5221','4750','281','2288','5380','2287','2290','5231','2295','2292','363','5108','50','849','847','851','201','49','497','45','499','4751','48','4748','358','356','869','5481','282','279','89','166','501','858','930','875','842','827','429','163','82','2286','576','831','511','248','357','5219','575','828','1073','5229','5230','9','51','829','373','5333','374','283','871','845','846','252','850','377','378','379','375','5332','872','859','1','830','500','857','856','376','5388','5387','5227','5391','5392','274','5390','5393','5386','5367','5415','5362','5363','5366','5364','5368','5369','5384','5385','5416','5417','5419','5370','5365','5228','5373','5374','5375','5376','5372','5371','276','5111','275','4230','5144','5112','4249','277','4250','4252','643','4251','5377','5378','5379','1188','1187','4231','1189','1190','219','245','246','5137','5140','5139','5138','249','242','5100','1018','1019','5036','244','5215','775','5226','259','923','1112','926','1118','465','1105','463','835','464','4','69','5395') LIMIT 10 "
0.0055418: Could not process query, error #1054: Unknown column 'thumb' in 'field list'
0.2603040: Total time
16 252 928: Memory usage

Однако thumb то есть:

Ок, я поставил minishop2 и mSearch2. Прикладываю рабочие параметры Join'a:

&class=`modResource`
	&leftJoin=`{
		"Thumb": {
			"class": "msProductData",
			"on": "modResource.id = Thumb.id"
		 }
	}`
	&select=`{
		"modResource": "*",
		"Thumb": "Thumb.thumb as preview"
	}`

— вызывать как [[+preview]]. Все дело было в классе — msProductData вместо msProductFile…

Ненавижу LeftJoin..)

Огромное спасибо Вам, Максим, вы мне очень помогли!
Скажите пожалуйста есть ли какая-нибудь доп. литература по Pdotools и прочим сниппетам кроме docs.modx.pro/ и сайта Наумкина?

Можно добавить префикс к этой теме: [Решено] — для потомков!

Да не за что.)

По pdoTools — в основном, здесь и доки. В остальном — разве что еще англоязычные форумы modx'a. Впрочем, тут уже лучше гуглить — точно не скажу.

Максим, не могли бы Вы провести аналогию с SQL, а также можно ли использовать 2 left join'а?

Да, конечно:

&leftJoin=`{
		"Image": {
			"class": "msResourceFile",
			"on": "modResource.id = Image.resource_id AND Image.parent = 0"
		},
		"Thumb": {
			"class": "msResourceFile",
			"on": "Image.id = Thumb.parent AND Thumb.path LIKE '%120x90%'"
		}
	}`

Вот тут более подробная информация и заодно ответ на ваш первый вопрос.

Не могу понять про Классы, что хранится в msResourceFile, а что хранится в modResource, а еще есть msProductFile что они значат? Это аналогии каких-то таблиц или выборок?

&leftJoin=`{
		"Image": {
			"class": "msResourceFile",
			"on": "modResource.id = Image.resource_id AND Image.parent = 0"
		}

Я понял следующее: Image — псевдоним для класса msResourceFile, мы объеденяем с результатами нашей выборки: modResource.id = Image.resource_id AND Image.parent = 0

Я осознаю, что я Вам порядком поднадоел =)

Упс. Хром не всегда возвращает алерт о новом сообщении вовремя..)

Классы состоят из тех, которые возвращает сам снипеет (допустим, pdoResources, который по-умолчанию возвращает modResource) — это «основной» класс (его еще можно переназвать при помощи параметра &class), к которому будет происходить join.
Это может быть как modResource, Data и прочее — зависит от сниппета и легко просматривается через &showLog.

Через leftJoin же мы определяем псевдоним таблицы («Image» в примере выше) и далее в коде используем его как префикс у поля, чтобы определить из какой из таблиц выбрать колонку (для selecta, метода склеивания таблиц и тд).
Что до «добавочных» классов при leftJoine — это расширяющие модели xPDO, которые получаются при помощи парсинга папки core/components/Название_класса, в которой уже хранится остальная информация (какая таблица, какие типы данных и так далее).
Тут я вам точнее не скажу, советую почитать вот это или это.