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,4419,5897,5998,6195,5956,6896,6587,6843,6638,6102,1242,6173,1591,5912,2749,7046,6718,4971,6559,2538,1953,156,947,5910,6176,5371,5998,6362,675,1402,3913,2261,4405,6811,435,4419,217,4784,3595,6667,1359,1811,2736,3327,4639,2417,228,6821,6792,233,452,6275,7986,3059,3059,3059,5535,4671,4923,2417,5782,6578,1726,6794,1296,2729,1153,1988,6962,4920,5853,1973,6844,317,1732,1462,1380,4437,4437,2749,2749,6575,6855,2029,6768,714,6768,6733,7140,7144,6367,1537,7304,850,2024,445,587,317,7118,7246,4923,3864,7915,8349,7245,7286,7666,7806,8614,1782,8745,2712,3073,8951,2522,5995,7164,9078,7833,9244,8048,6971,9055,9055,7976,1349,8146,9614,9541,9600,9327,9942,8900,10026,9220,10076,9134,9054,435,10614,10479,10319,10778,6365,6583,2029,2530,249,4144,5995,7374,6738,7139,7149,6714,7215,6006,5995,7605,3337,7213,7966,6183,7218,6583,6131,7217,5853,7406,7443,7406,7472,7456,7070,7120,7642,7648,7645,7652,3874,7298,7674,2635,8048,8047,906,6691,7406,2795,1953,4983,7162,4079,6365,2117,3863,4769,7605,7879,7840,6367,7878,7994,8358,6264,4395,4424,3428,4535,3865,8292,8298,5717,5742,5742,1462,4178,8287,7974,8361,8223,8390,8741,8390,7073,8771,8771,7713,6714,6744,1742,7995,9085,8168,9096,9134,3702,8980,9204,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6104,6691,6174,6740,7238,7472,8220,4769,7840,7879,7878,7592,3913,7554,7754,7755,7756,8509,7539,446,7927,7445,2041,9359,6316,6569,7283,7970,254,1049,1049,2946,2946,1051,6880,1050,1050,7012,6402,8547,8547,7261,7252,6388,6416,8203,8203,8201,8201,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,1586,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,8220,6875,2830,783,5995,7977,9402,5068,1153,9767,576,9464,9547,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,6,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,8257,11399,10874,2033,11749,10483,6561,6561,6561,7371,10203,4769,7501,10296,11019,10292,6718,10992,207,10310,6406,11269,10940,11247,11118,10466,9716,10408,10490,9706,9718,11254,6603,9708,11051,11427,9690,10695,860,11263,11295,6361,11053,11467,10438,9384,10730,9936,6443,6271,11731,10721,9042,8962,11727,8685,11792,7219,365,374,7806,6586,3823) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC