Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT *
FROM CategoryProduct_View
WHERE
ProductID in (292,13,193,200,194,149,221,222,3067,3067,1714,899,3016,3064,2946,2963,2935,2951,2955,213,2939,2944,2942,2944,2942,2939,1797,2124,3007,2979,3057,2979,3022,980,3022,3048,338,3002,3002,3029,3029,338,275,907,47,2947,2123,907,47,1740,907,47,2947,4,275,3012,3005,2943,3005,3005,3170,2978,1793,2978,298,2967,2967,2182,298,2182,3027,2987,2995,2954,3054,2954,3054,2954,3054,2954,315,2954,314,2954,238,3036,216,2994,238,3036,216,2994,238,3036,216,2994,3020,13,35,2994,3020,13,35,2994,3020,238,3036,216,2958,1716,1798,2090,879,2090,879,2090,3028,1716,3028,2958,934,2941,2153,2941,3154,3168,2948,3153,2949,3151,3158,3160,3188,3160,3158,3188,3160,3158,2948,3151,2983,3153,3188,3158,2983,3188,2949,3151,3153,3160,295,2982,3055,3055,2911,980,3022,2914,2911,3152,3153,3169,3150,3188,2914,2911,3156,3165,3159,3165,3159,3156,3123,3122,3149,2914,3161,2914,2126,3141,1716,1735,38,395,38,2955,368,38,2955,3011,38,2955,3031,38,2955,3031,3011,395,368,3031,3011,395,368,263,1115,1713,1399,2945,2119,77,951,951,2119,77,308,951,261,77,1713,1322,77,77,308,951,2063,922,2059,2065,3006,2993,3006,2993,3006,2993,3004,2981,3001,2993,2950,2999,3004,402,2981,3001,3006,2950,2999,3006,2993,3006,2993,3044,3023,402,3188,2088,2953,2986,3046,2986,1735,1716,2975,3056,1317,2059,2969,2988,2969,2940,3056,2996,3042,3056,3056,2988,3038,3056,449,2969,2990,2996,2940,48,31,1859,31,1859,2169,2169,48,31,1859,2169,48,31,1859,3030,604,2196,2964,604,2196,1760,1710,1760,1710,1317,2059,3060,2059,3060,1317,2341,3043,2341,3043,2341,3043,2976,2957,3009,2971,2341,3053,3016,2987,315,314,2945,2973,3014,2998,2945,3008,2972,3014,2998,3008,979,2998,295,2131,979,1742,1738,979,2131,979,374,432,3045,2974,3035,3020,3013,2922,2994,3045,3003,2966,346,2919,3003,3045,3003,2966,3045,3003,2966,3045,1345,2970,2974,1380,3024,3037,3013,474,2922,3045,3003,2974,3037,3013,2922,2966,1109,3021,3010,2989,3034,2959,3039,2951,2956,2968,2951,3039,2951,2956,3039,2968,520,559,2015,512,525,1795,481,487,2015,1795,952,484,990,559,512,955,525,481,487,484,520,512,525,481,487,955,484,3035,520,559,990,952,525,481,2015,1795,487,955,3035,484,520,990,952,559,1795,512,525,481,487,955,3035,990,952,484,2015,520,559,512,525,481,487,361,2919,484,520,559,512,525,481,3194,3536,3458,3307,3361,3329,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,3006,3389,2126,3955,3942,4167,1978,286,4546,4526,4577,4090,4094,4110,4536,4509,3741,3866,3798,4542,3748,1978,4573,4595,3862,4522,4574,4563,3714,3722,3853,4108,4090,4560,4174,2979,3730,4515,4091,3802,286,4200,4155,263,4100,3450,3722,3984,4583,4557,4604,4601,4548,1829,240,3919,4524,4550,4565,3838,4011,3895,4556,4563,4532,4587,227,4578,2333,2945,1115,4166,308,3671,3726,3708,3828,3872,3720,4569,4107,3746,4117,4573,4521,4513,2947,4132,4572,4578,4113,4520,402,1829,4089,4096,3806,4594,4589,2126,2333,263,4573,4053,275,4600,263,4132,3862,4598,4178,227,4533,4591,3822,4582,3984,4093,3808,4091,4537,1978,4131,3450,4572,1829,4102,3795,4507,3983,4582,3747,3826,4170,4540,4512,2982,4521,4117,3403,4589,4599,4580,4549,4117,4510,4517,4516,4591,3729,240,4521,4131,4112,4175,4113,3825,4570,3850,4120,2333,263,4556,4091,4563,295,3512,4623,4531,3671,4106,3895,286,4593,295,3682,2919,4600,4524,4114,2173,3022,4601,4566,3747,3726,3941,4552,4540,4538,4170,4512,3005,2952,4593,4534,4537,1829,3741,3668,3919,4565,4538,3844,3655,3741,3866,4154,4150,4576,4090,4094,4098,907,2986,4548,4121,4172,4117,4538,3676,3309,3850,4120,3512,4151,4152,3806,4141,4534,3822,4510,4552,3726,4589,3862,4178,4096,4106,4532,979,238,3748,4546,4599,3676,3726,4552,3862,1829,402,4524,4557,3983,4117,3862,3402,3403,4601,4581,2126,4589,4578,3683,3806,4514,4565,3838,4522,4581,4115,3022,4175,4128,3862,4121,4094,4539,4102,4097,4595,3065,4567,3676,3838,3795,4097,4547,4595,3720,3727,4176,4590,4559,4113,3329,3730,4168,4180,885,3512,295,4153,3862,3749,3844,4577,4170,3838,3726,4552,3739,4131,4534,4107,3798,3668,3741,4573,4117,4589,2126,4585,4152,4549,4569,4523,4100,3850,4570,4113,4511,4527,4538,3747,4151,3726,4539,4538,3838,3745,4106,3844,4137,4519,3838,4110,4094,3739,3380,4160,3790,3850,4582,4117,4180,3715,4168,3683,3749,3984,213,979,4107,4517,4585,4598,4107,4517,3512,295,2911,3022,4575,4178,4518,3652,286,4529,3945,3691,3450,4154,4098,4167,4538,4512,4170,4556,4574,4515,3691,4524,3450,3191,2914,4530,3825,4172,4518,4113,2979,3022,4554,3941,3862,4568,3683,4578,2979,3022,3380,3822,4582,4120,3757,3329,4180,3539,3310,3316,4583,4557,3708,3798,3741,3668,3402,3003,3862,4573,4550,3790,4580,4117,4510,4559,3797,2341,4538,4094,4577,4601,3682,4592,4110,4090,4536,4108,3671,4155,4096,4557,4113,4521,1829,4588,1829,4588,907,4115,4514,4153,4534,4107,4131,213,4542,3690,275,4524,3838,3749,3806,3683,4549,4117,4572,2173,383,3945,383,4544,364,3065,3746,2173,364,383,2173,3844,3065,383,3911,3196,3922,3911,3422,3922,364,4572,383,2173,64,3533,3304,3316,3410,3304,3533,3312,3533,3410,3304,3316,3304,3539,3539,3304,3310,3304,2310,2173,364,383,3304,3304,383,2173,383,2173,3304,383,2173,3304,4018,58,40,4101,58,61,4018,4101,42,3838,4117,3798,61,40,3300,40,3254,3275,3082,4330,61,923,60,3275,948,3254,60,982,61,3275,92,3082,3418,3254,3275,948,3275,3082,4330,3254,61,40,3300,58,4619,4330,40,61,3275,3254,42,4101,4018,58,4619,4616,58,4616,3275,3254,4620,4018,58,4665,300,59,2325,265,3109,4407,59,2323,4409,2312,2325,2310,4549,4576,4117,4623,3862,4598,4566,4151,3652,4574,4563,4513,3894,3895,979,3806,4562,4153,4575,4533,3862,3623,4538,3826,4547,4102,4604,4129,4117,1978,4516,4585,4011,4112,4128,3862,3746,4574,3808,4542,979,4528,1978,4534,4107,4590,4113,4167,4150,4576,3798,4523,3872,4106,4117,3790,4137,4530,3825,4547,4102,4115,3806,3862,3708,4525,979,3798,4515,3838,4524,361,3512,3329,4172,4094,4153,4151,3822,3862,4547,4102,3795,4094,4509,4110,4090,4545,4151,3862,4547,3795,4113,4538,4512,3826,4106,4096,3822,4555,3676,4574,3862,4097,4102,3862,4596,951,4520,4590,3797,4113,3689,3806,3862,3659,4563,4536,3853,4588,3876,4600,3380,3838,4530,2341,4543,4107,3808,4541,4526,4599,3676,4200,3671,4096,4114,2911,3895,3844,3838,4604,3846,4106,4096,4562,4534,4107,4137,3309,4600,3876,4588,4518,4568,3853,3683,3862,3659,3806,3862,3655,4596,2341,4588,4520,3872,4523,3669,3684,3720,4598,3862,4117,3403,3402,4526,3862,4515,3838,4587,4513,3838,4538,3862,4579,4527,3668,3866,3802,4102,4097,3795,4527,4579,4563,4090,4098,4094,4574,4563,3808,3812,3329,4174,4535,990,3450,4588,4508,4623,3862,88,3826,3797,3412,4623,4113,3682,4098,4094,4090,3846,3671,2126,3671,4200,3862,4600,3862,3708,4174,3669,4180,4116,4552,3652,4583,3941,3983,3669,4200,4106,3403,3402,3984,4137,4515,3838,4548,4575,4533,702,666,2345,979,213,4529,295,2979,979,3894,213,979,4529,4542,979,286,4113,4529,213,4528,4113,4529,3895,4113,3422,213,4528,3691,990,3838,4524,3798,3450,3802,4548,3667,4522,3876,4107,3380,2986,907,3691,3450,907,4519,3838,4565,4587,3512,3022,364,383,2173,4549,4572,2173,2173,383,364,3309,4549,2173,383,364,2173,2173,383,364,383,2173,364,383,2173,364,3922,3906,3207,3691,3838,4600,4522,3919,4011,4137,3691,3512,4522,3802,3876,3741,3798,3668,4011,3667,1829,4564,4581,3876,885,4576,885,4576,885,4576,885,4576,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,885,4576,885,4576,4576,885,4576,885,4576,885,4576,885,3022,4151,4113,4576,885,4576,885,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4540,286,4117,4540,4113,286,4540,286,4113,4540,286,4113,4540,286,4113,4113,286,4540,4540,4113,286,4113,4540,286,275,402,3798,275,402,3798,402,3798,275,402,3798,275,275,402,3798,402,275,3798,402,275,3798,402,275,3798,4113,286,3945,286,4113,3945,3945,4113,286,4113,286,3945,4113,286,3945,4113,286,3945,4113,286,3945,3741,3667,4107,3741,3667,4107,3741,3667,4107,3741,3667,4107,4107,3667,3741,3741,3667,4107,3741,3667,4107,3741,3667,4107,979,4113,213,979,4113,213,979,4113,213,979,4113,213,979,4113,213,4113,979,213,979,4113,213,4581,4551,3838,4551,3838,4581,3838,4581,4551,4551,4581,3838,4551,3838,4581,4581,4551,3838,4581,4551,3838,4551,3838,4581,3826,4182,3108,3108,3826,4182,3826,4182,3108,3826,4182,3108,4519,4524,4011,4519,4524,4011,4011,4524,4519,4524,4519,4011,3795,3739,4541,3652,4151,4563,4512,4599,4712,4581,4736,4712,4734,3683,4570,2126,4584,4713,4517,4513,907,4549,383,4519,4524,61,3418,4330,64,4725,3546,3275,3082,4715,42,61,40,948,4715,4725,4726,4711,4723,60,4715,3275,3418,3300,42,4764,979,4543,4765,4542,979,3676,4526,4604,4769,4600,4766,4769,4541,4703,4746,4744,4699,4745,2125,4712,4766,4756,4748,4756,4766,4700,4748,4767,4712,4582,4531,4564,4712,4151,3749,2911,4568,4713,4768,4767,4558,383,4549,364,3674,4127,4584,4754,3661,3984,4770,4747,3674,4771,4524,4699,4771,4702,4604,4584,4571,4127,4594,4541,4102,4753,4771,4751,3689,4526,3539,4593,4547,4541,4555,4567,4771,4740,4762,4552,4743,3676,4513,4176,4556,3871,4755,4552,2911,4737,4749,4760,4100,4772,3872,3661,4570,3690,4564,4702,4766,4797,4745,4769,4748,4712,4767,4796,4753,4754,4794,4804,4767,4804,4755,4745,4746,4769,4793,4745,4766,4767,4768,4748,4804,4794,4767,4712,58,61,4620,4893,4167,4888,3739,4541,4214,4925,4890,4588,4151,4891,4712,4908,4902,4713,4879,4907,4911,4919,4899,4585,4893,4888,4153,4925,4901,4890,4876,3671,4860,4880,4914,4911,4714,4883,4528,4538,4860,3822,3652,4911,4890,4907,4882,4895,4712,4129,4534,4521,3689,3828,3746,4756,907,4702,4697,4167,4521,4901,4908,4860,4883,4916,4151,4112,3945,4562,3828,4536,4574,4901,4151,4888,4594,4712,4547,4926,4712,4547,4,4604,4697,4115,4599,2911,5034,5043,5029,4997,5017,5042,5031,4102,5012,4325,4996,5038,4997,5011,3727,5013,4990,5001,3402,5012,4712,4990,5005,5001,5048,5012,5034,5001,5013,4996,5035,5042,3691,5027,4797,5043,4797,5027,5012,5029,5048,4999,5011,5017,5002,4325,5001,3676,5038,5005,5001,5000,4167,4712,4325,5001,3623,383,4996,5005,5043,364,5048,4584,4132,4600,4594,4538,4182,4102,4097,3749,3806,4712,383,4524,364,4574,4090,4698,402,1829,4508,4585,3984,4712,4564,907,4689,4141,2911,4712,383,2173,3676,4584,4975,4526,4698,4982,4604,4916,4172,4121,2914,4867,4200,4168,4966,4523,907,2173,4975,364,4559,4701,3422,4564,2911,4695,4699,4518,4519,4513,3676,4713,4699,2341,4908,4120,3683,3682,4150,4579,4098,4882,4885,4880,4151,2126,3822,4977,4908,3669,4535,4176,4712,3682,4695,4120,4893,3689,4883,4533,4178,4575,4556,213,979,1978,3790,4700,3304,3310,3533,4793,4975,4966,4582,5198,5273,5287,5244,5237,5158,5296,5176,5330,4120,308,4712,5239,5205,4594,5183,5197,4558,5315,4762,4323,5285,4539,4558,4153,5284,5163,5214,5331,5169,5221,5223,308,5204,3748,4762,5259,5199,5301,3055,5272,4570,5187,5176,2911,5274,4573,5294,5291,5194,5197,4797,5208,5236,5280,5248,5251,4151,4598,5235,5222,5175,5223,5196,5172,3871,5171,5337,4180,5299,3659,5210,5179,4603,5245,4695,3689,4591,5288,5216,5237,5304,4589,5227,5301,5225,5183,5261,4695,951,5216,5226,4603,5208,5274,5254,4591,5175,4885,5230,4703,5206,5221,5243,979,4492,5201,5192,4700,5242,5257,5247,5233,4573,5217,3906,951,4760,4695,4091,5209,3871,5235,5178,5175,4589,4712,5260,5201,5331,4137,5189,4603,5187,4589,5227,4695,5253,5242,5257,5227,4703,4713,5204,5305,5334,5330,2911,4570,5201,5288,5189,5194,5231,4700,4712,5178,5222,3726,5161,5170,5265,4762,4593,4692,5303,5245,2333,5227,5206,3808,5242,979,4548,5200,5284,5189,3690,5181,5331,5192,5215,5222,4712,3726,4598,5167,4742,5263,5205,5250,5331,4539,5229,5287,5216,5187,5200,5284,5216,5170,4492,5280,5221,5216,3005,979,951,5330,5301,5243,5204,3871,5205,4120,2911,5244,5205,5227,4570,5218,5236,5159,5260,5194,5201,5159,4120,5244,2911,5330,5249,5183,5241,5229,5230,5235,5224,5178,5222,5263,5201,5245,5197,4548,3729,4558,5270,5337,5274,5262,5219,3871,4712,2941,5185,5176,5183,4700,5337,5334,5332,5333,5200,4570,5238,5233,3169,5246,5257,5227,3748,5212,5229,4323,3844,5225,5198,5239,5190,5240,4151,4120,5254,2941,3726,4712,5178,5239,5296,4323,5198,5192,5224,4573,3748,5227,3906,5262,5232,5238,5193,3689,2914,5230,5224,4703,3005,4598,5167,5222,5206,4153,4712,5190,5240,2941,5227,5284,5330,4713,5236,5218,5216,4695,5222,5163,5273,4589,5167,5330,5166,5240,5190,4760,5330,5299,5219,5195,5249,3689,4153,5238,5274,5192,5331,5159,5288,5181,5225,5256,5238,2914,4323,3769,5174,5272,5184,5183,5160,5252,5174,4560,4689,5337,5334,5333,5332,5164,5186,5231,4700,5159,5304,4700,4137,5201,5181,5201,5218,5237,5194,5190,5240,4091,4712,5337,5334,5332,5333,4492,5204,979,5160,5198,5184,5173,4091,4151,5205,4603,5187,5259,5224,5183,5207,5178,4712,4323,5158,5185,2914,5270,5255,5219,4168,5204,5243,4695,3169,3661,5250,5192,5201,4180,5270,5219,2173,5332,383,364,383,3746,4695,1976,5291,383,4570,383,5195,4558,5251,5301,5274,4548,5245,4593,364,3065,2173,5166,5240,5239,5248,5265,5287,2911,5265,4760,951,4594,5251,4703,5233,907,5179,5271,5272,5193,5232,3689,5294,5291,3906,3748,4703,3659,3659,5257,3746,5233,5262,5291,5171,5281,5185,5158,5279,5182,3729,5194,4548,4548,5268,5306,5259,5179,4700,5189,5212,5239,4712,5294,4153,5263,5187,4695,3894,4598,5251,5222,4151,5330,4492,4594,5241,5212,4904,5239,5178,4712,5265,5211,5282,5268,4700,5159,5228,5248,5203,5193,5282,5261,5257,2914,5214,5274,5227,5263,5191,4151,5228,5175,4712,5166,5239,5178,4712,5227,5160,5158,5185,5279,5174,5233,5275,5248,3650,5268,5159,3790,4700,5161,5305,2911,5330,5315,951,5233,5163,5287,5301,2911,5330,5174,5279,5238,5281,5191,5222,4742,3808,5257,3746,4594,5230,4492,5161,5271,5213,3005,951,4713,5218,5197,3055,5237,5212,5294,5291,4700,5218,4542,5238,5262,5275,5233,5262,3844,5295,5165,3746,5225,4904,4594,5294,5291,4703,5227,5185,5285,5281,5279,5160,5174,5160,5182,5241,5174,4904,5296,2914,5238,3844,5225,907,5260,5169,5263,4700,3790,5291,5189,5212,5331,5203,5296,3661,5273,5212,5294,5262,4703,5179,5268,4137,4593,4713,5182,5274,5227,5160,5279,5161,5280,308,4492,979,5250,5192,4524,5331,5218,3844,5213,5187,4695,5280,5213,3661,4492,5212,4904,5257,5291,5262,4703,4713,5218,5197,5194,5237,5214,5254,5265,5257,5248,5265,4695,5182,5331,5245,5214,5160,5211,5288,3659,3661,5203,5179,5268,4700,5265,5306,5238,5265,5174,5251,5214,5245,5187,5226,4695,5203,5257,5248,5193,5220,5158,5185,383,5165,3689,383,5238,5234,4594,4712,5251,3690,4542,5222,5331,5250,5192,5331,5245,5279,5160,5245,5254,5237,5291,3790,4548,3790,3689,5272,5238,5279,5174,5163,5161,5301,2911,5330,5274,5227,5330,3746,5225,5294,4703,5288,3844,5225,2914,5194,5236,5168,4713,5248,5239,5190,5303,4692,5206,5274,4712,5250,5201,5331,5245,4603,5331,5265,5249,4712,5190,5163,5330,5252,5279,5207,5279,5207,4582,3746,5172,3808,5262,5265,2941,5181,4713,5250,4524,5331,5215,5191,4151,4713,4558,5270,2941,5163,5254,4692,5303,2333,5269,2914,5238,4594,5283,5201,5245,5331,5266,5174,5252,5250,5190,5166,5239,4712,3871,5263,5192,5201,5168,4091,5239,3746,4885,4153,4712,5263,5205,4603,5279,5201,5192,5331,5236,4713,5190,5201,4524,5259,5184,5249,5232,5272,5238,5222,5191,5215,5259,4168,5195,4558,5270,5178,5294,4589,5204,5197,4700,5239,5205,5254,5245,5243,5304,5260,5159,4713,5235,4492,5222,3065,2173,5386,5383,5171,5331,5214,5187,4760,4762,5396,4558,4180,4804,5385,4794,4713,4120,4151,4524,5224,5334,5248,5400,4804,4794,5190,5230,5221,5251,5394,5170,5392,5248,4573,308,5198,5213,5288,5181,5256,5245,5202,5237,5446,5462,4712,5441,5448,5438,3748,5232,3790,5445,979,5243,5451,5440,5214,5458,5436,5451,5433,5434,5331,5448,5454,5429,5429,5432,5438,5446,5455,4712,5443,5431,5265,5442,5423,5451,5432,5456,5454,5245,5440,5202,5447,5190,4712,5428,5425,4589,5201,5259,4713,5453,4603,5226,5031,4573,5291,5199,5296,5042,5459,5458,5254,3871,5429,5432,4714,5216,979,4689,293,5189,5282,4885,5257,5438,5209,5162,3065,2173,383,5228,4762,5330,5459,5436,5330,5461,5261,4929,4760,5452,5440,5427,5448,5450,5455,5462,5451,5163,2911,5426,5440,5447,5462,5438,5432,5440,5457,3661,3911,5226,5245,5457,5455,5439,5178,5280,979,4542,5244,5208,5345,5400,5385,5385,5400,5180,5201,5186,4558,5202,5268,5476,5478,5198,5476,5479,5481,5480,5479,5478,5481,5476,5479,5480,5479,5476,5265,5448,5331,5258,5216,5331,4695,3894,4929,5605,5608,5612,5605,5612,5602,5608,5612,5602,5602,5605,5608,5245,5451,5175,5291,4760,4573,3377,5694,5725,5717,5711,5719,5730,5734,5702,5724,5704,5721,5732,5733,5707,5750,5696,5727,5687,5716,5710,5751,5698,5713,5701,5738,5690,5729,5718,5716,5751,5695,5728,5701,5707,5725,5693,5693,5730,5717,5693,5691,5737,5687,5688,5727,5703,5694,5719,5739,5751,5714,5721,5724,5729,5686,5685,2911,5726,5706,5720,5692,5713,5727,5291,5294,5183,5693,5691,5730,5703,5725,5750,5715,5716,5739,5731,5721,5686,5725,5719,5703,5751,5701,5703,5720,5734,5733,5688,5738,5751,5701,5728,5732,5734,5720,5721,5740,5685,5688,5721,5720,5734,5715,5716,5739,5727,5696,5722,5697,5719,5725,5688,5731,5721,5737,5697,5750,5712,5690,5729,5738,5712,5690,5721,5732,5733,5705,5728,5698,5690,5712,5720,5720,5724,5751,5685,5701,5707,5695,5705,5700,5729,5750,5712,5694,5725,5703,5727,5692,5714,5709,5751,5727,5693,5691,5717,5712,5750,5726,5739,5716,5710,383,5859,5881,5878,5857,5914,5914,5857,5859,5881,5853,5859,5878,5859,5881,5853,5914,5878,5908,5716,5751,5687,5280,5186,5892,5930,5224,383,3065,5908)
AND
CompanyID = 1
AND
CountryID = 2 AND
WarehouseID = 1 AND
LanguageID = 1 AND
PLVCountryID = 2 AND
PriceLevel = 2
AND AllowLive = 1
AND (CatStartDt IS NULL OR CatStartDt='' OR ({ts '2020-10-25 17:22:00'}) >= CatStartDt)
AND (CatEndDt IS NULL OR CatEndDt='' OR ({ts '2020-10-25 17:22:00'}) <= CatEndDt)
AND AllowOrderEntry=1
AND (
AllowPLVList='' OR AllowPLVList IS NULL
OR AllowPLVList='2'
OR AllowPLVList like '2,%'
OR AllowPLVList like '%,2,%'
OR AllowPLVList like '%,2'
)
AND CategoryAllowOrderEntry=1
AND (CatFlagNumOnly = 0
)
AND (FlagNumOnly = 0
)
ORDER BY CategoryName ASC, Sequence ASC, ItemCode ASC |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 6.2 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| DataSource | |
| Detail | | string | The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. |
|
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | |
| NativeErrorCode | |
| queryError | | string | SELECT *
FROM CategoryProduct_View
WHERE
ProductID in (292,13,193,200,194,149,221,222,3067,3067,1714,899,3016,3064,2946,2963,2935,2951,2955,213,2939,2944,2942,2944,2942,2939,1797,2124,3007,2979,3057,2979,3022,980,3022,3048,338,3002,3002,3029,3029,338,275,907,47,2947,2123,907,47,1740,907,47,2947,4,275,3012,3005,2943,3005,3005,3170,2978,1793,2978,298,2967,2967,2182,298,2182,3027,2987,2995,2954,3054,2954,3054,2954,3054,2954,315,2954,314,2954,238,3036,216,2994,238,3036,216,2994,238,3036,216,2994,3020,13,35,2994,3020,13,35,2994,3020,238,3036,216,2958,1716,1798,2090,879,2090,879,2090,3028,1716,3028,2958,934,2941,2153,2941,3154,3168,2948,3153,2949,3151,3158,3160,3188,3160,3158,3188,3160,3158,2948,3151,2983,3153,3188,3158,2983,3188,2949,3151,3153,3160,295,2982,3055,3055,2911,980,3022,2914,2911,3152,3153,3169,3150,3188,2914,2911,3156,3165,3159,3165,3159,3156,3123,3122,3149,2914,3161,2914,2126,3141,1716,1735,38,395,38,2955,368,38,2955,3011,38,2955,3031,38,2955,3031,3011,395,368,3031,3011,395,368,263,1115,1713,1399,2945,2119,77,951,951,2119,77,308,951,261,77,1713,1322,77,77,308,951,2063,922,2059,2065,3006,2993,3006,2993,3006,2993,3004,2981,3001,2993,2950,2999,3004,402,2981,3001,3006,2950,2999,3006,2993,3006,2993,3044,3023,402,3188,2088,2953,2986,3046,2986,1735,1716,2975,3056,1317,2059,2969,2988,2969,2940,3056,2996,3042,3056,3056,2988,3038,3056,449,2969,2990,2996,2940,48,31,1859,31,1859,2169,2169,48,31,1859,2169,48,31,1859,3030,604,2196,2964,604,2196,1760,1710,1760,1710,1317,2059,3060,2059,3060,1317,2341,3043,2341,3043,2341,3043,2976,2957,3009,2971,2341,3053,3016,2987,315,314,2945,2973,3014,2998,2945,3008,2972,3014,2998,3008,979,2998,295,2131,979,1742,1738,979,2131,979,374,432,3045,2974,3035,3020,3013,2922,2994,3045,3003,2966,346,2919,3003,3045,3003,2966,3045,3003,2966,3045,1345,2970,2974,1380,3024,3037,3013,474,2922,3045,3003,2974,3037,3013,2922,2966,1109,3021,3010,2989,3034,2959,3039,2951,2956,2968,2951,3039,2951,2956,3039,2968,520,559,2015,512,525,1795,481,487,2015,1795,952,484,990,559,512,955,525,481,487,484,520,512,525,481,487,955,484,3035,520,559,990,952,525,481,2015,1795,487,955,3035,484,520,990,952,559,1795,512,525,481,487,955,3035,990,952,484,2015,520,559,512,525,481,487,361,2919,484,520,559,512,525,481,3194,3536,3458,3307,3361,3329,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,3006,3389,2126,3955,3942,4167,1978,286,4546,4526,4577,4090,4094,4110,4536,4509,3741,3866,3798,4542,3748,1978,4573,4595,3862,4522,4574,4563,3714,3722,3853,4108,4090,4560,4174,2979,3730,4515,4091,3802,286,4200,4155,263,4100,3450,3722,3984,4583,4557,4604,4601,4548,1829,240,3919,4524,4550,4565,3838,4011,3895,4556,4563,4532,4587,227,4578,2333,2945,1115,4166,308,3671,3726,3708,3828,3872,3720,4569,4107,3746,4117,4573,4521,4513,2947,4132,4572,4578,4113,4520,402,1829,4089,4096,3806,4594,4589,2126,2333,263,4573,4053,275,4600,263,4132,3862,4598,4178,227,4533,4591,3822,4582,3984,4093,3808,4091,4537,1978,4131,3450,4572,1829,4102,3795,4507,3983,4582,3747,3826,4170,4540,4512,2982,4521,4117,3403,4589,4599,4580,4549,4117,4510,4517,4516,4591,3729,240,4521,4131,4112,4175,4113,3825,4570,3850,4120,2333,263,4556,4091,4563,295,3512,4623,4531,3671,4106,3895,286,4593,295,3682,2919,4600,4524,4114,2173,3022,4601,4566,3747,3726,3941,4552,4540,4538,4170,4512,3005,2952,4593,4534,4537,1829,3741,3668,3919,4565,4538,3844,3655,3741,3866,4154,4150,4576,4090,4094,4098,907,2986,4548,4121,4172,4117,4538,3676,3309,3850,4120,3512,4151,4152,3806,4141,4534,3822,4510,4552,3726,4589,3862,4178,4096,4106,4532,979,238,3748,4546,4599,3676,3726,4552,3862,1829,402,4524,4557,3983,4117,3862,3402,3403,4601,4581,2126,4589,4578,3683,3806,4514,4565,3838,4522,4581,4115,3022,4175,4128,3862,4121,4094,4539,4102,4097,4595,3065,4567,3676,3838,3795,4097,4547,4595,3720,3727,4176,4590,4559,4113,3329,3730,4168,4180,885,3512,295,4153,3862,3749,3844,4577,4170,3838,3726,4552,3739,4131,4534,4107,3798,3668,3741,4573,4117,4589,2126,4585,4152,4549,4569,4523,4100,3850,4570,4113,4511,4527,4538,3747,4151,3726,4539,4538,3838,3745,4106,3844,4137,4519,3838,4110,4094,3739,3380,4160,3790,3850,4582,4117,4180,3715,4168,3683,3749,3984,213,979,4107,4517,4585,4598,4107,4517,3512,295,2911,3022,4575,4178,4518,3652,286,4529,3945,3691,3450,4154,4098,4167,4538,4512,4170,4556,4574,4515,3691,4524,3450,3191,2914,4530,3825,4172,4518,4113,2979,3022,4554,3941,3862,4568,3683,4578,2979,3022,3380,3822,4582,4120,3757,3329,4180,3539,3310,3316,4583,4557,3708,3798,3741,3668,3402,3003,3862,4573,4550,3790,4580,4117,4510,4559,3797,2341,4538,4094,4577,4601,3682,4592,4110,4090,4536,4108,3671,4155,4096,4557,4113,4521,1829,4588,1829,4588,907,4115,4514,4153,4534,4107,4131,213,4542,3690,275,4524,3838,3749,3806,3683,4549,4117,4572,2173,383,3945,383,4544,364,3065,3746,2173,364,383,2173,3844,3065,383,3911,3196,3922,3911,3422,3922,364,4572,383,2173,64,3533,3304,3316,3410,3304,3533,3312,3533,3410,3304,3316,3304,3539,3539,3304,3310,3304,2310,2173,364,383,3304,3304,383,2173,383,2173,3304,383,2173,3304,4018,58,40,4101,58,61,4018,4101,42,3838,4117,3798,61,40,3300,40,3254,3275,3082,4330,61,923,60,3275,948,3254,60,982,61,3275,92,3082,3418,3254,3275,948,3275,3082,4330,3254,61,40,3300,58,4619,4330,40,61,3275,3254,42,4101,4018,58,4619,4616,58,4616,3275,3254,4620,4018,58,4665,300,59,2325,265,3109,4407,59,2323,4409,2312,2325,2310,4549,4576,4117,4623,3862,4598,4566,4151,3652,4574,4563,4513,3894,3895,979,3806,4562,4153,4575,4533,3862,3623,4538,3826,4547,4102,4604,4129,4117,1978,4516,4585,4011,4112,4128,3862,3746,4574,3808,4542,979,4528,1978,4534,4107,4590,4113,4167,4150,4576,3798,4523,3872,4106,4117,3790,4137,4530,3825,4547,4102,4115,3806,3862,3708,4525,979,3798,4515,3838,4524,361,3512,3329,4172,4094,4153,4151,3822,3862,4547,4102,3795,4094,4509,4110,4090,4545,4151,3862,4547,3795,4113,4538,4512,3826,4106,4096,3822,4555,3676,4574,3862,4097,4102,3862,4596,951,4520,4590,3797,4113,3689,3806,3862,3659,4563,4536,3853,4588,3876,4600,3380,3838,4530,2341,4543,4107,3808,4541,4526,4599,3676,4200,3671,4096,4114,2911,3895,3844,3838,4604,3846,4106,4096,4562,4534,4107,4137,3309,4600,3876,4588,4518,4568,3853,3683,3862,3659,3806,3862,3655,4596,2341,4588,4520,3872,4523,3669,3684,3720,4598,3862,4117,3403,3402,4526,3862,4515,3838,4587,4513,3838,4538,3862,4579,4527,3668,3866,3802,4102,4097,3795,4527,4579,4563,4090,4098,4094,4574,4563,3808,3812,3329,4174,4535,990,3450,4588,4508,4623,3862,88,3826,3797,3412,4623,4113,3682,4098,4094,4090,3846,3671,2126,3671,4200,3862,4600,3862,3708,4174,3669,4180,4116,4552,3652,4583,3941,3983,3669,4200,4106,3403,3402,3984,4137,4515,3838,4548,4575,4533,702,666,2345,979,213,4529,295,2979,979,3894,213,979,4529,4542,979,286,4113,4529,213,4528,4113,4529,3895,4113,3422,213,4528,3691,990,3838,4524,3798,3450,3802,4548,3667,4522,3876,4107,3380,2986,907,3691,3450,907,4519,3838,4565,4587,3512,3022,364,383,2173,4549,4572,2173,2173,383,364,3309,4549,2173,383,364,2173,2173,383,364,383,2173,364,383,2173,364,3922,3906,3207,3691,3838,4600,4522,3919,4011,4137,3691,3512,4522,3802,3876,3741,3798,3668,4011,3667,1829,4564,4581,3876,885,4576,885,4576,885,4576,885,4576,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,885,4576,885,4576,4576,885,4576,885,4576,885,4576,885,3022,4151,4113,4576,885,4576,885,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4540,286,4117,4540,4113,286,4540,286,4113,4540,286,4113,4540,286,4113,4113,286,4540,4540,4113,286,4113,4540,286,275,402,3798,275,402,3798,402,3798,275,402,3798,275,275,402,3798,402,275,3798,402,275,3798,402,275,3798,4113,286,3945,286,4113,3945,3945,4113,286,4113,286,3945,4113,286,3945,4113,286,3945,4113,286,3945,3741,3667,4107,3741,3667,4107,3741,3667,4107,3741,3667,4107,4107,3667,3741,3741,3667,4107,3741,3667,4107,3741,3667,4107,979,4113,213,979,4113,213,979,4113,213,979,4113,213,979,4113,213,4113,979,213,979,4113,213,4581,4551,3838,4551,3838,4581,3838,4581,4551,4551,4581,3838,4551,3838,4581,4581,4551,3838,4581,4551,3838,4551,3838,4581,3826,4182,3108,3108,3826,4182,3826,4182,3108,3826,4182,3108,4519,4524,4011,4519,4524,4011,4011,4524,4519,4524,4519,4011,3795,3739,4541,3652,4151,4563,4512,4599,4712,4581,4736,4712,4734,3683,4570,2126,4584,4713,4517,4513,907,4549,383,4519,4524,61,3418,4330,64,4725,3546,3275,3082,4715,42,61,40,948,4715,4725,4726,4711,4723,60,4715,3275,3418,3300,42,4764,979,4543,4765,4542,979,3676,4526,4604,4769,4600,4766,4769,4541,4703,4746,4744,4699,4745,2125,4712,4766,4756,4748,4756,4766,4700,4748,4767,4712,4582,4531,4564,4712,4151,3749,2911,4568,4713,4768,4767,4558,383,4549,364,3674,4127,4584,4754,3661,3984,4770,4747,3674,4771,4524,4699,4771,4702,4604,4584,4571,4127,4594,4541,4102,4753,4771,4751,3689,4526,3539,4593,4547,4541,4555,4567,4771,4740,4762,4552,4743,3676,4513,4176,4556,3871,4755,4552,2911,4737,4749,4760,4100,4772,3872,3661,4570,3690,4564,4702,4766,4797,4745,4769,4748,4712,4767,4796,4753,4754,4794,4804,4767,4804,4755,4745,4746,4769,4793,4745,4766,4767,4768,4748,4804,4794,4767,4712,58,61,4620,4893,4167,4888,3739,4541,4214,4925,4890,4588,4151,4891,4712,4908,4902,4713,4879,4907,4911,4919,4899,4585,4893,4888,4153,4925,4901,4890,4876,3671,4860,4880,4914,4911,4714,4883,4528,4538,4860,3822,3652,4911,4890,4907,4882,4895,4712,4129,4534,4521,3689,3828,3746,4756,907,4702,4697,4167,4521,4901,4908,4860,4883,4916,4151,4112,3945,4562,3828,4536,4574,4901,4151,4888,4594,4712,4547,4926,4712,4547,4,4604,4697,4115,4599,2911,5034,5043,5029,4997,5017,5042,5031,4102,5012,4325,4996,5038,4997,5011,3727,5013,4990,5001,3402,5012,4712,4990,5005,5001,5048,5012,5034,5001,5013,4996,5035,5042,3691,5027,4797,5043,4797,5027,5012,5029,5048,4999,5011,5017,5002,4325,5001,3676,5038,5005,5001,5000,4167,4712,4325,5001,3623,383,4996,5005,5043,364,5048,4584,4132,4600,4594,4538,4182,4102,4097,3749,3806,4712,383,4524,364,4574,4090,4698,402,1829,4508,4585,3984,4712,4564,907,4689,4141,2911,4712,383,2173,3676,4584,4975,4526,4698,4982,4604,4916,4172,4121,2914,4867,4200,4168,4966,4523,907,2173,4975,364,4559,4701,3422,4564,2911,4695,4699,4518,4519,4513,3676,4713,4699,2341,4908,4120,3683,3682,4150,4579,4098,4882,4885,4880,4151,2126,3822,4977,4908,3669,4535,4176,4712,3682,4695,4120,4893,3689,4883,4533,4178,4575,4556,213,979,1978,3790,4700,3304,3310,3533,4793,4975,4966,4582,5198,5273,5287,5244,5237,5158,5296,5176,5330,4120,308,4712,5239,5205,4594,5183,5197,4558,5315,4762,4323,5285,4539,4558,4153,5284,5163,5214,5331,5169,5221,5223,308,5204,3748,4762,5259,5199,5301,3055,5272,4570,5187,5176,2911,5274,4573,5294,5291,5194,5197,4797,5208,5236,5280,5248,5251,4151,4598,5235,5222,5175,5223,5196,5172,3871,5171,5337,4180,5299,3659,5210,5179,4603,5245,4695,3689,4591,5288,5216,5237,5304,4589,5227,5301,5225,5183,5261,4695,951,5216,5226,4603,5208,5274,5254,4591,5175,4885,5230,4703,5206,5221,5243,979,4492,5201,5192,4700,5242,5257,5247,5233,4573,5217,3906,951,4760,4695,4091,5209,3871,5235,5178,5175,4589,4712,5260,5201,5331,4137,5189,4603,5187,4589,5227,4695,5253,5242,5257,5227,4703,4713,5204,5305,5334,5330,2911,4570,5201,5288,5189,5194,5231,4700,4712,5178,5222,3726,5161,5170,5265,4762,4593,4692,5303,5245,2333,5227,5206,3808,5242,979,4548,5200,5284,5189,3690,5181,5331,5192,5215,5222,4712,3726,4598,5167,4742,5263,5205,5250,5331,4539,5229,5287,5216,5187,5200,5284,5216,5170,4492,5280,5221,5216,3005,979,951,5330,5301,5243,5204,3871,5205,4120,2911,5244,5205,5227,4570,5218,5236,5159,5260,5194,5201,5159,4120,5244,2911,5330,5249,5183,5241,5229,5230,5235,5224,5178,5222,5263,5201,5245,5197,4548,3729,4558,5270,5337,5274,5262,5219,3871,4712,2941,5185,5176,5183,4700,5337,5334,5332,5333,5200,4570,5238,5233,3169,5246,5257,5227,3748,5212,5229,4323,3844,5225,5198,5239,5190,5240,4151,4120,5254,2941,3726,4712,5178,5239,5296,4323,5198,5192,5224,4573,3748,5227,3906,5262,5232,5238,5193,3689,2914,5230,5224,4703,3005,4598,5167,5222,5206,4153,4712,5190,5240,2941,5227,5284,5330,4713,5236,5218,5216,4695,5222,5163,5273,4589,5167,5330,5166,5240,5190,4760,5330,5299,5219,5195,5249,3689,4153,5238,5274,5192,5331,5159,5288,5181,5225,5256,5238,2914,4323,3769,5174,5272,5184,5183,5160,5252,5174,4560,4689,5337,5334,5333,5332,5164,5186,5231,4700,5159,5304,4700,4137,5201,5181,5201,5218,5237,5194,5190,5240,4091,4712,5337,5334,5332,5333,4492,5204,979,5160,5198,5184,5173,4091,4151,5205,4603,5187,5259,5224,5183,5207,5178,4712,4323,5158,5185,2914,5270,5255,5219,4168,5204,5243,4695,3169,3661,5250,5192,5201,4180,5270,5219,2173,5332,383,364,383,3746,4695,1976,5291,383,4570,383,5195,4558,5251,5301,5274,4548,5245,4593,364,3065,2173,5166,5240,5239,5248,5265,5287,2911,5265,4760,951,4594,5251,4703,5233,907,5179,5271,5272,5193,5232,3689,5294,5291,3906,3748,4703,3659,3659,5257,3746,5233,5262,5291,5171,5281,5185,5158,5279,5182,3729,5194,4548,4548,5268,5306,5259,5179,4700,5189,5212,5239,4712,5294,4153,5263,5187,4695,3894,4598,5251,5222,4151,5330,4492,4594,5241,5212,4904,5239,5178,4712,5265,5211,5282,5268,4700,5159,5228,5248,5203,5193,5282,5261,5257,2914,5214,5274,5227,5263,5191,4151,5228,5175,4712,5166,5239,5178,4712,5227,5160,5158,5185,5279,5174,5233,5275,5248,3650,5268,5159,3790,4700,5161,5305,2911,5330,5315,951,5233,5163,5287,5301,2911,5330,5174,5279,5238,5281,5191,5222,4742,3808,5257,3746,4594,5230,4492,5161,5271,5213,3005,951,4713,5218,5197,3055,5237,5212,5294,5291,4700,5218,4542,5238,5262,5275,5233,5262,3844,5295,5165,3746,5225,4904,4594,5294,5291,4703,5227,5185,5285,5281,5279,5160,5174,5160,5182,5241,5174,4904,5296,2914,5238,3844,5225,907,5260,5169,5263,4700,3790,5291,5189,5212,5331,5203,5296,3661,5273,5212,5294,5262,4703,5179,5268,4137,4593,4713,5182,5274,5227,5160,5279,5161,5280,308,4492,979,5250,5192,4524,5331,5218,3844,5213,5187,4695,5280,5213,3661,4492,5212,4904,5257,5291,5262,4703,4713,5218,5197,5194,5237,5214,5254,5265,5257,5248,5265,4695,5182,5331,5245,5214,5160,5211,5288,3659,3661,5203,5179,5268,4700,5265,5306,5238,5265,5174,5251,5214,5245,5187,5226,4695,5203,5257,5248,5193,5220,5158,5185,383,5165,3689,383,5238,5234,4594,4712,5251,3690,4542,5222,5331,5250,5192,5331,5245,5279,5160,5245,5254,5237,5291,3790,4548,3790,3689,5272,5238,5279,5174,5163,5161,5301,2911,5330,5274,5227,5330,3746,5225,5294,4703,5288,3844,5225,2914,5194,5236,5168,4713,5248,5239,5190,5303,4692,5206,5274,4712,5250,5201,5331,5245,4603,5331,5265,5249,4712,5190,5163,5330,5252,5279,5207,5279,5207,4582,3746,5172,3808,5262,5265,2941,5181,4713,5250,4524,5331,5215,5191,4151,4713,4558,5270,2941,5163,5254,4692,5303,2333,5269,2914,5238,4594,5283,5201,5245,5331,5266,5174,5252,5250,5190,5166,5239,4712,3871,5263,5192,5201,5168,4091,5239,3746,4885,4153,4712,5263,5205,4603,5279,5201,5192,5331,5236,4713,5190,5201,4524,5259,5184,5249,5232,5272,5238,5222,5191,5215,5259,4168,5195,4558,5270,5178,5294,4589,5204,5197,4700,5239,5205,5254,5245,5243,5304,5260,5159,4713,5235,4492,5222,3065,2173,5386,5383,5171,5331,5214,5187,4760,4762,5396,4558,4180,4804,5385,4794,4713,4120,4151,4524,5224,5334,5248,5400,4804,4794,5190,5230,5221,5251,5394,5170,5392,5248,4573,308,5198,5213,5288,5181,5256,5245,5202,5237,5446,5462,4712,5441,5448,5438,3748,5232,3790,5445,979,5243,5451,5440,5214,5458,5436,5451,5433,5434,5331,5448,5454,5429,5429,5432,5438,5446,5455,4712,5443,5431,5265,5442,5423,5451,5432,5456,5454,5245,5440,5202,5447,5190,4712,5428,5425,4589,5201,5259,4713,5453,4603,5226,5031,4573,5291,5199,5296,5042,5459,5458,5254,3871,5429,5432,4714,5216,979,4689,293,5189,5282,4885,5257,5438,5209,5162,3065,2173,383,5228,4762,5330,5459,5436,5330,5461,5261,4929,4760,5452,5440,5427,5448,5450,5455,5462,5451,5163,2911,5426,5440,5447,5462,5438,5432,5440,5457,3661,3911,5226,5245,5457,5455,5439,5178,5280,979,4542,5244,5208,5345,5400,5385,5385,5400,5180,5201,5186,4558,5202,5268,5476,5478,5198,5476,5479,5481,5480,5479,5478,5481,5476,5479,5480,5479,5476,5265,5448,5331,5258,5216,5331,4695,3894,4929,5605,5608,5612,5605,5612,5602,5608,5612,5602,5602,5605,5608,5245,5451,5175,5291,4760,4573,3377,5694,5725,5717,5711,5719,5730,5734,5702,5724,5704,5721,5732,5733,5707,5750,5696,5727,5687,5716,5710,5751,5698,5713,5701,5738,5690,5729,5718,5716,5751,5695,5728,5701,5707,5725,5693,5693,5730,5717,5693,5691,5737,5687,5688,5727,5703,5694,5719,5739,5751,5714,5721,5724,5729,5686,5685,2911,5726,5706,5720,5692,5713,5727,5291,5294,5183,5693,5691,5730,5703,5725,5750,5715,5716,5739,5731,5721,5686,5725,5719,5703,5751,5701,5703,5720,5734,5733,5688,5738,5751,5701,5728,5732,5734,5720,5721,5740,5685,5688,5721,5720,5734,5715,5716,5739,5727,5696,5722,5697,5719,5725,5688,5731,5721,5737,5697,5750,5712,5690,5729,5738,5712,5690,5721,5732,5733,5705,5728,5698,5690,5712,5720,5720,5724,5751,5685,5701,5707,5695,5705,5700,5729,5750,5712,5694,5725,5703,5727,5692,5714,5709,5751,5727,5693,5691,5717,5712,5750,5726,5739,5716,5710,383,5859,5881,5878,5857,5914,5914,5857,5859,5881,5853,5859,5878,5859,5881,5853,5914,5878,5908,5716,5751,5687,5280,5186,5892,5930,5224,383,3065,5908)
AND
CompanyID = 1
AND
CountryID = 2 AND
WarehouseID = 1 AND
LanguageID = 1 AND
PLVCountryID = 2 AND
PriceLevel = 2
AND AllowLive = 1
AND (CatStartDt IS NULL OR CatStartDt='' OR ({ts '2020-10-25 17:22:00'}) >= CatStartDt)
AND (CatEndDt IS NULL OR CatEndDt='' OR ({ts '2020-10-25 17:22:00'}) <= CatEndDt)
AND AllowOrderEntry=1
AND (
AllowPLVList='' OR AllowPLVList IS NULL
OR AllowPLVList='2'
OR AllowPLVList like '2,%'
OR AllowPLVList like '%,2,%'
OR AllowPLVList like '%,2'
)
AND CategoryAllowOrderEntry=1
AND (CatFlagNumOnly = 0
)
AND (FlagNumOnly = 0
)
ORDER BY CategoryName ASC, Sequence ASC, ItemCode ASC |
|
| Sql | | string | SELECT *
FROM CategoryProduct_View
WHERE
ProductID in (292,13,193,200,194,149,221,222,3067,3067,1714,899,3016,3064,2946,2963,2935,2951,2955,213,2939,2944,2942,2944,2942,2939,1797,2124,3007,2979,3057,2979,3022,980,3022,3048,338,3002,3002,3029,3029,338,275,907,47,2947,2123,907,47,1740,907,47,2947,4,275,3012,3005,2943,3005,3005,3170,2978,1793,2978,298,2967,2967,2182,298,2182,3027,2987,2995,2954,3054,2954,3054,2954,3054,2954,315,2954,314,2954,238,3036,216,2994,238,3036,216,2994,238,3036,216,2994,3020,13,35,2994,3020,13,35,2994,3020,238,3036,216,2958,1716,1798,2090,879,2090,879,2090,3028,1716,3028,2958,934,2941,2153,2941,3154,3168,2948,3153,2949,3151,3158,3160,3188,3160,3158,3188,3160,3158,2948,3151,2983,3153,3188,3158,2983,3188,2949,3151,3153,3160,295,2982,3055,3055,2911,980,3022,2914,2911,3152,3153,3169,3150,3188,2914,2911,3156,3165,3159,3165,3159,3156,3123,3122,3149,2914,3161,2914,2126,3141,1716,1735,38,395,38,2955,368,38,2955,3011,38,2955,3031,38,2955,3031,3011,395,368,3031,3011,395,368,263,1115,1713,1399,2945,2119,77,951,951,2119,77,308,951,261,77,1713,1322,77,77,308,951,2063,922,2059,2065,3006,2993,3006,2993,3006,2993,3004,2981,3001,2993,2950,2999,3004,402,2981,3001,3006,2950,2999,3006,2993,3006,2993,3044,3023,402,3188,2088,2953,2986,3046,2986,1735,1716,2975,3056,1317,2059,2969,2988,2969,2940,3056,2996,3042,3056,3056,2988,3038,3056,449,2969,2990,2996,2940,48,31,1859,31,1859,2169,2169,48,31,1859,2169,48,31,1859,3030,604,2196,2964,604,2196,1760,1710,1760,1710,1317,2059,3060,2059,3060,1317,2341,3043,2341,3043,2341,3043,2976,2957,3009,2971,2341,3053,3016,2987,315,314,2945,2973,3014,2998,2945,3008,2972,3014,2998,3008,979,2998,295,2131,979,1742,1738,979,2131,979,374,432,3045,2974,3035,3020,3013,2922,2994,3045,3003,2966,346,2919,3003,3045,3003,2966,3045,3003,2966,3045,1345,2970,2974,1380,3024,3037,3013,474,2922,3045,3003,2974,3037,3013,2922,2966,1109,3021,3010,2989,3034,2959,3039,2951,2956,2968,2951,3039,2951,2956,3039,2968,520,559,2015,512,525,1795,481,487,2015,1795,952,484,990,559,512,955,525,481,487,484,520,512,525,481,487,955,484,3035,520,559,990,952,525,481,2015,1795,487,955,3035,484,520,990,952,559,1795,512,525,481,487,955,3035,990,952,484,2015,520,559,512,525,481,487,361,2919,484,520,559,512,525,481,3194,3536,3458,3307,3361,3329,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,2126,3006,3389,2943,3318,3305,907,48,35,3006,3389,2126,3955,3942,4167,1978,286,4546,4526,4577,4090,4094,4110,4536,4509,3741,3866,3798,4542,3748,1978,4573,4595,3862,4522,4574,4563,3714,3722,3853,4108,4090,4560,4174,2979,3730,4515,4091,3802,286,4200,4155,263,4100,3450,3722,3984,4583,4557,4604,4601,4548,1829,240,3919,4524,4550,4565,3838,4011,3895,4556,4563,4532,4587,227,4578,2333,2945,1115,4166,308,3671,3726,3708,3828,3872,3720,4569,4107,3746,4117,4573,4521,4513,2947,4132,4572,4578,4113,4520,402,1829,4089,4096,3806,4594,4589,2126,2333,263,4573,4053,275,4600,263,4132,3862,4598,4178,227,4533,4591,3822,4582,3984,4093,3808,4091,4537,1978,4131,3450,4572,1829,4102,3795,4507,3983,4582,3747,3826,4170,4540,4512,2982,4521,4117,3403,4589,4599,4580,4549,4117,4510,4517,4516,4591,3729,240,4521,4131,4112,4175,4113,3825,4570,3850,4120,2333,263,4556,4091,4563,295,3512,4623,4531,3671,4106,3895,286,4593,295,3682,2919,4600,4524,4114,2173,3022,4601,4566,3747,3726,3941,4552,4540,4538,4170,4512,3005,2952,4593,4534,4537,1829,3741,3668,3919,4565,4538,3844,3655,3741,3866,4154,4150,4576,4090,4094,4098,907,2986,4548,4121,4172,4117,4538,3676,3309,3850,4120,3512,4151,4152,3806,4141,4534,3822,4510,4552,3726,4589,3862,4178,4096,4106,4532,979,238,3748,4546,4599,3676,3726,4552,3862,1829,402,4524,4557,3983,4117,3862,3402,3403,4601,4581,2126,4589,4578,3683,3806,4514,4565,3838,4522,4581,4115,3022,4175,4128,3862,4121,4094,4539,4102,4097,4595,3065,4567,3676,3838,3795,4097,4547,4595,3720,3727,4176,4590,4559,4113,3329,3730,4168,4180,885,3512,295,4153,3862,3749,3844,4577,4170,3838,3726,4552,3739,4131,4534,4107,3798,3668,3741,4573,4117,4589,2126,4585,4152,4549,4569,4523,4100,3850,4570,4113,4511,4527,4538,3747,4151,3726,4539,4538,3838,3745,4106,3844,4137,4519,3838,4110,4094,3739,3380,4160,3790,3850,4582,4117,4180,3715,4168,3683,3749,3984,213,979,4107,4517,4585,4598,4107,4517,3512,295,2911,3022,4575,4178,4518,3652,286,4529,3945,3691,3450,4154,4098,4167,4538,4512,4170,4556,4574,4515,3691,4524,3450,3191,2914,4530,3825,4172,4518,4113,2979,3022,4554,3941,3862,4568,3683,4578,2979,3022,3380,3822,4582,4120,3757,3329,4180,3539,3310,3316,4583,4557,3708,3798,3741,3668,3402,3003,3862,4573,4550,3790,4580,4117,4510,4559,3797,2341,4538,4094,4577,4601,3682,4592,4110,4090,4536,4108,3671,4155,4096,4557,4113,4521,1829,4588,1829,4588,907,4115,4514,4153,4534,4107,4131,213,4542,3690,275,4524,3838,3749,3806,3683,4549,4117,4572,2173,383,3945,383,4544,364,3065,3746,2173,364,383,2173,3844,3065,383,3911,3196,3922,3911,3422,3922,364,4572,383,2173,64,3533,3304,3316,3410,3304,3533,3312,3533,3410,3304,3316,3304,3539,3539,3304,3310,3304,2310,2173,364,383,3304,3304,383,2173,383,2173,3304,383,2173,3304,4018,58,40,4101,58,61,4018,4101,42,3838,4117,3798,61,40,3300,40,3254,3275,3082,4330,61,923,60,3275,948,3254,60,982,61,3275,92,3082,3418,3254,3275,948,3275,3082,4330,3254,61,40,3300,58,4619,4330,40,61,3275,3254,42,4101,4018,58,4619,4616,58,4616,3275,3254,4620,4018,58,4665,300,59,2325,265,3109,4407,59,2323,4409,2312,2325,2310,4549,4576,4117,4623,3862,4598,4566,4151,3652,4574,4563,4513,3894,3895,979,3806,4562,4153,4575,4533,3862,3623,4538,3826,4547,4102,4604,4129,4117,1978,4516,4585,4011,4112,4128,3862,3746,4574,3808,4542,979,4528,1978,4534,4107,4590,4113,4167,4150,4576,3798,4523,3872,4106,4117,3790,4137,4530,3825,4547,4102,4115,3806,3862,3708,4525,979,3798,4515,3838,4524,361,3512,3329,4172,4094,4153,4151,3822,3862,4547,4102,3795,4094,4509,4110,4090,4545,4151,3862,4547,3795,4113,4538,4512,3826,4106,4096,3822,4555,3676,4574,3862,4097,4102,3862,4596,951,4520,4590,3797,4113,3689,3806,3862,3659,4563,4536,3853,4588,3876,4600,3380,3838,4530,2341,4543,4107,3808,4541,4526,4599,3676,4200,3671,4096,4114,2911,3895,3844,3838,4604,3846,4106,4096,4562,4534,4107,4137,3309,4600,3876,4588,4518,4568,3853,3683,3862,3659,3806,3862,3655,4596,2341,4588,4520,3872,4523,3669,3684,3720,4598,3862,4117,3403,3402,4526,3862,4515,3838,4587,4513,3838,4538,3862,4579,4527,3668,3866,3802,4102,4097,3795,4527,4579,4563,4090,4098,4094,4574,4563,3808,3812,3329,4174,4535,990,3450,4588,4508,4623,3862,88,3826,3797,3412,4623,4113,3682,4098,4094,4090,3846,3671,2126,3671,4200,3862,4600,3862,3708,4174,3669,4180,4116,4552,3652,4583,3941,3983,3669,4200,4106,3403,3402,3984,4137,4515,3838,4548,4575,4533,702,666,2345,979,213,4529,295,2979,979,3894,213,979,4529,4542,979,286,4113,4529,213,4528,4113,4529,3895,4113,3422,213,4528,3691,990,3838,4524,3798,3450,3802,4548,3667,4522,3876,4107,3380,2986,907,3691,3450,907,4519,3838,4565,4587,3512,3022,364,383,2173,4549,4572,2173,2173,383,364,3309,4549,2173,383,364,2173,2173,383,364,383,2173,364,383,2173,364,3922,3906,3207,3691,3838,4600,4522,3919,4011,4137,3691,3512,4522,3802,3876,3741,3798,3668,4011,3667,1829,4564,4581,3876,885,4576,885,4576,885,4576,885,4576,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,885,4576,885,4576,4576,885,4576,885,4576,885,4576,885,3022,4151,4113,4576,885,4576,885,4576,885,4576,885,4576,885,885,4576,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4576,885,4540,286,4117,4540,4113,286,4540,286,4113,4540,286,4113,4540,286,4113,4113,286,4540,4540,4113,286,4113,4540,286,275,402,3798,275,402,3798,402,3798,275,402,3798,275,275,402,3798,402,275,3798,402,275,3798,402,275,3798,4113,286,3945,286,4113,3945,3945,4113,286,4113,286,3945,4113,286,3945,4113,286,3945,4113,286,3945,3741,3667,4107,3741,3667,4107,3741,3667,4107,3741,3667,4107,4107,3667,3741,3741,3667,4107,3741,3667,4107,3741,3667,4107,979,4113,213,979,4113,213,979,4113,213,979,4113,213,979,4113,213,4113,979,213,979,4113,213,4581,4551,3838,4551,3838,4581,3838,4581,4551,4551,4581,3838,4551,3838,4581,4581,4551,3838,4581,4551,3838,4551,3838,4581,3826,4182,3108,3108,3826,4182,3826,4182,3108,3826,4182,3108,4519,4524,4011,4519,4524,4011,4011,4524,4519,4524,4519,4011,3795,3739,4541,3652,4151,4563,4512,4599,4712,4581,4736,4712,4734,3683,4570,2126,4584,4713,4517,4513,907,4549,383,4519,4524,61,3418,4330,64,4725,3546,3275,3082,4715,42,61,40,948,4715,4725,4726,4711,4723,60,4715,3275,3418,3300,42,4764,979,4543,4765,4542,979,3676,4526,4604,4769,4600,4766,4769,4541,4703,4746,4744,4699,4745,2125,4712,4766,4756,4748,4756,4766,4700,4748,4767,4712,4582,4531,4564,4712,4151,3749,2911,4568,4713,4768,4767,4558,383,4549,364,3674,4127,4584,4754,3661,3984,4770,4747,3674,4771,4524,4699,4771,4702,4604,4584,4571,4127,4594,4541,4102,4753,4771,4751,3689,4526,3539,4593,4547,4541,4555,4567,4771,4740,4762,4552,4743,3676,4513,4176,4556,3871,4755,4552,2911,4737,4749,4760,4100,4772,3872,3661,4570,3690,4564,4702,4766,4797,4745,4769,4748,4712,4767,4796,4753,4754,4794,4804,4767,4804,4755,4745,4746,4769,4793,4745,4766,4767,4768,4748,4804,4794,4767,4712,58,61,4620,4893,4167,4888,3739,4541,4214,4925,4890,4588,4151,4891,4712,4908,4902,4713,4879,4907,4911,4919,4899,4585,4893,4888,4153,4925,4901,4890,4876,3671,4860,4880,4914,4911,4714,4883,4528,4538,4860,3822,3652,4911,4890,4907,4882,4895,4712,4129,4534,4521,3689,3828,3746,4756,907,4702,4697,4167,4521,4901,4908,4860,4883,4916,4151,4112,3945,4562,3828,4536,4574,4901,4151,4888,4594,4712,4547,4926,4712,4547,4,4604,4697,4115,4599,2911,5034,5043,5029,4997,5017,5042,5031,4102,5012,4325,4996,5038,4997,5011,3727,5013,4990,5001,3402,5012,4712,4990,5005,5001,5048,5012,5034,5001,5013,4996,5035,5042,3691,5027,4797,5043,4797,5027,5012,5029,5048,4999,5011,5017,5002,4325,5001,3676,5038,5005,5001,5000,4167,4712,4325,5001,3623,383,4996,5005,5043,364,5048,4584,4132,4600,4594,4538,4182,4102,4097,3749,3806,4712,383,4524,364,4574,4090,4698,402,1829,4508,4585,3984,4712,4564,907,4689,4141,2911,4712,383,2173,3676,4584,4975,4526,4698,4982,4604,4916,4172,4121,2914,4867,4200,4168,4966,4523,907,2173,4975,364,4559,4701,3422,4564,2911,4695,4699,4518,4519,4513,3676,4713,4699,2341,4908,4120,3683,3682,4150,4579,4098,4882,4885,4880,4151,2126,3822,4977,4908,3669,4535,4176,4712,3682,4695,4120,4893,3689,4883,4533,4178,4575,4556,213,979,1978,3790,4700,3304,3310,3533,4793,4975,4966,4582,5198,5273,5287,5244,5237,5158,5296,5176,5330,4120,308,4712,5239,5205,4594,5183,5197,4558,5315,4762,4323,5285,4539,4558,4153,5284,5163,5214,5331,5169,5221,5223,308,5204,3748,4762,5259,5199,5301,3055,5272,4570,5187,5176,2911,5274,4573,5294,5291,5194,5197,4797,5208,5236,5280,5248,5251,4151,4598,5235,5222,5175,5223,5196,5172,3871,5171,5337,4180,5299,3659,5210,5179,4603,5245,4695,3689,4591,5288,5216,5237,5304,4589,5227,5301,5225,5183,5261,4695,951,5216,5226,4603,5208,5274,5254,4591,5175,4885,5230,4703,5206,5221,5243,979,4492,5201,5192,4700,5242,5257,5247,5233,4573,5217,3906,951,4760,4695,4091,5209,3871,5235,5178,5175,4589,4712,5260,5201,5331,4137,5189,4603,5187,4589,5227,4695,5253,5242,5257,5227,4703,4713,5204,5305,5334,5330,2911,4570,5201,5288,5189,5194,5231,4700,4712,5178,5222,3726,5161,5170,5265,4762,4593,4692,5303,5245,2333,5227,5206,3808,5242,979,4548,5200,5284,5189,3690,5181,5331,5192,5215,5222,4712,3726,4598,5167,4742,5263,5205,5250,5331,4539,5229,5287,5216,5187,5200,5284,5216,5170,4492,5280,5221,5216,3005,979,951,5330,5301,5243,5204,3871,5205,4120,2911,5244,5205,5227,4570,5218,5236,5159,5260,5194,5201,5159,4120,5244,2911,5330,5249,5183,5241,5229,5230,5235,5224,5178,5222,5263,5201,5245,5197,4548,3729,4558,5270,5337,5274,5262,5219,3871,4712,2941,5185,5176,5183,4700,5337,5334,5332,5333,5200,4570,5238,5233,3169,5246,5257,5227,3748,5212,5229,4323,3844,5225,5198,5239,5190,5240,4151,4120,5254,2941,3726,4712,5178,5239,5296,4323,5198,5192,5224,4573,3748,5227,3906,5262,5232,5238,5193,3689,2914,5230,5224,4703,3005,4598,5167,5222,5206,4153,4712,5190,5240,2941,5227,5284,5330,4713,5236,5218,5216,4695,5222,5163,5273,4589,5167,5330,5166,5240,5190,4760,5330,5299,5219,5195,5249,3689,4153,5238,5274,5192,5331,5159,5288,5181,5225,5256,5238,2914,4323,3769,5174,5272,5184,5183,5160,5252,5174,4560,4689,5337,5334,5333,5332,5164,5186,5231,4700,5159,5304,4700,4137,5201,5181,5201,5218,5237,5194,5190,5240,4091,4712,5337,5334,5332,5333,4492,5204,979,5160,5198,5184,5173,4091,4151,5205,4603,5187,5259,5224,5183,5207,5178,4712,4323,5158,5185,2914,5270,5255,5219,4168,5204,5243,4695,3169,3661,5250,5192,5201,4180,5270,5219,2173,5332,383,364,383,3746,4695,1976,5291,383,4570,383,5195,4558,5251,5301,5274,4548,5245,4593,364,3065,2173,5166,5240,5239,5248,5265,5287,2911,5265,4760,951,4594,5251,4703,5233,907,5179,5271,5272,5193,5232,3689,5294,5291,3906,3748,4703,3659,3659,5257,3746,5233,5262,5291,5171,5281,5185,5158,5279,5182,3729,5194,4548,4548,5268,5306,5259,5179,4700,5189,5212,5239,4712,5294,4153,5263,5187,4695,3894,4598,5251,5222,4151,5330,4492,4594,5241,5212,4904,5239,5178,4712,5265,5211,5282,5268,4700,5159,5228,5248,5203,5193,5282,5261,5257,2914,5214,5274,5227,5263,5191,4151,5228,5175,4712,5166,5239,5178,4712,5227,5160,5158,5185,5279,5174,5233,5275,5248,3650,5268,5159,3790,4700,5161,5305,2911,5330,5315,951,5233,5163,5287,5301,2911,5330,5174,5279,5238,5281,5191,5222,4742,3808,5257,3746,4594,5230,4492,5161,5271,5213,3005,951,4713,5218,5197,3055,5237,5212,5294,5291,4700,5218,4542,5238,5262,5275,5233,5262,3844,5295,5165,3746,5225,4904,4594,5294,5291,4703,5227,5185,5285,5281,5279,5160,5174,5160,5182,5241,5174,4904,5296,2914,5238,3844,5225,907,5260,5169,5263,4700,3790,5291,5189,5212,5331,5203,5296,3661,5273,5212,5294,5262,4703,5179,5268,4137,4593,4713,5182,5274,5227,5160,5279,5161,5280,308,4492,979,5250,5192,4524,5331,5218,3844,5213,5187,4695,5280,5213,3661,4492,5212,4904,5257,5291,5262,4703,4713,5218,5197,5194,5237,5214,5254,5265,5257,5248,5265,4695,5182,5331,5245,5214,5160,5211,5288,3659,3661,5203,5179,5268,4700,5265,5306,5238,5265,5174,5251,5214,5245,5187,5226,4695,5203,5257,5248,5193,5220,5158,5185,383,5165,3689,383,5238,5234,4594,4712,5251,3690,4542,5222,5331,5250,5192,5331,5245,5279,5160,5245,5254,5237,5291,3790,4548,3790,3689,5272,5238,5279,5174,5163,5161,5301,2911,5330,5274,5227,5330,3746,5225,5294,4703,5288,3844,5225,2914,5194,5236,5168,4713,5248,5239,5190,5303,4692,5206,5274,4712,5250,5201,5331,5245,4603,5331,5265,5249,4712,5190,5163,5330,5252,5279,5207,5279,5207,4582,3746,5172,3808,5262,5265,2941,5181,4713,5250,4524,5331,5215,5191,4151,4713,4558,5270,2941,5163,5254,4692,5303,2333,5269,2914,5238,4594,5283,5201,5245,5331,5266,5174,5252,5250,5190,5166,5239,4712,3871,5263,5192,5201,5168,4091,5239,3746,4885,4153,4712,5263,5205,4603,5279,5201,5192,5331,5236,4713,5190,5201,4524,5259,5184,5249,5232,5272,5238,5222,5191,5215,5259,4168,5195,4558,5270,5178,5294,4589,5204,5197,4700,5239,5205,5254,5245,5243,5304,5260,5159,4713,5235,4492,5222,3065,2173,5386,5383,5171,5331,5214,5187,4760,4762,5396,4558,4180,4804,5385,4794,4713,4120,4151,4524,5224,5334,5248,5400,4804,4794,5190,5230,5221,5251,5394,5170,5392,5248,4573,308,5198,5213,5288,5181,5256,5245,5202,5237,5446,5462,4712,5441,5448,5438,3748,5232,3790,5445,979,5243,5451,5440,5214,5458,5436,5451,5433,5434,5331,5448,5454,5429,5429,5432,5438,5446,5455,4712,5443,5431,5265,5442,5423,5451,5432,5456,5454,5245,5440,5202,5447,5190,4712,5428,5425,4589,5201,5259,4713,5453,4603,5226,5031,4573,5291,5199,5296,5042,5459,5458,5254,3871,5429,5432,4714,5216,979,4689,293,5189,5282,4885,5257,5438,5209,5162,3065,2173,383,5228,4762,5330,5459,5436,5330,5461,5261,4929,4760,5452,5440,5427,5448,5450,5455,5462,5451,5163,2911,5426,5440,5447,5462,5438,5432,5440,5457,3661,3911,5226,5245,5457,5455,5439,5178,5280,979,4542,5244,5208,5345,5400,5385,5385,5400,5180,5201,5186,4558,5202,5268,5476,5478,5198,5476,5479,5481,5480,5479,5478,5481,5476,5479,5480,5479,5476,5265,5448,5331,5258,5216,5331,4695,3894,4929,5605,5608,5612,5605,5612,5602,5608,5612,5602,5602,5605,5608,5245,5451,5175,5291,4760,4573,3377,5694,5725,5717,5711,5719,5730,5734,5702,5724,5704,5721,5732,5733,5707,5750,5696,5727,5687,5716,5710,5751,5698,5713,5701,5738,5690,5729,5718,5716,5751,5695,5728,5701,5707,5725,5693,5693,5730,5717,5693,5691,5737,5687,5688,5727,5703,5694,5719,5739,5751,5714,5721,5724,5729,5686,5685,2911,5726,5706,5720,5692,5713,5727,5291,5294,5183,5693,5691,5730,5703,5725,5750,5715,5716,5739,5731,5721,5686,5725,5719,5703,5751,5701,5703,5720,5734,5733,5688,5738,5751,5701,5728,5732,5734,5720,5721,5740,5685,5688,5721,5720,5734,5715,5716,5739,5727,5696,5722,5697,5719,5725,5688,5731,5721,5737,5697,5750,5712,5690,5729,5738,5712,5690,5721,5732,5733,5705,5728,5698,5690,5712,5720,5720,5724,5751,5685,5701,5707,5695,5705,5700,5729,5750,5712,5694,5725,5703,5727,5692,5714,5709,5751,5727,5693,5691,5717,5712,5750,5726,5739,5716,5710,383,5859,5881,5878,5857,5914,5914,5857,5859,5881,5853,5859,5878,5859,5881,5853,5914,5878,5908,5716,5751,5687,5280,5186,5892,5930,5224,383,3065,5908)
AND
CompanyID = 1
AND
CountryID = 2 AND
WarehouseID = 1 AND
LanguageID = 1 AND
PLVCountryID = 2 AND
PriceLevel = 2
AND AllowLive = 1
AND (CatStartDt IS NULL OR CatStartDt='' OR ({ts '2020-10-25 17:22:00'}) >= CatStartDt)
AND (CatEndDt IS NULL OR CatEndDt='' OR ({ts '2020-10-25 17:22:00'}) <= CatEndDt)
AND AllowOrderEntry=1
AND (
AllowPLVList='' OR AllowPLVList IS NULL
OR AllowPLVList='2'
OR AllowPLVList like '2,%'
OR AllowPLVList like '%,2,%'
OR AllowPLVList like '%,2'
)
AND CategoryAllowOrderEntry=1
AND (CatFlagNumOnly = 0
)
AND (FlagNumOnly = 0
)
ORDER BY CategoryName ASC, Sequence ASC, ItemCode ASC |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException:
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:393)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:280)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:224)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
at lucee.runtime.tag.Query.doEndTag(Query.java:700)
at system.modules.shoppingcart.modules.search.actions.act_searchproducts_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Search/Actions/act_SearchProducts.cfm:137)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at system.modules.shoppingcart.modules.recommended.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Recommended/fbx_Switch.cfm:30)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:817)
at lucee.runtime.tag.CFTag.doInclude(CFTag.java:328)
at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:249)
at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:180)
at custom.modules.shoppingcart.modules.categories.skins.skin01.dsp_detaillayout_cfm$cf.call(/RootDir/custom/modules/ShoppingCart/Modules/Categories/skins/skin01/dsp_DetailLayout.cfm:198)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:78)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at __138.__138.plunderdesign_iact630.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../plunderdesign-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:129)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:89)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:225)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
at lucee.runtime.engine.Request.exe(Request.java:44)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1091)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1039)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 135: </cfif><br>
136: ORDER BY CategoryName ASC, Sequence ASC, ItemCode ASC<br>
<b>137: </cfquery></b><br>
138: <cfif ProductCategoryQuery.RecordCount eq 0><br>
139: <cfquery name="ProductCategoryQuery" datasource="#REQUEST.NetTraxDataSource#" cachedwithin="#CreateTimeSpan(0,0,1,0)#"><br>
|
| | codePrintPlain | | string | 135: </cfif>
136: ORDER BY CategoryName ASC, Sequence ASC, ItemCode ASC
137: </cfquery>
138: <cfif ProductCategoryQuery.RecordCount eq 0>
139: <cfquery name="ProductCategoryQuery" datasource="#REQUEST.NetTraxDataSource#" cachedwithin="#CreateTimeSpan(0,0,1,0)#">
|
| | column | | | id | | | line | | | Raw_Trace | | string | system.modules.shoppingcart.modules.search.actions.act_searchproducts_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Search/Actions/act_SearchProducts.cfm:137) |
| | template | | string | /www/plunderdesign-iact/system/modules/ShoppingCart/Modules/Search/Actions/act_SearchProducts.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 28: <!--- END:WF:118229 - Connie M ---><br>
29: <br>
<b>30: <cfinclude template="#CallFile('act_SearchProducts.cfm','ShoppingCart.Modules.Search.Actions')#"></b><br>
31: <cfsavecontent variable="VARIABLES.qtyfocus"><br>
32: onFocus="if(this.value == '1') { this.value = ''; }"<br>
|
| | codePrintPlain | | string | 28: <!--- END:WF:118229 - Connie M --->
29:
30: <cfinclude template="#CallFile('act_SearchProducts.cfm','ShoppingCart.Modules.Search.Actions')#">
31: <cfsavecontent variable="VARIABLES.qtyfocus">
32: onFocus="if(this.value == '1') { this.value = ''; }"
|
| | column | | | id | | | line | | | Raw_Trace | | string | system.modules.shoppingcart.modules.recommended.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Recommended/fbx_Switch.cfm:30) |
| | template | | string | /www/plunderdesign-iact/system/modules/ShoppingCart/Modules/Recommended/fbx_Switch.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 196: <br>
197: <div id="recommended_items" class="ui bottom attached basic segment"><br>
<b>198: <cfmodule template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.Recommended')#" fusesubaction="SearchProducts"></b><br>
199: </div><br>
200: </div><br>
|
| | codePrintPlain | | string | 196:
197: <div id="recommended_items" class="ui bottom attached basic segment">
198: <cfmodule template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.Recommended')#" fusesubaction="SearchProducts">
199: </div>
200: </div>
|
| | column | | | id | | | line | | | Raw_Trace | | string | custom.modules.shoppingcart.modules.categories.skins.skin01.dsp_detaillayout_cfm$cf.call(/RootDir/custom/modules/ShoppingCart/Modules/Categories/skins/skin01/dsp_DetailLayout.cfm:198) |
| | template | | string | /www/plunderdesign-iact/custom/modules/ShoppingCart/Modules/Categories/skins/skin01/dsp_DetailLayout.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 76: <cfinclude template="#CallFile('dsp_DetailSocialMedia.cfm')#"><br>
77: <cfinclude template="#CallFile('dsp_DetailRow.cfm')#"><br>
<b>78: <cfinclude template="#CallFile('dsp_DetailLayout.cfm')#"></b><br>
79: </cfif><br>
80: <cfelse><br>
|
| | codePrintPlain | | string | 76: <cfinclude template="#CallFile('dsp_DetailSocialMedia.cfm')#">
77: <cfinclude template="#CallFile('dsp_DetailRow.cfm')#">
78: <cfinclude template="#CallFile('dsp_DetailLayout.cfm')#">
79: </cfif>
80: <cfelse>
|
| | column | | | id | | | line | | | Raw_Trace | | string | system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:78) |
| | template | | string | /www/plunderdesign-iact/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 13: <cfset FuseSubAction="AllByCategory"><br>
14: <cfset FuseDirectory="Categories"><br>
<b>15: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"></b><br>
16: </cfif><br>
17: <br>
|
| | codePrintPlain | | string | 13: <cfset FuseSubAction="AllByCategory">
14: <cfset FuseDirectory="Categories">
15: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#">
16: </cfif>
17:
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.plunderdesign_iact630.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../plunderdesign-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15) |
| | template | | string | /www/plunderdesign-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 127: <!--- WF 95086 ---><br>
128: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---><br>
<b>129: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"></b><br>
130: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---><br>
131: <cfsetting showdebugoutput="yes"><br>
|
| | codePrintPlain | | string | 127: <!--- WF 95086 --->
128: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679--->
129: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#">
130: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679--->
131: <cfsetting showdebugoutput="yes">
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:129) |
| | template | | string | /www/plunderdesign-iact/system/modules/ShoppingCart/fbx_Switch.cfm |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 87: <br>
88: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---><br>
<b>89: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm"></b><br>
|
| | codePrintPlain | | string | 87:
88: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory--->
89: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:89) |
| | template | | string | /www/plunderdesign-iact/wwwroot/ShoppingCart/index.cfm |
| | type | |
|
|
| type | |
| where | |
