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,4671,4923,2417,5782,6578,1726,6794,1296,2729,1153,1988,4920,5853,1973,6844,317,1732,6003,1462,1380,4437,4437,2749,2749,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6586,6588,7019,2145,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,9741,10307,3904,8739,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,11812,1807,11994,4580,6110,6794,6984,1726,1108,6964,1085,6548,6583,6369,6113,5175,665,6141,1533,1073,4199,1051,6158,2913,1050,186,2530,5576,6633,435,3904,6001,1145,2182,2261,176,4154,446,1370,466,2490,5421,3989,1272,1770,1126,7607,6785,6845,1038,6986,6158,8358,8547,431,7265,7661,8947,6130,8047,8034,4068,5142,7605,9558,9652,7143,9959,10060,1769,970,9053,7164,4464,8282,3872,134,10238,2736,9378,10531,9920,9264,7607,7913,2467,8714,8876,9607,9824,8828,11201,7655,7674,10315,7661,6119,9608,11363,11713,11117,11631,11632,7252,11674,11312,10506,11683,8517,11108,130,5252,6633,1537,375,431,1765,4558,3702,6104,5148,714,6785,6364,176,2706,3337,5331,3989,1029,2029,7019,5516,7034,6365,308,6567,1559,2006,358,7235,7304,6001,6718,2024,5915,2024,5088,2041,6984,6786,7070,5572,6414,2992,7162,7217,6970,6740,2530,6792,510,1349,2389,4338,2766,2944,972,1245,6354,6849,6858,7238,2137,320,1095,2253,6644,1070,6732,5142,5134,5707,6730,5837,7304,1268,4983,4128,3701,6693,6857,6315,252,2253,4099,2244,5657,4401,6364,7303,3046,1000,6190,3244,322,7239,5582,2467,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,4349,3595,6074,5994,6176,1586,6644,6110,6383,6175,5887,5887,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,7304,6622,6393,6961,6965,7658,7121,2473,2473,4639,4639,7953,223,223,7088,7088,8438,223,223,8282,8358,6968,8354,8353,8352,6969,6966,7805,7805,7266,7294,7253,4558,7152,7091,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,7175,8220,6578,5402,5402,6966,8352,6968,7805,8354,8354,6969,6969,8351,8357,6970,6970,6970,8356,8356,8352,8352,4716,4716,7576,5371,2635,8349,8349,8355,6104,6809,6845,3162,5996,4049,1453,834,6315,6642,5636,5837,2118,5764,6709,1576,6348,6710,1953,6861,4185,6863,4570,36,6364,6713,4277,6645,2160,3715,5013,6123,1559,4767,4886,739,6981,6842,5997,6994,4131,6740,7238,1127,344,7138,6862,3557,7761,7835,7836,6858,7779,3059,7126,7019,7878,7919,7833,7304,8019,7981,7016,7992,1521,850,7834,7751,8220,3217,8193,3754,7972,7580,2419,6698,6857,7973,6117,8547,4798,8440,4510,252,8355,8353,7541,6984,6127,2023,8356,4617,8807,8827,7970,2183,8306,8305,7860,5739,3823,8955,8997,8543,8910,6968,8681,8933,8355,8698,6174,8948,8353,7974,8356,8817,7032,9258,9222,7928,9223,6412,6967,3595,9009,6175,4806,5602,9223,8222,8793,9195,9925,9290,8290,9888,10039,9926,9835,10212,10229,8169,10127,10355,3892,1296,8302,8302,6723,6723,6967,7916,3885,3863,2349,7879,6354,7918,7878,4501,3115,446,3071,3074,1108,7636,6967,6961,7753,7998,7999,8349,6984,6967,3254,7120,377,7304,7643,3891,7251,3896,7076,6382,7092,323,3581,1557,6984,3076,6396,8881,5718,7109,8228,8439,6646,6394,358,7288,8768,6383,8523,1664,6110,8523,186,5965,8831,7912,6715,6832,6402,1296,3823,3865,1380,7912,6383,8356,8355,7805,1308,7918,9498,7541,7541,6367,7918,9065,26,4437,1345,7505,6897,8659,2635,9762,8005,9729,7711,9467,2384,6394,7917,1726,6174,9729,9856,9975,9975,9737,9737,10056,10035,7966,7966,8130,7917,8203,8450,9132,9620,9621,9386,9748,8240,6967,4779,4791,6963,1741,466,566,1056,4788,4788,7708,6316,5719,2995,6966,6396,4029,4029,1207,1207,2776,8349,6794,6391,8314,8245,8350,8316,2474,8317,8320,8315,6965,6396,8246,8249,8334,8243,6512,1726,8244,8319,8331,8335,6512,8356,6393,6939,8351,6807,7546,6967,6510,8357,6383,8354,6174,6961,3248,6607,1738,6527,8884,6966,6984,7964,6221,6511,8336,9159,8245,8328,9112,9119,6497,6216,9052,9145,6110,3076,6396,6965,8349,9113,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,8389,1662,6787,8290,7027,1884,9507,3169,9547,9374,9090,9386,8435,8196,9729,9497,6520,9713,6171,6533,1770,1766,5692,1767,6263,1770,5743,124,9482,9868,9668,6538,6130,8324,1586,6569,8618,5088,380,6968,3898,7631,8788,6076,9217,9590,9119,8972,9785,4684,8356,9555,9781,2522,9947,9001,8311,9880,9851,9838,9231,8917,3830,7548,8230,2473,2473,6646,6004,2573,8305,9049,7576,5961,5961,1738,5770,2331,4860,1172,7213,7213,7213,6174,4600,4600,4,9788,7262,6832,1360,7457,6242,6242,6183,6409,391,376,6968,6966,10925,2856,7693,6424,6423,8011,810,9852,6968,6377,979,390,6656,10201,9592,9733,8011,6424,6423,10398,10187,6968,6383,7805,9851,6110,6963,1126,1145,2331,4432,5996,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,4984,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,8389,10102,10110,1593,6740,10098,10107,8305,6212,10269,7869,2164,4788,9675,1425,5218,2776,9676,10054,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,8000,1098,4830,4348,1318,1593,3645,3797,5218,5170,89,4008,4164,1561,28,9655,4348,1474,744,9418,11409,10278,11402,1092,11228,4165,470,11252,1092,4984,1198,4940,9378,4943,11546,8995,9838,11610,2824,2785,2778,6443,5306,2904,661,5306,2904,7751,11663,11657,1237,11546,566,4165,3645,2760,1600,467,11485,956,57,9533,10278,11228,11812,3370,3136,1593,1474,1318,1092,744,470,4164,8000,4008,3797,3645,1593) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC