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,1699,6102,5995,6104,4395,5339,5817,4639,6364,5906,6103,5916,5688,1016,6713,4800,4827,3542,3625,3474,5764,4784,4087,6858,6691,6782,6829,3554,5175,5965,4424,1755,1764,104,3574,6951,576,609,2849,5763,4510,4087,4046,1345,6809,6979,2300,6731,458,6845,7358,5961,1988,3719,7214,7019,3704,6795,7839,4224,7605,7890,3823,4774,7810,3908,4659,7920,2643,2658,8196,233,1511,1984,8548,7883,7216,8144,8031,8514,8089,2294,4258,222,2989,6006,7804,5252,1984,1458,1084,8999,8108,4452,1490,582,3492,1823,9028,9212,9213,9079,3712,8224,4613,4704,1300,2849,9116,4082,4136,9372,8559,2491,8358,582,5961,9258,9375,5636,207,8274,3890,3891,3893,539,542,3896,8271,3882,3892,3894,8273,3884,5567,9937,1253,2933,5545,4178,446,3889,9377,9799,9212,535,3244,6642,6891,4082,10000,6858,10228,539,10243,9438,9437,10181,10568,385,389,8858,8789,8515,2356,380,10354,8787,8005,4087,3401,3990,4613,8534,3474,9439,9214,9930,9648,10120,9680,9764,4046,4411,1490,4049,4050,1973,6738,9823,3493,6876,11027,10114,5175,11298,11020,11235,10674,6591,11339,5207,9243,11495,640,5732,2023,6023,2221,6034,8941,9405,7374,11359,984,11413,538,390,6066,540,532,528,11353,6894,5262,608,7810,233,2035,245,254,1005,1209,842,7920,7149,8220,8440,8514,8483,8547,6911,3888,3892,9220,9300,9284,9258,9298,2265,9354,8183,9030,2849,6842,5222,5331,6842,8683,737,377,551,9322,4437,6122,5421,4218,5770,5371,5576,1462,2342,1343,4570,3863,2455,1461,5576,2269,7307,6981,2869,6809,1351,4535,6809,7020,834,501,7020,5657,3850,6709,2269,1764,7359,4446,934,7546,1038,6599,698,4566,452,3492,6845,6721,156,1271,6723,446,5419,7604,924,5647,1973,4178,2932,1200,4362,5148,766,2932,4860,2006,7160,7631,3830,1439,4901,713,5995,1453,4796,6367,6103,5837,754,2029,5269,7840,6168,5376,6981,7592,6740,7554,7833,6155,7754,1345,7751,7756,6131,5484,7232,2799,1016,5956,5763,6631,3913,5956,5576,2869,1351,834,2009,2799,7178,840,4936,665,4945,6198,6201,7241,1988,7697,6197,7134,1979,7693,6200,7133,6532,8268,8251,6533,6538,7610,8209,3250,6534,3327,7906,2824,7074,6506,6533,4804,7152,7764,7111,7567,6536,8418,4769,3515,8759,7693,8251,5770,2632,4860,665,766,4860,1912,1912,3989,4834,2417,6740,6740,4131,7910,9117,3863,6445,3105,6667,5435,3865,2041,1357,6775,7561,8966,8481,8481,8833,9667,9667,6548,6548,9529,9148,9259,7288,7288,7288,7288,7288,3327,8739,10670,11101,6700,8780,8816,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,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,8491,6174,8296,2925,7634,4834,8142,8617,1974,1974,7840,7879,7840,7879,6728,587,6728,587,8683,1308,8683,1308,6770,9403,7048,7847,3926,450,2627,3949,2628,4178,8565,8831,4716,9865,4716,9865,3913,6869,3913,6869,3913,6869,576,5484,6795,463,6315,5995,5020,409,5222,6571,1416,3303,6569,219,6678,1577,6141,7004,231,7209,4156,2605,3872,7081,7261,7290,321,4259,7255,7278,3888,1770,3172,1185,5208,8296,8222,7238,8514,3897,8757,1537,8469,7752,2006,7115,8651,7775,8709,7714,1569,7168,7166,389,7547,8109,9614,8053,9134,9831,7642,435,8048,7397,9019,9488,2992,8781,3830,8933,3830,8933,5810,5446,3437,3159,8901,9220,9638,8900,8089,9086,5769,9904,9454,8837,10042,9942,4648,5739,9454,9471,252,8888,10244,10416,9669,9670,9671,9131,10856,10787,8946,2749,3913,8257,8257,3327,5269,7650,7388,7388,9148,7272,3874,7246,7246,7125,9204,7110,9797,9563,7111,3327,10211,3863,10310,5435,5435,5435,2627,7083,6306,7376,9957,7505,10038,9,10026,6616,9386,9751,7070,9797,10292,10272,1766,7563,3823,10183,10183,10183,10183,10183,7391,1770,2473,6953,3784,6740,7238,8257,9032,8290,8290,8220,6396,1084,1086,1085,1604,5495,714,5495,2729,1609,987,7132,5185,6533,990,4346,7020,7636,6589,7636,6750,2018,7580,4563,7972,7973,6201,3380,6098,8098,8093,7273,8302,7639,2006,6843,6445,3521,7105,8199,8047,7895,8413,8514,9055,9132,3647,9206,8475,3169,9195,4796,8224,9900,9935,9879,9630,9945,2736,10547,10026,10765,7976,10881,8053,7152,9134,9204,11798,11609,10466,11410,10228,8290,2555,2555,10339,4349,11380,4701,8933,8816,2473,6809,5995,9060,9075,6159,8230,9167,6350,6312,6954,8479,4362,3523,4860,9389,4801,9879,9386,4639,8306,10346,10698,1973,10716,10681,10212,8585,9078,1296,5435,10010,7194,5389,9863,11101,7833,10992,2830,1983,10309,9043,10339,1770,8817,1765,2033,10296,1771,1380,10716,1771,10940,9836,3913,11202,1500,10526,7385,9300,4985,6740,11380,8220,10278,4639,10056,10228,11264,9865,10940,8358,6367,11690,11366,223,9946,11662,9946,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,11074,10339,11101,3863,10687,9865,11497,11216,10505,6986,10505,6986,4178,7977,9946,10466,8257,11600,7554,10687,1988,11326,9162,10468,6978,10372,11114,582,8388,582,8388,3327,3327,10687,10339,10687,10339,11400,8388,11101,11327,10472,4923,9524,9865,2594,4234,5371,3702,501,9030,3989,5148,6740,7238,8220,7975,1371,7143,7833,7903,5995,9614,5322,5070,4796,766,7019,8948,10148,10173,9300,10187,10146,10056,9378,10526,10892,10836,10964,8435,11121,11027,2253,4791,11089,10149,5853,11018,11101,5567,10491,11733,11690,10716,8438,1974,11788,10228,11497,8436,5435,3913,10526,10940,9865,10228,7849,6715,11885,11410,1988,11366,10707,11121,11701,6843,3863,7592,7554,7754,3287,7754,5070,7756,7927,8509,4510,8162,2033,4234,3241,5134,9805,3327,1769,10938,11219,1768,6613,10985,11123,10002,10212,9830,9359,11069,5484,11497,10339,9866) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC