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,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,10811,11254,11297,7186,11418,9920,11251,7870,7188,10821,6200,9632,4463,11493,7267,10890,7546,11431,10565,11462,11192,8451,7182,11321,11016,10642,10639,11245,11218,7185,11320,10646,11463,10752,11422,9633,11191,11193,10643,10612,10644,7176,7172,11570,11650,11019,1557,11011,11032,11354,11252,8362,735,6596,8200,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801,11125,11926,11712,11525,9232,7669,10807,10889,10647,11893,9534,10822,3897,10980,368,1770,10239,10821,8232,11255,10443,10612,6270,8878,9483,9143,6749,6197,4297,9155,3881,7632,9217,4296,11320,4464,6742,9156,4301,6745,4293,9154,8983,9231,4298,8980,10957,4292,8879,9151,4300,10646,9147,4305,9144,10640,4294,10645,9633,9146,5635,8729,6743,10639,4289,10752,10753,10642,10641,11427,10644,9792,11081,10643,10647,11080,4304,11321,4390,10545,10828,11076,11077,8982,8981,10637,11432,10520,9149,10827,10646,10752,11320,2605,1266,9137,10637,10647,10639,9949,1765,1770,11321,10645,11432,4390,11017,1685,11466,11218,8585,11221,7696,10925,11178,11179,11183,7693,11037,11146,7870,4294,7189,11015,5635,11148,4386,9909,11331,10889,10920,10475,7697,4,11255,10863,10835,10921,10923,10486,7694,2605,10828,979,9149,10545,10840,11177,11375,10075,10520,1685,10521,1266,4390,4282,1411,8696,8695,8654,8656,11175,5297,6359,10827,11249,7808,9137,5332,6995,8694,1769,1768,10522,10922,11154,8655,10027,3442,6520,810,11251,10029,11317,1685,10546,11185,11182,11181,11186,11318,11184,10924,10639,10641,10645,10646,10643,10642,9880,10644,10647,10753,8693,11458,10644,10822,9933,8694,3895,8692,8655,10645,10637,11252,11321,11176,11590,11432,6354,1766,8946,6688,10331,9794,7881,7753,7752,10053,3070,9665,8627,11584,9679,9867,10544,10975,6689,7266,10927,3073,10926,7676,10930,10931,7600,11109,8727,8088,10232,3071,11582,11578,7188,7176,7186,7178,7187,7184,8897,7181,11419,7180,6652,272,11422,11013,9037,6654,11148,10928,11016,11221,9250,8944,7183,9223,8945,8943,8011,8247,11431,7182,8585,11418,510,11149,11601,9383,6653,11579,7179,7185,6426,11019,11218,11493,11722,6271,10329,10333,8241,10332,8337,11420,11465,1303,11176,11650,10327,11427,11429,11463,10931,8727,9920,11421,7870,10323,8883,8310,10565,11147,4386,11464,10238,8333,10555,10640,9407,10216,8308,8314,11146,8244,7151,7024,8318,8248,8585,9120,11466,7663,7103,3874,10519,10641,4146,10639,8880,394,10643,10752,1266,11799,9037,8787,10637,10647,10640,10646,11321,11836,10931,10463,7753,7752,8325,11624,7604,8088,7600,9665,10975,10053,8627,10544,3071,10644,8944,8943,10642,8727,9383,9587,9867,10232,9589,8945,11221,2605,8946,6354,10926,8897,10927,10928,10930,8323,8321,7600,7676,11722,11899,11836,4146,10948,6270,7184,11981,7185,11014,10641,11015,6654,7179,7183,7181,11109,7188,10928,7600,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10647,11922,3874,11432,8434,11321,11677,8542,8389,11320,9520,11354,6600,11667,11601,11636,10932,3327,9603,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,8682,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10176,10637,10199,10642,11055,11138,9232,11049,10799,8875,9113,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,551,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,8682,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9425,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,551,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,3897,10647,3885,11722,11427,7721,10520,8436,11677,10828,527,7986,7956,11319,9905,549,8247,11299,11185,11050,10326,10330,10327,9909,10433,10238,3066,11182,11587,11209,11205,11203,9518,3891,8339,11204,8274,4464,11407,7677,3888,10562,11425,11184,4714,3894,7546,6520,8326,10336,8244,8585,11181,7568,3898,11175,11183,11176,7764,8271,3896,6197,8245,11430,1769,3887,6040,3882,8272,1768,6040,6036,7167,7165,1767,6493,10923,6505,11497,11931,1766,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,8682,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,9632,7695,9920,9633,6197,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,6526,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,11252,11190,5383,11192,11194,11243,10797,11245,7610,11246,9407,8584,11181,11191,11251,6538,6503,8703,7172,11177,7567,11176,7170,6537,11175,7174,6536,7173,6535,11186,6596,6534,7165,11354,6506,7164,510,10639,10752,9518,9521,10753,7168,8917,3719,10637,7167,11320,11321,11461,11493,8585,11218,11466,10849,9520,10923,3894,11019,11422,11431,11459,11407,11240,8247,8242,10606,8703,11191,11193,3070,11375,11432,3073,6354,3071,6689,8088,7752,7753,2780,2789,2812,2791,11464,1589,11493,5792,2779,6896,2787,6688,4512,9129,7751,7972,7973,8946,7184,11148,11147,510,11146,11722,7770,7772,11656,11405,11615,11419,11618,11465,10278,8436,4282,3997,11792,11421,10332,11677,11792,3327,11799,11696,11697,10522,7938,510,4294,10325,11617,11186,11419,11176,11251,11252,11429,11575,11194,9232,11245,11244,11243,11574,4305,11190,11246,7972,3874,4146,11068,11878,11899,11081,11425,11031,11032,11037,7770,7772,510,7771,3282,3719,4580,11051,11033,11080,510,3719,6879,3115,11458,11922,979,11935,8174,11876,11355,7808,9149,11877,11759,8244,10325,10323,10328,9951,10326,10324,10331,10158,10330,10329,10333,11007,10546,11050,10560,10555,10327,10159,10137,10138,10218,10563,8873,8700,10728,10099,9894,10198,9435,10322,9436,10140,6359,10330,9434,11138,10136,8649,10202,8872,10331,10323,11049,10324,10329,10333,10326,10217,11137,11324,510,8824,7058,7752,10731,10305,7753,8088,4320,9951,11602,11601,7374,11320,11588,10305,11611,11784,10646,11321,10752,4512,7751,7972,8681,7973,10647,10364,10822,10920,840,5380,1371,11750,1770,10753,9407,10687,1765,7631,1771,10644,10642,9520,1767,9084,1769,10647,8586,1768,11321,11427,9217,1766,379,6354,11432,11218,3073,10645,3070,6689,3071,8618,10639,10752,6688,10463,10643,11320,9633,10641,10332,10323,365,9231,10325,9665,10053,10957,11650,10975,10544,11221,10326,9144,10331,7753,7752,11677,9792,9147,10327,9217,10328,8627,8088,9156,9679,9037,10232,10329,9867,9383,10232,9867,9383,10232,9867,9144,8944,8943,10463,11085,10637,10333,4701,11677,9912,9911,9232,11618,10330,11493,11799,11050,9147,11354,8727,11069,11836,6800,554,11001,9473,11878,11877,11101,11587,4282,11898,11899,11876,6689,11121,11497,2009,11022,9858,6800,9681,10687,11701,6733,11728,10106,11836,8727,10836,9870,11728,11050,11406,11696,11579,8316,11695,8241,11583,11008,8310,9591,11697,11245,10329,11240,1770,11432,1765,8307,7698,8314,2374,10044,11449,11576,11591,11799,11575,10646,10645,11922,11432,3875,11320,9951,9386,9389,3282,9387,9959,2753,10041,8933,3878,10121,7131,7019,7904,10072,7761,9334,9967,10247,8554,9969,8995,9936,9931,9052,10297,9453,10375,9872,10394,10492,10353,10314,10395,10320,10396,10663,10495,9215,10518,10093,10505,9107,8516,10712,9295,10894,10820,10974,10819,6527,7592,7554,1990,6687,10914,10971,7754,9193,10754,7640,10679,11201,10830,10548,10892,10649,10912,11226,10236,10145,11169,11348,11199,11234,11272,11388,10566,10234,10875,11436,10940,11266,10721,10537,7808,11291,11347,11446,10832,10041,11438,7374,10464,11551,11663,11741,11612,10328,10329,9120,9119,9431,10323,10647,11320,9433,9432,8316,10330,8649,8872,11407,11386,11203,11677,11931,11523,11845,6800,11207,8154,11071,8585,11067,11069,6925,8154,6922,8002,8267,11067,10390,11071,9088,6800,6426,11068,8156,11182,11183,11184,4558,11181,8943,8944,6932,6354,3070,3073,3071,7881,8945,6689,6688,7753,8946,7752,8088,8627,9037,9665,10053,8946,6689,10544,10975,6768,11221,1303,6926,11355,11354,11356,11461,11357,4785,11082,9383,9867,11085,9473,10232,8203,9633,9632,8362,11357,11356,11109,6198,2779,6443,2806,6197,9669,6200,8693,4512,4316,8692,11581,8694,8656,8654,8696,8695,8200,11578,8203,8655,4645,11579,3719,11582,3115,11580,11583,3559,11354,6520,11355,8203,11356,8656,11357,8696,8306,10331,1257,10332,5995,10328,10327,8241,9624,10326,8705,10323,507,11242,9626,10330,8704,11759,10333,8174,4046,10325,4512,11677,11320,11050,10326,10637,10646,7808,8943,10641,10645,8944,7881,6354,10647,10644,3070,10642,3073,10639,8946,9383,10643,10637,9867,10752,10232,10519,6689,10521,10324,3071,10643,10645,6689,10640,11432,11183,9418,11922,9533,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,11889,2780,2786,2781,2778,10789,10930,10931,10232,10926,10927,10928,11067,11068,11878,5134,3287,10543,11697,11981,8945,11576,11574,11694,11355,6768,11877,9625,9626,11575,6506,11354,6533,6532,6535,6505,11355,6538,11081,11930,9518,4305,9891,8584,10728,11206,9517,10555,8824,4390) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC