Как вывести производителей из определенных категорий?
[[!pdoResources?
&class=`msProduct`
&parents=`1328,1330,1336,1343`
&limit=`0`
&depth=`10`
&tpl=`@INLINE <option value="[[+id]]">[[+name]]</option>`
&innerJoin=`{
"Data": {
"class": "msProductData",
"on": "msProduct.id = Data.id"
},
"Vendor": {
"class": "msVendor",
"on": "Data.vendor = Vendor.id"
},
"Member": {
"class": "msCategoryMember",
"on": "Member.product_id = msProduct.id"
}
}`
&showLog=`1`
]]
0.0004270: pdoTools loaded
0.0000272: xPDO query object created
0.0003440: innerJoined msProductData as Data
0.0003541: innerJoined msVendor as Vendor
0.0003381: innerJoined msCategoryMember as Member
0.0002210: Added selection of msProduct: `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `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.0096610: Processed additional conditions
0.0103660: Added where condition: msProduct.parent:IN(1328,1330,1336,1343,1329,2228,6971,6975,6977,6978,6980,8137,8140,8663,9271,9272,9273,10211,10224,10228,10229,10230,10233,10447,11354,1331,1332,1333,1334,1335,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,2399,2401,2419,2420,2421,2422,2423,2424,2425,2426,2427,2431,2432,2433,2434,2435,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2526,2528,2530,2532,2534,2536,2544,2545,2546,2547,2548,2549,2645,2647,2657,2659,3080,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,4782,4786,4787,4788,6352,6358,6937,6938,6939,6940,6941,6972,7002,7003,7004,7664,8029,8030,8031,8032,8040,8042,8043,8044,9426,9499,9983,10353,10355,10357,10359,10363,10364,10365,10366,10367,10368,10369,10370,10371,10372,10373,10374,1536,1537,1538,1539,1540,1541,2121,2122,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2400,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2428,2429,2437,2439,2440,2442,2518,2519,2520,2521,2522,2523,2524,2525,2527,2529,2531,2533,2535,2537,2538,2539,2540,2541,2542,2543,2550,2551,2552,2607,2608,2609,2612,2613,2614,2615,2616,2617,2618,2619,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2643,2644,2646,2648,2649,2650,2651,2652,2653,2654,2655,2656,2658,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2689,2690,2691,2692,2693,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2747,2748,2749,2750,2751,2752,2753,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2876,3081,3119,3273,3274,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3286,3289,3290,3291,3292,3293,3294,3296,3297,3301,3302,3303,3304,3305,3306,3307,3308,3311,3694,3696,3697,3698,3699,3700,3701,4676,4681,4690,4705,4712,4721,4730,4754,4758,4759,4760,4761,4762,4780,4781,4783,4784,4785,4789,4860,4861,4862,4863,4864,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,5367,5368,5369,5370,5371,5372,5373,5374,5380,5832,5833,6318,6319,6320,6321,6322,6323,6327,6328,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6349,6350,6351,6353,6354,6355,6356,6357,6359,6360,6361,6362,6363,6364,6365,6368,6369,6370,6371,6372,6415,6437,6936,6942,6943,6944,6945,6946,6947,6948,6949,6950,6951,6952,6982,6983,6984,6989,6990,6991,6992,6993,6994,6995,7005,7010,7011,7012,7018,7019,7033,7034,7035,7036,7039,7040,7041,7600,7601,7602,7603,7604,7605,7606,7607,7622,7623,7624,7625,7733,7734,7760,7761,7768,7769,7770,7771,7773,7774,7775,7783,7784,7785,7786,7787,7793,7832,7833,7834,7835,7836,7837,7838,7859,7893,7896,7897,7898,7899,7997,7998,7999,8000,8001,8002,8003,8004,8005,8006,8007,8008,8009,8013,8014,8015,8016,8017,8018,8019,8020,8021,8025,8026,8027,8028,8033,8034,8035,8036,8037,8038,8039,8041,8045,8046,8047,8122,8527,8561,9117,9118,9119,9120,9121,9122,9123,9124,9125,9375,9376,9377,9378,9379,9385,9390,9391,9392,9393,9394,9395,9396,9397,9398,9399,9400,9409,9411,9413,9424,9425,9427,9428,9429,9430,9431,9432,9433,9434,9435,9436,9437,9438,9439,9440,9441,9442,9443,9444,9445,9446,9458,9459,9460,9461,9462,9463,9464,9465,9466,9467,9468,9469,9479,9480,9481,9482,9483,9484,9485,9486,9487,9488,9489,9490,9491,9498,9500,9501,9502,9503,9504,9505,9506,9507,9508,9509,9510,9511,9512,9513,9514,9515,9516,9517,9518,9519,9520,9521,9522,9523,9524,9548,9549,9550,9552,9553,9554,9555,9556,9705,9758,9759,9761,9762,9763,9764,9765,9766,9790,9791,9792,9793,9794,9795,9796,9797,9798,9799,9800,9801,9802,9803,9804,9805,9825,9826,9827,9828,9849,9850,9851,9852,9853,9854,9856,9885,9959,9979,9980,9981,9982,9984,9985,9986,9987,9988,9992,9993,9994,9995,9996,9997,9998,9999,10000,10001,10002,10177,10242,10243,10244,10245,10246,10247,10248,10249,10343,10344,10345,10346,10349,10351,10352,10354,10356,10358,10360,10375,10376,10577,10578,10716,10717,10877,11321,13134,13135,13136,13137,13138,13139,13140,13141,13142,2133,2620,2621,2685,2686,2687,2688,2746,4859,5381,7749,7750,7751,7752,7753,7754,7755,7763,7764,7765,7766,7767,7776,7777,7788,7789,7790,7791,7839,7959,8049,8050,8051,8052,8053,8869,8870,9989,9990,9991,11271,10921,10922,10923,9581,1337,1338,1339,1340,1341,1342,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2162,2163,2166,2167,2171,2172,2192,2193,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2372,2373,2374,2375,3357,3358,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3463,3464,3465,3466,3467,3468,3469,4611,4612,4613,4614,4618,4619,4678,4679,4680,4735,4736,4753,4765,4793,4794,4795,4796,4804,4805,4806,4807,4808,4809,4810,4813,4814,4815,4816,4817,4818,4819,4820,4821,4824,4825,4826,4827,4828,4829,4830,5099,5100,5101,5102,5103,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5324,5344,5345,5468,5478,5490,5491,5542,5546,5547,5666,5667,5668,5669,5682,5683,5684,5685,5686,5687,5688,5689,5834,5835,5836,5837,5838,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,6094,6095,6156,6157,6158,6159,6160,6161,6162,6163,6189,6190,6199,6200,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6251,6252,6253,6254,6255,6256,6257,6258,6262,6266,6267,6270,6271,6294,6373,6374,6749,6750,6755,6756,6767,6768,6769,6770,6771,6773,6774,6777,6778,6779,6781,6782,6783,6784,6785,6786,6787,6788,6789,6790,6791,6792,6793,6794,6795,6796,6805,6806,6811,6812,6813,6821,6826,6827,6831,6833,6834,6838,6839,6867,6868,6987,6988,7024,7025,7026,7094,7227,7228,7229,7230,7255,7256,7257,7262,7263,7264,7286,7287,7288,7289,7290,7291,7292,7490,7491,7492,7494,7505,7506,7514,7520,7521,7523,7524,7525,7526,7529,7530,7531,7532,7533,7536,8054,8055,8056,8057,8058,8059,8060,8061,8062,8063,8064,8065,8066,8067,8068,8069,8070,8071,8072,8073,8074,8075,8076,8077,8078,8079,8080,8081,8082,8083,8084,8151,8152,8159,8160,8185,8186,8228,8237,8238,8239,8240,8241,8242,8243,8244,8245,8542,8543,8569,8570,8571,8572,8573,8574,8575,8576,8592,8593,8594,8595,8699,8700,8901,8902,8903,8904,8929,8934,8935,8938,8939,8940,8941,8974,8983,8984,8985,8986,8995,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9145,9146,9150,9151,9152,9153,9155,9332,9527,9600,9601,9602,9603,9604,9605,9606,9607,9608,9609,9615,9616,9622,9623,9627,9628,9692,9750,9751,9752,9753,9771,9772,9773,9774,9775,9776,9777,9778,9779,9780,9781,9782,9783,9784,9789,9868,9869,10189,10190,10191,10193,10194,10195,10196,10198,10199,10201,10239,10533,10534,10535,10536,10537,10538,10539,10540,10557,10558,10559,10564,10565,10566,10567,10568,10645,10646,10652,10653,10662,10663,10664,10665,10666,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10683,10684,10685,10686,10687,10688,10689,10690,10718,10719,10720,10721,10722,10723,10724,10725,10734,10735,10736,10737,10738,10739,10740,10741,10742,10743,10745,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10768,10769,10770,10771,10791,10792,10793,6075,6089,6090,6134,6175,6740,7117,8086,8087,8090,8101,8230,8281,8537,8547,8548,8549,8890,8959,8967,10627,1545,1546,1547,1548,1553,1554,1555,1556,1780,1781,1782,1783,1860,2116,2117,2118,2119,2120,2123,2124,2147,2148,2161,2164,2165,2168,2169,2170,2196,2197,2199,2200,2267,2268,2269,2270,2336,2357,2368,2369,2370,2371,2376,2377,2436,2438,2441,2443,2444,2610,2611,2642,2681,2682,2683,2684,2694,2755,2756,2757,2758,2759,2879,3082,3359,3380,3381,3462,3470,3471,3472,3473,3474,3674,3675,3676,3677,3683,3695,4106,4107,4108,4615,4616,4617,4620,4621,4622,4623,4752,4755,4756,4757,4763,4764,4767,4768,4769,4770,4771,4772,4773,4774,4775,4790,4791,4792,4797,4798,4799,4800,4801,4802,4803,4811,4812,4831,4832,4833,4834,4835,4836,4837,4838,4839,4840…
Комментарии: 3
Вывести производителей товаров?
Да
fenom:
{$_pls['vendor.name']}
или так [[+vendor.name]]
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.