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,6103,1351,1537,834,5995,3860,1250,397,5998,6312,5988,947,1126,2995,1589,450,1379,2164,6595,6154,754,585,3080,6312,4131,1398,1433,6845,5817,5339,6104,4258,6117,1953,3542,466,2658,4199,5912,2294,608,6862,4460,5371,6870,739,1347,7126,228,3492,1699,2748,5339,5142,2337,3625,36,1461,3542,1253,4535,4092,6124,5545,2989,3368,255,3913,1167,7068,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,863,864,6583,6752,6780,397,6883,6493,388,6204,5956,1121,6986,1453,408,1663,2520,5827,7069,7123,7115,788,5806,7591,7576,7833,382,6189,6742,6582,8268,8401,8401,7097,7097,365,8267,4861,8580,8580,217,7548,8790,3036,8394,8390,8390,8891,5882,8251,7897,9011,8839,8839,8438,9028,8793,9139,6162,5996,6159,2473,1666,6869,7150,7081,323,7155,3254,4614,7079,7079,7280,6382,6152,6985,7243,7155,7713,8228,8228,1770,1765,1771,7182,1768,1766,9383,6354,3070,3073,3071,6689,8816,5094,9619,8520,8730,8814,8817,7751,7972,7973,9655,9665,6591,6710,533,754,179,947,6690,2117,4218,5602,7142,4752,5848,714,3860,3531,418,2261,2522,3888,6493,1070,1520,6710,1768,5331,6740,7238,377,6644,6644,4597,5215,5215,2658,3465,8220,8220,8271,4218,4218,7928,8886,7985,3894,8836,8836,272,3165,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,5996,24,3913,5764,4082,5885,6117,6792,3595,6831,6104,6595,236,1381,6315,3860,5371,1371,1766,5331,6559,4061,5576,6154,2294,6011,4316,3368,4185,6560,6863,7019,608,501,5215,1954,6337,1690,1325,1521,1600,1272,6979,6595,5997,5371,6713,217,4985,7903,7761,7896,2594,2419,6862,7019,5142,5093,4659,2389,7751,233,7304,7972,1016,6010,5572,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,223,5148,2706,5996,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,4801,6140,6122,7246,7099,5915,840,8280,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,5371,6103,4046,4199,435,528,5995,544,525,539,524,537,573,5148,7108,446,6559,6595,5995,1425,1520,182,6880,6809,6809,6845,6104,5454,8203,8063,24,7365,9543,9543,9545,2041,6984,6786,7070,6962,5572,6414,7162,7217,6970,2749,6843,6004,7160,5996,7304,1537,2473,7548,7205,3860,6740,7238,3860,7840,8220,5996,7548,7879,7840,7878,176,186,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,240,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,3549,6189,5334,7387,51,5996,6766,7304,3860,6780,772,7977,7572,4801,8032,5582,9030,5881,8019,10390,10264,10445,6922,6925,8156,10263,10222,10597,10389,673,10428,6754,10443,6382,6938,9088,6928,6929,6938,9089,6932,6931,6930,10593,10594,10596,10598,10595,10599,10600,10601,10603,3277,11052,10147,9633,10045,10419,10424,8784,11592,9882,6743,6066,8882,8880,381,524,3881,8878,374,8787,9879,378,6270,10526,392,3885,11663,1770,1095,5995,7840,7838,3860,4405,7897,7879,217,7548,7605,7794,6766,2473,6644,217,6979,4798,1439,1439,6642,2573,6740,7238,8220,2967,7238,3860,1537,7304,4720,4405,358,2658,5576,6413,5996,3860,7304,6740,1537,8220,3885,7987,7903,7833,182,8859,9030,4769,1371,526,2957,6738,5467,1098,4765,3094,4490,4164,4519,3564,4778,5328,4778,4426,3519,4616,1600,6780,6780,3549,5334,6171,933,730,6216,6222,6501,5093,3532,3784,6523,2725,4029,2300,1823,1533,7078,2457,7748,3085,5386,7172,608,1645,5552,4796,7572,2337,8522,8224,8557,7670,7670,8649,7631,7546,8937,3071,8910,6715,8937,9300,3287,8709,6809,9890,10146,8048,8053,8245,10047,9900,5692,8714,10491,10543,10590,4860,10674,8910,10573,10659,7125,8514,10893,11802,11497,3863,10988,9985,10687,11289,2506,11904,9485,10935,6797,10535,4985,9959,3510,7070,7078,7283,6386,7906,8157,3860,7068,8397,8415,1537,7304,2951,7897,7100,8743,7939,7088,5996,8080,8422,7252,7644,7830,5647,7588,252,2736,1533,1210,1210,466,8454,464,8287,8909,8585,9084,8682,7912,4834,4986,3165,8665,4405,801,8816,8815,7024,4834,5995,7304,446,446,8520,4259,5419,8220,7635,9209,8142,8512,840,924,5763,842,1327,8289,1645,3647,6817,6366,2467,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,540,536,528,543,544,551,537,533,550,6042,541,548,573,549,538,535,546,539,547,531,529,532,542,525,7116,7115,7077,7261,7278,7101,7288,7268,7574,7984,8067,8069,8070,8050,8211,8064,8081,8053,7668,8061,8085,8051,7657,7657,8082,7287,7287,3860,3860,7304,8448,7672,7650,7286,8066,7903,7903,7659,7108,7941,7143,8268,8473,8055,7108,8370,8370,9139,9140,9140,9158,9158,8229,8741,9058,9059,9059,8384,7672,8573,8573,8202,8202,9610,9610,9608,8475,8580,9611,9611,8722,8722,9204,7114,8083,2160,6117,271,4886,6981,4901,4730,5245,7837,1645,4767,423,7834,7836,7919,7903,6205,7835,7821,7143,7833,7761,6478,1461,1325,1970,6595,1433,8222,2029,4160,7760,7760,5542,3080,7130,7130,8812,8813,7852,3169,8250,6397,3913,6876,8098,8098,9222,9223,9224,9250,1536,9300,9017,61,9275,6870,6870,4346,9243,5286,5286,5997,9073,9614,9366,9552,9769,9477,324,9478,9641,9118,2660,8610,8184,5252,9925,9925,9921,4510,10088,10087,10090,10089,10056,10086,10210,10079,2137,2137,3936,3525,10227,10229,9624,8705,9766,9968,9959,5763,10375,10212,7149,4178,4178,10608,8441,10523,9376,6103,9297,10434,7972,10548,7973,10382,7585,10397,6264,10711,10056,10315,7218,10748,10702,5567,7889,10870,10127,10749,10127,10350,11093,9255,11324,11455,11396,3059,4739,11105,11457,11489,10754,11517,11302,10012,11130,11741,8812,958,4741,11789,9777,4987,9766,5996,6940,7020,5657,7812,7943,8109,8223,6971,7160,7548,6726,8296,8230,8049,8526,8526,8064,8357,8357,2473,7110,8512,8033,6773,7669,8503,8503,7074,7304,8903,7714,8051,7714,7272,9030,8960,9040,7903,8420,8020,9309,7897,7897,9525,8961,8961,8961,7278,7278,3893,7100,7155,7252,7252,8362,7261,7096,7079,7654,7654,3895,3895,3888,6588,3409,7107,2843,6483,314,3874,314,7078,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5897,5996,5996,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,4801,4801,8820,7160,8223,8526,8547,8815,5996,7491,3803,7897,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,8739,5386,6223,4386,7178,7188,766,3830,501,4301,7698,5996,2605,7187,6377,2063,5996,3515,7696,7304,4297,8899,4301,8728,2594,8434,8949,7304,4936,8358,8358,8230,8230,6984,6984,1973,6658,5996,3860,7897,7992,3698,8850,1126,6744,6744,3891,6214,7151,7283,7246,7078,7261,7118,6212,1704,4289,4293,6880,7246,1215,1215,1215,8765,4144,7837,3037,7992,6349,7992,6691,2029,6832,8828,916,4395,6971,9649,8230,9525,36,7105,7076,7122,8782,8382,8371,8768,8768,7261,9610,7261,7286,9608,9611,9793,9793,9743,7714,7714,8228,8449,8450,9560,8782,8782,10026,9950,9573,8363,8363,10022,10022,7671,10292,10292,7147,7110,8211,7252,5996,1537,5188,1537,7304,3860,3863,3863,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,6750,7124,1988,8580,6740,6740,9139,8743,8743,8415,8415,8050,7288,7288,7111,7111,7115,7115,7664,9401,8771,7113,7246,7117,7263,7263,7505,7505,9877,8460,9873,9874,9874,9856,9856,9821,9821,11515,11525,11525,9398,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6962,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,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,5066,7605,9084,7840,9030,8547,7674,8770,7288,7081,8424,5996,8641,7273,7107,9030,7273,7250,7117,8395,8384,8282,6813,9386,8770,5769,8200,8266,3863,6151,7304,8866,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,379,391,387,6066,384,378,382,375,394,376,6082,1266,7215,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,8232,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,5996,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,8175,6691,8727,2925,8232,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,5376,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,4486,6023,4464,6036,4470,6034,6444,6031,6030,6038,1537,6039,9030,2224,2221,2218,2211,6041,6040,2208,6540,693,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,7160,3860,8836,7238,8933,6740,7238,8154,8154,4121,8922,6876,10086,10086,6335,6335,6335,6335,6335,8628,6740,5175,8306,435,947,7985,1145,6855,28,8274,4752,7810,9049,3872,8260,4520,7654,8793,8222,8520,7106,7019,8826,1766,1767,3860,7304,5996,1537,9030,7897,223,8514,8910,6551,6556,4769,8933,9215,9533,6600,3892,7175,3893,9030,8109,9345,9345,9345,9189,840,6366,2594,5885,6010,9217,9258,6523,4860,7878,9453,7897,8681,6366,7548,3913,7548,3913,4860,7037,7840,1327,7143,7143,1738,3582,6642,7837,7837,6103,6103,5799,4860,5995,5995,8109,3647,3647,2029,2029,7995,4395,4395,7037,7239,867,867,867,1645,2006,1215,2041,2041,6971,6971,8230,8143,2729,2729,2729,3913,9306,9976,9976,9976,9976,9976,6929,7971,7576,8981,6926,6933,6650,8879,6742,7703,6744,6936,8700,7104,7646,397,6144,7150,7297,9174,6743,7099,8980,7122,8982,2856,6749,6349,6751,1730,8983,6750,546,9500,6935,7304,1537,7238,9367,7986,7985,5996,7397,9019,1993,9488,8781,3830,8933,3830,8933,5810,5446,6373,6750,979,388,6656,4079,6371,6372,6740,6512,8241,7751,8245,1029,8337,6538,8331,3889,6493,8323,3890,7840,7879,7878,7897,3913,6264,659,8319,6193,8323,5420,6520,8317,8341,6372,9030,713,4299,4292,1371,5484,4297,6103,6519,6518,6103,6518,8584,8585,9552,7870,7546,1770,9300,1765,3702,8222,7303,4769,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,8442,4144,8829,6314,6686,2657,8548,4209,5362,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,9430,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,10823,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11722,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,11828,11850,10798,7807,11363,9538,11872,9544,11964,11900,11899,11860,11965,11905,5334,3549,11272,9558,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,10526,11101,10526,11101,7238,6740,7304,10526) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC