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,4131,5331,6635,6595,6315,6010,6595,1765,5837,5286,5321,3921,6639,3941,4088,4539,3896,4950,4773,4596,2025,1371,6863,958,6703,4670,4739,4740,1461,4878,3625,4875,2337,4136,7016,5373,252,3885,848,6792,7363,1521,5081,5142,3542,947,3890,4131,7550,5995,4301,4299,4305,4302,4287,4291,4294,4296,4300,4293,7963,4289,4304,3515,7697,7694,7695,7696,1704,7608,7610,6548,5691,7695,3442,6303,7677,7168,7167,7170,7165,7163,7173,1779,6286,7164,7174,7169,7172,7693,7166,7171,4470,4464,4486,4473,1571,2824,2780,2785,2795,2783,2778,2779,2781,2782,2784,2789,2787,2794,2791,2802,2801,2806,2805,2786,2808,2811,2812,2799,2815,2816,2817,2818,2820,6489,6443,2821,2822,2823,2826,2827,2828,6442,2825,7170,7172,7173,7164,7163,8168,6537,8662,8787,1198,5251,2995,956,566,1370,2776,4762,4785,5431,1533,1425,8894,3803,3392,2736,2725,8583,4258,2294,8583,1207,9407,4300,4297,7166,7963,4146,7171,7165,6779,6688,3561,9149,979,7808,10551,10336,7167,7165,10325,10322,10331,7170,10599,9176,9631,9632,7164,9232,10332,4486,8662,8164,10427,7167,4464,10613,8167,10487,10489,1767,7677,1771,1766,1411,6359,1765,726,10602,4426,7600,6762,6759,7676,7055,8166,10198,10647,10638,10643,365,10594,10641,10645,4464,7169,10600,10601,6416,6386,7168,10642,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,5996,6122,3879,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,3890,8273,10846,8260,9192,11019,566,57,10331,10333,10158,10326,10324,10555,10335,10336,8591,6359,10725,10729,6510,6508,6509,6507,10519,9493,6532,6533,8899,11055,7189,11015,7185,6654,8897,11013,4386,7187,7184,11016,10278,10823,10924,10920,6200,10925,2605,9909,7845,7844,10922,11037,7764,7843,7568,7570,7569,7764,4804,7567,9632,9633,6511,6515,11138,11139,8662,9232,2789,9536,2799,2816,4473,7165,2806,2824,7173,7174,4470,4486,7166,7168,7169,7167,10213,4464,7163,7164,7170,11030,11031,10251,10254,9907,11032,9906,10043,10253,10256,11033,9592,11032,10255,9907,9970,10251,8246,8247,8241,10606,8245,1765,1770,11203,11204,11205,11207,11208,11209,1765,1771,1767,1769,11206,11208,10463,7870,5635,7604,5657,8883,4486,4464,8662,7165,7169,11255,7168,11251,11252,11176,11186,3070,6354,11177,11175,3071,3073,6689,6688,11109,10232,9383,9867,7676,10931,10930,7600,10157,10155,10154,8432,9670,10156,9669,9670,9672,11178,11231,11229,11414,9665,10877,9720,10956,8717,8719,6730,11374,10827,2605,4390,10545,9137,10827,547,549,550,7592,551,6042,536,537,539,510,8820,9438,9437,10354,542,541,540,548,543,10607,553,532,531,529,528,525,524,8247,533,11242,554,526,11137,11049,527,4486,4473,4470,7168,4464,7677,7167,7163,7166,7165,7164,7174,7173,11254,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,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,11723,11252,8362,735,6596,8200,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801,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,8323,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,7166,4316,7168,7167,8520,5484,1782,11354,4338,10868,7870,8586,9147,9920,8682,9407,10565,3874,7986,9154,11019,4146,11493,11339,10893,11611,4714,11255,8662,11218,4464,5066,4512,4470,7167,7165,6354,3073,3071,6689,7753,10489,7752,7167,8088,8627,9037,10053,10544,10975,11221,9383,9867,10232,8946,6538,6537,6536,6535,8943,6534,7881,8944,7179,7178,6506,10733,4785,11722,11836,7569,151,11252,11231,11179,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC