MySQL Query:SELECT p.itemid,p.title,p.catid,p.thumb,p.thumb1,p.thumb2,p.linkurl,p.hits,p.company,p.username,p.introduce,c.isssl,c.domain,c.linkurl companyUrl,c.thumb companyThumb,ct.catname,ct.linkurl categoryLinkurl FROM [pre]products_5 AS p LEFT JOIN [pre]company AS c ON p.username=c.username LEFT JOIN [pre]category AS ct ON p.catid=ct.catid WHERE status=3 AND p.catid IN (2241,3111,2242,2378,2379,2380,2381,2243,2387,2246,2247,2248,2249,2250,2251,2252,2461,2462,2498,2499,2568,2544,2545,2563,2564,2565,2605,2627,2628,2629,2631,2647,2633,2648,2649,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2673,2674,2676,2679,2680,2686,2697,3437,3438,3570,2687,2698,2699,2700,3689,2702,2714,2776,2715,2783,2784,2719,2748,2902,2903,2788,2790,2791,2792,2793,2809,2810,2816,2817,2835,2840,2841,2836,2842,2843,2837,2839,2853,2855,2856,2858,2862,2859,2863,2871,2872,2881,2892,2882,2888,2889,2883,2884,2885,2886,2887,2908,2909,2910,2918,2920,2921,3058,3059,3060,2924,2976,2977,2978,2979,3018,3025,3026,3027,3109,3151,4050,4247,2931,2947,2948,2949,2950,3034,3035,3036,3037,3038,2932,2953,2954,2955,2956,3040,2933,3003,3016,2934,3004,3019,2935,2958,2959,2960,2961,2962,2963,2964,3014,3028,3029,3030,3031,3032,3033,3185,2936,3001,2972,2997,2998,3017,2973,3002,3005,3007,3008,3009,3010,3011,3012,3013,3020,3021,3022,3023,3024,3145,2985,2987,2988,2989,2990,2991,2992,2993,2994,2995,3045,3056,3057,3046,3065,3047,3052,3053,3054,3055,3049,3067,3068,3069,3050,3062,3126,3134,3073,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3086,3092,3101,3102,3105,3108,3135,3136,3138,3139,3153,3161,3162,3163,3172,3157,3168,3169,3158,3231,3159,3165,3173,4066,4067,3183,3453,3455,3757,4061,3186,3188,3195,3196,3198,3199,3203,3205,3206,3207,3217,3208,3209,3210,3211,3212,3219,3220,3221,3222,3223,3225,3226,3228,3242,3247,3482,3263,3274,3264,3275,3276,3266,3277,3278,3267,3279,3268,3280,3281,3270,3288,3271,3289,3272,3290,3291,4012,4013,3293,3294,3295,3296,3297,3298,3310,3311,3312,3313,3314,3315,3316,3317,3319,3320,3321,3322,3328,3329,3331,3332,3456,3458,3342,3349,3351,3352,3343,3348,3353,3354,3355,3448,3344,3478,3345,3346,3347,3361,3375,3380,3381,3387,3388,3389,3390,3503,3363,3378,3379,3364,3366,3369,3370,3371,3372,3373,3374,3365,3382,3383,3384,3385,3391,3394,3481,3392,3396,3393,3449,3401,3430,3431,3402,3403,3405,3413,3409,3416,3410,3418,3411,3419,3420,3421,3412,3422,3423,3424,3432,3425,3426,3427,3428,3429,3440,3441,3442,3444,3443,3447,3445,4072,4073,4074,4075,3461,3468,3469,3470,3463,3471,3476,3477,3483,3488,4175,3484,3486,3487,3485,3504,3506,3507,3510,3505,3509,3511,3572,3573,3574,3513,3585,3586,3587,3514,3583,3584,3515,3589,3516,3588,3517,3603,3604,3605,3606,3531,3535,3532,3536,3533,3537,3538,3539,3541,3542,3543,3545,3546,3547,3548,3549,3550,3556,3557,3558,3559,3560,3561,3551,3552,3553,3554,3555,3562,3563,3568,3569,3590,3591,3592,3594,3597,3598,3599,3600,3601,3602,3607,3608,3609,3611,3610,3612,3623,3626,3624,3627,3630,3633,3634,3638,3635,3671,3636,3654,3658,3668,3669,3670,3643,3644,3645,3646,3647,3649,3650,3651,4052,3659,3660,3663,3666,3667,3672,3673,3677,3679,3716,3717,3723,3680,3742,3686,3688,3696,3697,3698,3699,3700,3701,3702,3703,3704,3705,3706,3707,3708,3709,3710,3711,3712,3713,3727,3728,3729,3730,3731,3732,3733,3734,3744,3748,3749,3750,3745,3752,3753,3754,3755,3756,3758,3759,4057,4058,3761,3762,3763,3767,3768,3771,3772,3769,3770,3773,3778,3779,3780,3781,3782,3783,3784,3785,3786,3787,3788,3789,3790,3791,3774,3793,3794,3796,3797,3798,3799,3800,3801,3802,3803,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3980,3981,3982,3983,3984,3985,3775,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3839,3840,3841,3842,3843,3844,3845,3846,3847,3848,3849,3850,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3861,3862,3776,3863,3864,3865,3866,3867,3868,3869,3870,3871,3872,3873,3777,3874,3875,3876,3877,3878,3879,3880,3881,3882,3883,3884,3885,3886,3887,3888,3889,3890,3891,3892,3893,3895,3896,3897,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911,3912,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3924,3925,3926,3927,3928,3929,3930,3931,3932,3933,3934,3935,3936,3945,3946,3937,3947,3948,3949,3938,3950,3951,3952,3953,3939,3954,3955,3956,3940,3957,3958,3959,3960,3961,3941,3962,3963,3964,3965,3966,3942,3967,3968,3969,3943,3970,3971,3972,3944,3973,3974,3975,3976,3977,3978,3987,3989,3990,3991,3993,3994,3998,3999,4000,4001,4002,4003,4004,4005,4007,4014,4015,4016,4017,4018,4019,4024,4020,4021,4022,4023,4029,4037,4038,4036,4039,4040,4041,4042,4043,4044,4045,4046,4053,4054,4059,4060,4062,4063,4064,4065,4068,4069,4070,4071,4079,4080,4081,4082,4083,4084,4085,4410,4450,4453,4091,4092,4093,4121,4123,4124,4125,4126,4127,4128,4129,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,4143,4144,4145,4146,4147,4148,4150,4864,4866,4160,4862,4863,4164,4165,4166,4167,4168,4169,4170,4172,4174,4180,4183,4184,4185,4181,4182,4190,4191,4244,4245,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4212,4213,4214,4215,4216,4217,4218,4219,4220,4449,4223,4224,4225,4226,4227,4228,4229,4230,4231,4401,4233,4234,4235,4238,4240,4236,4237,4241,4242,4249,4254,4250,4251,4252,4253,4258,4279,4280,4281,4282,4283,4284,4285,4286,4287,4259,4288,4289,4290,4291,4292,4293,4260,4294,4295,4296,4297,4261,4298,4299,4300,4301,4302,4262,4303,4304,4305,4263,4306,4307,4264,4308,4309,4265,4310,4311,4312,4313,4314,4266,4315,4316,4317,4318,4267,4319,4320,4321,4268,4322,4323,4324,4325,4326,4327,4269,4328,4329,4330,4270,4331,4332,4333,4334,4335,4336,4337,4338,4339,4340,4341,4342,4343,4271,4344,4345,4346,4347,4348,4349,4350,4351,4352,4353,4354,4355,4272,4356,4357,4358,4359,4360,4361,4362,4363,4364,4365,4366,4367,4368,4273,4369,4370,4371,4372,4373,4374,4375,4376,4377,4274,4378,4379,4380,4381,4275,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4276,4394,4395,4396,4397,4398,4399,4400,4382,4383,4402,4403,4405,4406,4408,4407,4412,4427,4428,4429,4413,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4414,4440,4441,4415,4442,4443,4444,4445,4446,4447,4448,4458,4459,4460,4461,4462,4465,4467,4468,4470,4475,4483,4484,4476,4477,4478,4479,4480,4481,4482,4486,4492,4493,4494,4487,4495,4496,4488,4497,4498,4499,4500,4501,4502,4504,4505,4506,4507,4509,4513,4514,4521,4515,4525,4516,4517,4522,4518,4519,4520,4523,4524,4529,4530,4535,4536,4553,4554,4555,4556,4557,4558,4559,4560,4561,4562,4563,4564,4565,4566,4568,4574,4575,4570,4577,4629,4571,4579,4581,4582,4583,4584,4585,4587,4588,4590,4591,4594,4595,4596,4597,4592,4593,4601,4602,4603,4604,4606,4607,4608,4609,4610,4611,4612,4613,4626,4630,4631,4650,4632,4633,4634,4635,4636,4637,4638,4639,4651,4641,4642,4644,4645,4646,4647,4648,4649,4654,4656,4657,4665,4668,4669,4670,4672,4674,4686,4679,4791,4792,4683,4684,4789,4790,4694,4695,4696,4701,4702,4726,4732,4733,4734,4735,4736,4737,4738,4739,4703,4706,4740,4741,4742,4704,4707,4705,4744,4745,4746,4709,4747,4749,4750,4769,4710,4715,4752,4711,4718,4712,4716,4713,4753,4754,4756,4757,4759,4760,4761,4762,4763,4764,4766,4767,4768,4773,4774,4775,4793,4782,4783,4784,4785,4786,4798,4799,4800,4801,4802,4803,4804,4813,4814,4821,4822,4823,4815,4833,4834,4835,4836,4816,4837,4817,4838,4824,4825,4826,4827,4828,4829,4830,4831,4832,4843,4848,4849,4850,4844,4847,4845,4846,4854,4859,4860,4861,4868,4869,4870,4871,4872,4873) ORDER BY p. LIMIT 840,24
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 840,24' at line 1 MySQL Errno:0
Message:MySQL Query Error