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,7839,5386,1165,6359,5332,6521,4701,1266,6792,6201,6198,6200,6199,4282,4301,4299,4293,4302,4305,4297,4301,3515,7693,6505,6533,6532,4286,4304,1704,4289,7972,7973,6218,6197,6501,6497,7698,6498,6215,6216,6496,6222,6221,6212,6223,8244,8249,8246,8243,8339,8245,8247,8248,8318,8317,8319,8320,8334,8326,8337,8330,8327,8315,8331,8335,8322,8333,8325,8324,8336,4234,6533,8556,4432,6532,8361,5732,6223,4224,501,8324,8596,1536,8425,8325,8404,7570,6751,7568,7762,8249,8248,8322,8245,8318,5235,8246,8683,8317,320,8319,8247,640,8597,6373,6750,979,388,6656,4079,6371,6372,6740,6512,8241,7751,8245,1029,8337,6538,8331,3889,6493,3890,7840,7879,7878,7897,3913,6264,659,8319,6193,5420,6520,8317,8341,6372,9030,713,4299,4292,1371,5484,4297,6103,6519,6518,6103,6518,8584,8585,9552,7870,7546,1770,9300,1765,3702,8222,7303,2992,4769,7126,1521,8514,8584,381,6117,8548,228,3889,8629,5545,8699,5339,8248,7697,7616,8777,8682,3892,8795,8247,6124,3515,8845,8599,8819,1698,8583,7693,8615,5807,8596,8932,8318,4613,8999,8242,3139,2807,8224,2786,1299,1765,7839,8010,5013,4460,9197,8904,8978,9200,1349,2393,3376,8934,8935,6703,9348,5222,3080,9289,9122,9402,9347,4023,2393,5210,9476,4277,4800,4538,181,5222,9541,9638,9347,9249,9654,8016,9750,9725,7860,9779,8776,1685,8330,8333,8168,3385,6985,7054,3891,6066,6854,389,8877,372,390,380,381,6376,8329,8324,8325,8243,6377,8882,393,8878,388,6517,8596,8883,8324,8788,6371,8244,8249,8247,5576,2869,8242,8243,8325,8596,8874,8325,9183,8340,8324,8883,8313,8322,6223,8728,8337,8598,842,8389,8281,7580,9120,8682,8320,8330,3875,7094,8336,8896,8681,8698,8899,8244,9041,8698,9184,9041,8656,8696,8945,7636,8694,1368,8692,8946,8693,8695,9037,7753,6354,8817,3073,7752,8943,4701,8946,8727,1769,6371,1770,6223,1765,9037,1767,8248,979,1769,6599,1768,7631,6359,3115,3071,8704,1770,3719,8340,8705,9114,507,9149,8174,6354,9137,3559,7808,9278,9383,5297,8943,7753,8944,7752,8943,7881,1770,1767,1765,4716,1769,1767,8276,1768,1245,510,8275,8591,7751,9515,9407,7972,7973,8946,7592,6688,4944,7546,7748,7753,9665,321,9626,9037,1303,1770,222,1765,7020,3073,8943,3071,7963,7881,8944,9601,9084,9624,7772,8618,9867,7770,8585,7185,7771,7187,512,9806,9907,7637,9906,9911,7753,9958,7752,10053,9720,6688,8727,9722,8946,9721,3071,9723,272,6600,10232,9215,1765,1770,8815,10255,9624,3719,344,10254,9720,5484,9113,8243,9431,8249,8599,8333,8330,8337,9426,9183,9184,7693,1768,8307,8309,9416,8246,8335,8241,8315,8326,8700,9415,8312,8311,8316,8313,8322,8331,8327,8334,8336,8320,9424,9428,8317,8598,8245,8597,7546,8583,8584,8585,8329,8682,7631,9407,9517,9520,9112,9119,8247,8314,9409,8272,8872,9894,8342,8649,3359,9182,9407,1768,8088,3071,6688,8681,8817,8698,10753,4512,10232,9867,8944,9084,8586,8332,10645,8875,9114,9120,6371,6804,501,4234,7304,3989,1462,3247,4860,2594,6740,7932,4796,7238,3830,1167,8220,7602,947,1126,6010,6971,4395,6710,5371,4512,3913,8241,8334,2041,8337,8336,7022,8248,6751,7910,8019,9430,7198,9430,7196,9084,9407,9231,9587,9903,9589,8682,6497,8325,9536,8585,4730,6315,1690,9376,9376,9137,5454,8520,5763,7099,979,8583,7808,9407,9638,9634,8584,8824,7631,9493,9591,9590,9084,7546,6201,9588,9587,9149,9593,8596,9535,8325,9665,9589,9430,8782,9429,8324,9637,5321,9867,9725,8358,9920,8583,9407,9084,8585,7546,3898,8682,3898,10053,7870,9921,1038,3542,1521,10055,4136,6824,9811,5995,10232,10090,10087,2160,10080,10238,7016,10182,10112,4624,585,2025,3288,3904,10342,10523,10479,3159,5692,10548,9808,5743,9471,10048,10212,1770,1765,10212,9942,1767,10719,1769,6354,3070,3073,3071,6689,7753,7752,10674,9212,8088,8627,9037,9665,10053,10544,6688,10975,8943,10894,11142,9798,11221,5799,107,4082,11423,11020,9477,8943,10672,11288,11310,10673,11550,6354,11644,11748,11670,10892,947,3549,5334,1371,4796,5148,6644,1439,6780,766,2706,1145,5421,4131,4860,1461,6986,2261,947,435,1398,6691,2023,2023,2023,4452,4765,4765,8684,4349,4349,1766,6509,6511,6514,6515,6538,6537,6536,6535,6505,6533,6532,7843,7592,6354,3070,3073,3071,6689,6688,8324,9590,8325,9588,9589,9430,9601,9555,8340,7194,6386,7196,6191,9111,8599,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9425,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,6139,9500,9183,9535,6371,9590,381,9591,8333,3883,9588,3891,3882,3884,3892,3881,6526,3890,3896,3893,9587,3894,8168,8597,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4291,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,10644,8887,5863,6820,6727,10874,10962,11073,7631,9119,9588,9592,7696,7868,9907,9906,9407,9501,6688,8946,8682,9084,9501,9665,8883,9184,9144,9145,9920,7546,9147,9424,9434,9665,8878,9590,9589,9587,9535,8943,4304,4301,9522,9518,8325,9522,9518,8596,9182,8246,8244,2827,2826,9433,9428,9515,9520,9521,3897,9593,379,10043,9432,9891,3897,9114,9592,9410,8329,8245,8242,8599,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,8682,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10217,10217,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6426,6854,6545,6425,6423,6421,9087,6922,10489,8267,6426,6424,10486,11817,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4291,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,9632,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,848,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,7568,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,10443,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,1770,9407,8584,10214,10335,10215,10216,10213,9632,9868,9501,9084,8682,10334,9430,9587,9591,9593,7764,10199,4804,7762,7570,8585,8719,8717,9590,9535,7569,7568,9588,10139,10346,6371,6518,6519,9119,10202,7631,10331,10432,10521,9429,1770,10565,1765,1770,1771,1767,10247,10637,10639,10646,10641,10645,7844,10752,10753,10552,10257,9905,10644,10750,10328,9631,6201,7870,6199,9951,9407,11046,11055,11047,9949,11050,11056,11054,8324,8596,11019,11072,9084,10800,9590,10801,11057,8584,10324,10327,10333,10329,10331,10213,9906,11033,9970,10043,10253,10255,9907,10256,11030,10925,11032,6197,6198,7698,11037,6199,10552,9632,10561,7772,9493,6532,6534,6535,6533,6505,10239,6506,11069,8154,11174,11173,11175,11185,11176,11186,11181,11183,11182,11184,11178,11179,6198,11176,11173,11151,3073,3070,3071,6689,8946,6688,10053,9665,10205,9925,10229,10246,10135,10131,10284,10242,8307,10240,9913,8248,8596,8324,9590,9591,1297,8804,9258,10398,9430,10216,10215,8243,10102,8341,8883,8312,9429,9429,10199,9535,10129,6719,387,10020,1766,6198,6222,7162,6216,7199,6391,6388,6214,2951,6220,6218,9829,9165,8156,6920,6925,6926,4304,9734,6988,10161,6742,8656,9176,9177,8816,6498,6497,6216,6499,6939,3248,9737,7953,9176,10387,1767,1766,8330,8328,1768,7569,3515,9590,9591,11047,9593,10201,10725,10920,10561,10728,9588,10139,8325,10801,10216,9429,6534,6535,9493,3073,3070,6354,7753,6689,3071,10544,10053,9665,9946,11221,10544,10975,10229,7695,1303,7693,8002,10251,653,10389,14,7702,7752,9589,10139,6688,9588,9429,10432,8946,653,9037,8627,10200,9383,3070,10199,9587,8290,8088,6212,9430,8945,8946,8325,8944,7881,9593,2342,10562,1771,10558,1770,10559,1768,1769,10201,10557,1766,8668,9215,8885,10556,10161,7696,8436,10560,6689,8324,10640,10641,9535,6600,8946,10638,10645,10726,8175,9631,10643,9632,3511,9493,7881,8945,8944,9665,10555,10336,10975,9679,8088,8946,8945,7881,9031,8727,9587,9430,7134,9867,4714,10544,11009,10975,8946,10940,1967,7869,2506,9985,8489,8662,10927,10926,11046,10929,538,531,539,10335,10930,7881,8946,5810,510,8489,9867,9679,10544,9665,6354,10975,8946,3071,6688,11022,7869,6272,11047,11167,2506,9985,10931,7600,7567,7770,11239,11254,8278,8478,10647,10644,10641,10640,10645,10646,10642,10940,8946,7881,7546,8682,9084,8618,11051,9473,7567,7570,7569,7764,4300,4299,4304,7568,11218,10298,10238,9475,8584,11019,9920,8585,11405,9473,11194,11139,7869,11296,9985,10298,9625,9475,9867,272,6216,8965,11325,7677,9626,6511,8946,6688,9473,11592,6512,11677,9192,10725,6066,381,6536,6537,6538,10557,10199,6534,6505,385,6535,10559,6532,6506,4714,7610,6533,367,7311,10562,7697,6701,380,368,3890,3889,3895,3883,3884,6538,6533,6534,6505,6536,6537,7567,6506,8650,7027,7568,9791,9591,4804,7762,7570,6768,7764,10567,9791,7845,9631,9455,6212,6215,6216,6499,6222,6496,3846,6220,6223,6214,6498,9483,6497,4296,4304,6501,7963,7698,7844,7695,7610,7608,3442,6218,7696,7868,7843,7694,7693,6512,6520,6521,7569,4293,4294,7697,7844,1704,8655,8692,3070,3071,7888,6689,3073,6354,1771,1765,10828,10546,11142,6697,2779,2803,2791,6443,10963,2787,2802,2817,2799,4486,4473,4470,10687,4464,4463,7166,4316,7168,7167,8520,5484,1782,11354,4338,10868,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,9590,11206,10561,11080,11048,11046,11079,9591,10725,11078,10214,10559,10799,8883,10801,3036,6381,7704,10797,11157,10200,10796,9430,11153,10795,10201,10558,9589,10216,10794,8596,10793,9587,11076,11155,11159,10562,11075,11139,10215,11081,9424,8245,10791,10199,9588,10790,8241,9523,10981,8247,11036,8242,8311,8241,10606,8244,11161,11151,8249,8243,8324,8310,11158,11160,3875,10332,8339,10323,10325,8247,8341,10158,8314,11050,8242,8245,8244,11759,8241,10324,10329,10053,6354,9665,11617,10333,10331,11618,11242,10330,8584,10251,6023,10193,7917,7054,10332,10562,9429,10139,3071,10559,8618,10557,10726,10215,10325,10326,10327,10322,10218,10328,10334,10330,10331,10333,10329,8943,8944,11019,8885,7752,11033,9970,11047,4923,8787,9555,9522,510,694,681,391,8880,378,365,372,385,9231,389,8878,381,6066,9150,9143,1769,7881,380,11022,11057,11247,11269,10176,11238,11254,11296,11051,11239,695,9031,8244,10555,694,10801,6540,9429,6544,11157,10199,11218,10556,10251,9970,8784,9906,11151,8882,8881,10463,11207,8343,10214,11154,10558,8883,6270,10216,9184,549,393,10800,384,11407,11392,9587,10561,11299,9147,9154,9155,11078,9156,9792,10957,9217,9151,9146,11405,387,9191,8858,8789,386,8788,375,382,11209,11052,11294,11320,11461,11406,11462,368,461,7861,4259,11077,4251,6788,11081,11079,3895,3893,3891,3887,3894,3890,3888,3884,8272,6493,3897,3896,3892,3889,3885,3883,10239,10981,3385,10323,979,10520,8584,8586,8682,8585,11019,9343,9084,9407,9920,7605,11050,11057,10331,9119,8714,8015,10324,11218,10329,10328,10330,8243,11155,11156,8241,10606,11161,11407,6278,9791,9432,8618,11218,11493,9534,7972,7973,10565,10559,10327,10238,6354,11240,7751,11405,3071,3073,6689,8324,4305,10565,9920,4296,7646,3883,4291,9591,8771,4304) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC