this

MySQL returned error




Error Description :
Error No : 1064
Description : 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 ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1

SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,5996,5371,3913,2117,1765,7610,7985,10075,7080,9161,10582,7174,10586,10029,524,7674,527,10587,2117,2029,5784,766,3989,5995,6365,3554,435,956,5995,3327,834,6587,450,3520,4406,5484,5421,6631,698,4046,906,7130,7143,714,2117,6940,4419,6588,6167,217,7137,421,5848,1462,3368,6792,2473,1038,5995,1095,4597,6849,6642,6192,6192,7759,7759,5142,7840,7879,7878,8290,8517,8517,8517,8517,501,3241,3644,5516,228,1762,3744,4325,5460,4770,3046,640,1490,3201,5732,4452,2023,2117,4411,946,3491,1558,5602,3550,3698,3754,4535,3428,1029,2052,637,4535,4048,4405,3428,5484,7022,2117,3913,4950,240,6768,501,6158,5070,1461,675,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,2932,6740,3830,1029,223,1183,1645,2615,4898,2182,7210,8220,2063,5959,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,7068,7265,7304,6103,7081,7097,4639,7250,6740,7238,1516,223,223,7607,7607,737,737,8211,7244,8080,2389,7023,8447,7153,7971,8358,713,713,8053,8071,7773,8208,223,5148,2706,5996,2992,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,6140,6122,7246,7099,5915,840,8280,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,7112,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,8571,7250,382,8739,7483,7106,8794,8638,7243,8282,8863,8863,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,3549,6189,5334,7387,51,5996,6766,7304,2992,3860,6780,772,7977,7572,8032,5582,9030,5881,8019,10390,10264,10445,6922,6925,8156,10263,10222,10597,10389,673,10428,6754,10443,6382,6938,9088,6928,6929,6938,9089,6932,6931,6930,10593,10594,10596,10598,10595,10599,10600,10601,10603,3277,11052,10147,9633,10045,10419,10424,8784,11592,9882,6743,6066,8882,8880,381,524,3881,8878,374,8787,9879,378,6270,10526,392,3885,11663,1770,2331,6540,1453,6539,6588,7783,7840,6813,4570,6140,358,5602,2635,6544,7023,933,7003,8390,6034,5305,3522,2573,6785,6036,1967,7639,6039,6038,6030,3521,1070,186,2262,6121,8281,9049,3520,6023,3519,3197,7897,6031,5995,5623,2151,1681,405,4234,6645,732,319,1110,1371,5764,3731,5247,1572,802,3368,4538,6861,5692,1536,6639,739,2419,3550,4796,219,6075,3396,3037,4217,5460,2698,5743,3159,3437,2381,922,6862,3754,322,4445,606,2590,5179,3698,1915,447,1313,1298,1688,3625,4199,2934,1038,3447,1647,2723,2298,2446,4861,1461,2863,2387,2944,3482,1576,2183,1159,1416,3396,3264,7709,5631,7036,2876,2419,1830,2518,2653,3217,3558,943,955,7228,6124,3788,739,2299,1575,6858,1522,7126,4722,2639,3989,3304,36,7003,5175,4021,5807,8306,4460,7221,5215,4194,1250,4774,7265,545,548,549,550,7020,540,547,528,538,7290,529,7840,4639,947,7938,223,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,8361,8306,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,8220,6642,8206,6348,8361,8680,8688,9007,8762,7928,9030,9134,9142,8081,8547,8763,3428,5995,5995,7878,6981,1038,5764,2976,2381,2160,1215,7967,5764,5247,7919,4730,3037,4766,2117,5602,4563,4079,5837,2882,2882,4983,1325,1325,3715,320,2658,4185,6986,4769,5484,3941,3941,5543,2023,4566,9334,7580,7751,7881,7973,7972,7293,8088,2389,3559,507,7992,7300,7085,8206,7753,7106,7660,7656,7238,8220,8222,5995,1257,4178,4947,446,1215,7977,8290,8434,8435,2520,8389,8174,6642,8175,8306,8628,8703,8628,8703,4598,4599,4600,7928,8737,7928,8737,8737,8793,8681,8761,8698,6958,508,2092,7852,2117,5602,3531,8706,7998,7999,7137,7551,9037,9030,8922,9038,2555,8739,8850,8822,1662,4218,8613,8781,9134,9141,9142,9139,7659,1511,931,9090,186,8721,8053,2712,7117,8742,8231,9300,9079,8019,1145,9349,1145,8213,8044,7238,4486,8662,7677,4178,1569,1569,1569,8547,7261,1209,5913,3409,7107,2843,6483,314,3874,314,7078,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5897,5996,5996,2992,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,8820,7160,8223,8526,8547,8815,7079,7111,7294,7124,2706,1398,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,9133,7190,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,5371,6190,358,6833,6162,2635,52,6312,801,6843,3966,6794,6588,464,6644,6366,6135,6130,6168,6155,6177,6177,5881,2658,7238,7238,3262,2520,3550,6740,6349,7238,7238,8220,4597,6813,6725,7775,3395,714,714,6766,7783,7783,2029,8143,217,8358,223,7374,9125,5484,8780,6891,3949,8255,6642,9340,6367,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,2932,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,3428,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,7920,8031,7919,8514,8134,7927,3195,4005,1698,8103,8222,405,444,8220,8183,8306,7871,783,7927,8509,6809,6845,1906,6104,6069,4710,1907,4983,6117,6679,8615,8548,1349,4652,3744,8105,2723,7156,8688,8837,8902,8681,4136,8777,6402,8957,8956,2882,8973,8547,9045,748,836,7138,8999,8910,6609,9086,4535,1005,609,754,8683,1591,8690,7992,3702,9220,261,2117,7607,6857,6842,9372,2025,6693,7879,8456,8325,8325,7091,4218,6843,7906,8083,7110,7110,7110,7110,7110,7110,7110,4178,8828,8828,7815,7815,9007,9007,7990,7990,7086,7080,7119,3874,7385,2179,1324,7108,7292,7292,7096,8050,7104,8061,7298,7642,8060,7297,1366,7106,1366,7107,7122,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,8443,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,4701,8933,8816,2473,6809,5995,9060,9075,6159,8230,9167,6350,6312,6954,8479,4362,3523,4860,9389,9879,9386,4639,8306,10346,10698,1973,10716,1993,10681,8885,2911,6740,4639,9950,9904,9993,9904,9993,8290,9951,9678,223,9220,4916,1770,1765,9835,1771,8628,1767,8358,1767,8358,10042,2456,8815,1768,8815,1768,8628,1766,8628,1766,9295,8912,9811,9454,7160,4860,8826,9391,9601,8110,8547,961,8585,8257,2117,9547,1589,7022,7289,7238,8220,4701,1116,1116,10008,2117,2117,5564,7773,8214,2913,10051,10076,10399,176,10030,10526,8071,10767,10768,9780,9386,9872,145,169,10247,5602,2117,10229,3302,223,801,6218,5371,1345,4450,10234,933,10280,3878,4405,2915,152,10346,5305,2261,9985,10358,8816,4178,840,10440,6712,10293,9258,933,10021,9900,4796,10243,9759,9772,9773,6809,8614,1345,9381,10464,10535,9386,10627,8358,4395,9950,10039,8826,10236,8815,8547,10541,10548,10505,10547,8933,10375,10472,9386,10394,4405,9936,993,7135,10505,2117,8947,9463,10339,10653,10649,7003,9536,10683,10518,10002,9900,10368,4769,5770,7160,2521,2522,5647,10526,11266,8223,9116,5839,10368,10974,9983,10904,11443,11442,9669,9670,3849,3564,10719,11101,10316,10736,2164,3282,11657,11673,10093,11451,11659,11658,11660,10375,11714,11314,11681,11703,11494,9471,41,9897,582,11620,10886,11346,9868,9942,7027,11486,10840,8108,4218,8305,6780,3549,2388,5334,8955,8019,5582,265,744,3850,2331,4964,4563,4164,4706,239,8995,9300,8628,8097,9647,5729,9864,9838,9897,9900,567,7634,576,7635,9381,10017,10041,10092,9617,10094,1912,2328,1029,1516,2052,5420,10141,6831,6899,1770,2117,1771,1766,6177,4535,9389,9387,6849,4125,9193,9235,10297,4563,10148,9914,4405,5917,9986,5305,933,2261,7299,9105,4947,3522,9126,8706,8560,10259,10535,8019,111,7822,9164,9065,10781,10236,4395,10021,8182,10823,10877,10658,10974,464,10937,9164,9065,10956,3261,1092,5839,9941,10922,10912,10923,5647,8306,7020,10339,10526,5995,2467,11101,6740,7238,8220,446,223,2117,10836,8388,8302,1371,2913,5567,8520,11497,11497,10672,10820,2337,6264,4399,6264,4399,11497,10892,11063,11332,10887,10889,8430,7261,8470,10491,223,10687,3327,11226,9975,11690,10371,2701,9358,1662,8859) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC