thisMySQL 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,4254,5743,4598,1311,4854,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,3287,8805,7829,8961,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,8442,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,9542,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,9741,10512,9299,11187,11834,10847,867,6001,1954,1345,4178,458,1982,2889,1085,4985,4900,2766,6788,5907,972,4109,5252,2989,2324,464,1402,3712,5782,5407,3702,4450,3581,5895,2749,6394,5887,1270,5437,5996,637,1402,1998,6620,2658,2682,6780,5907,6621,5371,3860,409,698,1029,1248,1410,6103,6135,4553,176,5175,5252,6122,4437,6880,6599,7032,4535,4048,4405,4801,3428,5484,7022,2117,3913,4950,6768,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7072,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,7087,7258,8087,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,6034,6036,6564,5996,7304,3860,7897,6766,1537,793,8281,7928,8223,5770,2029,7175,1343,2658,7391,7160,7833,8296,7205,8503,8818,9085,8464,6122,8512,9681,5995,6140,2473,1325,7241,6381,524,7363,6383,6175,7651,3550,501,8142,8097,8115,6362,6110,8305,8305,8019,8019,6157,961,961,961,961,8223,8223,7863,1402,7900,6780,8706,8706,6310,8967,8514,8514,7911,1052,1126,6118,1371,8290,8151,5334,435,5251,7658,1379,8628,8628,1766,6444,512,3896,6381,6509,6377,6539,6544,6371,6545,6540,6388,6546,6538,6382,6372,6743,6534,6375,6535,6517,6533,6537,6515,6523,6510,6386,6380,6527,6198,6520,6521,6212,6218,6220,6201,6200,6511,6508,6223,6221,6512,6199,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,7871,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,2288,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,9678,5419,7840,1266,5297,9515,3359,6066,8585,6688,6855,8896,4386,9517,9518,810,1967,6382,6371,7185,7180,9522,6533,5063,5064,5056,8110,6872,4224,7882,6898,3893,3882,3884,3892,6493,8271,9895,9906,4931,9679,7187,5053,9492,3070,8584,9907,389,9665,3073,3071,6689,6441,7632,1771,9880,9011,1768,10043,1767,1766,9601,9867,510,391,380,464,8714,9892,3380,8728,8729,10238,10188,2775,2084,1411,7987,1770,3893,3897,1765,3884,1771,6768,10217,1685,735,1767,6200,4769,4931,6143,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,7662,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,1462,11601,10180,2257,11854,10937,11792,11726,5908,6722) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC