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,3070,186,3073,3071,186,3071,186,6689,6354,186,8727,7753,8727,7753,3070,7752,8088,8627,3073,8814,8817,510,1368,7753,7751,8717,7972,7752,7973,8088,8946,9037,377,8681,8817,9084,7751,7972,7973,6362,8271,8718,4178,6534,6505,6532,8088,446,4178,2488,7734,694,693,7569,5389,8731,8591,2785,2795,2783,2786,1266,8247,8874,8245,8943,8944,8241,8248,2605,5386,7599,5332,1411,1266,5297,1770,7808,7677,8719,8717,1765,1771,1767,1769,1768,1766,8718,8731,2522,6538,6537,6536,6535,6534,1765,1771,8585,8586,7870,8584,7546,8618,1769,1768,1766,8816,2522,6689,7753,7752,8088,8627,3071,3885,1766,3882,6354,3073,3071,7751,4512,3070,6689,8244,7752,5298,7752,8241,7072,8246,8311,7636,1368,507,8704,1257,7238,8174,7580,7881,272,6204,8306,446,1215,5995,5732,7837,9037,1165,7835,2023,8598,8840,8319,640,8247,8441,8425,8407,8439,8404,9138,9297,9187,8400,8568,9795,8794,8410,9564,8413,8782,8782,8451,8577,8208,7836,9372,8329,1347,608,1253,4258,9937,7920,10232,10243,8402,10095,8580,9560,10401,8450,9313,8407,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,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,8945,6168,223,9030,4639,311,8358,8698,4834,2992,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,8341,8649,1266,7753,7752,8627,8088,8699,8342,6270,372,5066,374,380,386,393,385,8727,510,7772,391,389,390,387,392,7751,8786,810,6076,5332,6652,6654,375,8784,388,7126,1521,8514,8584,381,6117,8548,228,3889,8629,5545,8699,5339,8248,7697,7616,8777,3892,8795,8247,6124,3515,8845,8599,8819,1698,8583,7693,8615,5807,8596,8323,8932,8318,4613,8999,8242,3139,2807,8224,2786,1299,1765,7839,8010,5013,4460,9197,8904,8978,9200,1349,2393,3376,8934,8935,6703,9348,5222,3080,9289,9122,9402,9347,4023,2393,5210,9476,4277,4800,4538,181,5222,9541,9638,9347,9249,9654,8016,9750,9725,7860,9779,8776,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,11686,11890,10702,11211,11772,7127,10664,8764,1766,10291,10292,6359,673,3036,979,2605,3784,2520,7808,4121,5386,1165,7546,8824,1764,6082,5995,2491,3069,2658,6272,3384,5295,4795,1656,3385,2491,3401,5717,5175,6118,952,6103,3184,2998,2696,6453,5996,6474,6472,6460,6465,6475,6740,2876,6468,222,156,6800,6390,6873,7104,2946,2453,7639,7938,7595,665,8281,7239,5545,7773,6493,8558,7674,7846,8724,8700,6498,8740,8583,7840,9109,9054,8240,435,8913,9249,9249,3850,7647,9529,9619,5512,8953,8953,6390,6391,863,858,6191,6527,6146,6152,6377,6517,6151,6144,6750,6388,673,653,275,6607,6191,6381,4614,7018,323,394,8307,8584,6270,6531,6529,7610,7870,7697,6652,6216,5691,6528,7695,7868,7696,3442,1704,7693,6654,8719,7189,8586,7546,4302,8897,8618,3515,1770,2783,8896,6197,8728,7188,6023,1765,7187,7568,7567,7569,7570,7762,8314,8246,8316,8315,8318,8334,8244,8322,6743,8326,8330,8307,8649,8313,8311,8319,8335,8331,8249,8308,8873,8872,8585,8586,7546,7631,8585,8584,7870,8247,8335,8317,8329,8332,8339,9114,9111,9154,9156,8308,8309,9119,9120,8583,8618,9113,9115,8341,9112,8598,9183,9114,8699,8340,8342,1411,9137,979,8824,8329,810,9154,9151,9155,9190,9084,9407,9433,9432,9431,9411,8328,8339,8583,8618,9416,9410,9520,9434,7187,9521,3510,7070,7078,7283,6386,7906,8157,3860,7068,8397,2992,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,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,7580,9120,8320,8330,3875,7094,8336,8896,8681,8698,8899,8244,9041,8698,9184,9041,8656,8696,8945,7636,8694,1368,8692,8946,8693,8695,9037,7753,6354,8817,3073,7752,8943,4701,8946,8727,1769,8323,6371,1770,6223,1765,9037,1767,8248,979,1769,6599,1768,7631,6359,3115,3071,8704,1770,3719,8340,8705,9114,507,9149,8174,6354,9137,3559,7808,9278,9383,5297,8943,7753,8944,7752,8943,7881,1770,1767,1765,4716,1769,1767,8276,1768,1245,510,8275,8591,7751,9515,9407,7972,7973,8946,7592,6688,4944,7546,7748,7753,9665,321,9626,9037,1303,1770,222,1765,7020,3073,8943,3071,7963,7881,8944,9601,9084,9624,7772,8618,9867,7770,8585,7185,7771,7187,512,9806,9907,7637,9906,9911,7753,9958,7752,10053,9720,6688,8727,9722,8946,9721,3071,9723,272,6600,10232,9215,1765,1770,8815,10255,9624,3719,344,10254,9720,5484,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,9639,8472,10513,11927,11913,11892,9354,9629,9630,11888,11881,11926,11957,12007,12004,10904,11797,10891,11334,10615,10614,9137,7304,9084,8618,9114,7986,3888,3874,3254,9111,9407,389,7187,7189,6654,7598,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,6962,9113,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,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,9407,8583,8584,3896,3891,8700,8329,9759,376,152,987,9553,9754,4437,9559,8583,9430,9429,9407,8618,9589,9587,4940,4939,9113,8243,9431,8323,8249,8599,8333,8330,8337,9426,9183,9184,7693,1768,8307,8309,9416,8246,8335,8241,8315,8326,8700,9415,8312,8311,8316,8313,8322,8331,8327,8334,8336,8320,9424,9428,8317,8598,8245,8597,7546,8583,8584,8585,8329,7631,9407,9517,9520,9112,9119,8247,8314,9409,8272,8872,9894,8342,8649,3359,9182,9407,1768,8088,3071,6688,8681,8817,8698,10753,4512,10232,9867,8944,9084,8586,8332,10645,8875,9114,9120,7631,9119,9588,9592,7696,7868,9907,9906,9407,9501,6688,8946,9084,9501,9665,8883,9184,9144,9145,9920,7546,9147,9424,9434,9665,8878,9590,9589,9587,9535,8943,4304,4301,9522,9518,8323,8325,9522,9518,8596,9182,8246,8244,2827,2826,9433,9428,9515,9520,9521,3897,9593,379,10043,9432,9891,3897,8585,4730,6315,1690,9376,9376,9137,5454,8520,5763,7099,979,8583,7808,9407,9638,9634,8584,8824,7631,9493,9591,9590,9084,7546,6201,9588,9587,9149,9593,8596,9535,8325,9665,9589,9430,8782,9429,8324,9637,5321,8323,9867,9725,8358,9920,8583,9407,9084,8585,7546,3898,3898,10053,7870,9921,1038,3542,1521,10055,4136,6824,9811,5995,10232,10090,10087,2160,10080,10238,7016,10182,10112,4624,585,2025,3288,3904,10342,10523,10479,3159,5692,10548,9808,5743,9471,10048,10212,1770,1765,10212,9942,1767,10719,1769,6354,3070,3073,3071,6689,7753,7752,10674,9212,8088,8627,9037,9665,10053,10544,6688,10975,8943,10894,11142,9798,11221,5799,107,4082,11423,11020,9477,8943,10672,11288,11310,10673,11550,6354,11644,11748,11670,10892,8700,7195,397,8694,8656,858,311,9735,156,9871,566,10100,8323,7198,9430,7196,9084,9407,9231,9587,9903,9589,6497,8325,9536,1768,4302,7599,7610,1165,7808,2605,4282,6359,1766,4614,3891,6493,3895,3879,4720,1770,3883,6354,3070,7696,7168,5810,4714,7748,7748,6689,3073,8618,3892,4784,1767,1533,2677,6740,7238,8220,9300,9049,6523,6373,6373,6373,7869,8489,9031,9920,8583,4714,8584,7546,9407,9084,9084,783,8618,7870,9114,9592,9410,8329,8245,8323,8242,8599,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10217,10217,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6426,6854,6545,6425,6423,6421,9087,6922,10489,8267,6426,6424,10486,11817,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,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,4463,3890,8273,10846,8260,9192,11019,566,57,1771,9665,10255,2782,10256,5297,9906,7696,10253,7751,6720,10331,7973,9996,9669,3071,8946,659,10333,10251,9515,8730,7753,10053,7815,10545,10188,5297,8816,10565,10501,10549,9383,7610,9867,5691,6197,7881,8943,6199,2522,8944,2520,9633,6519,4701,1779,5386,9555,4920,1767,5188,9493,6534,3883,6506,7985,6354,7986,7751,8618,7973,450,8257,1770,1765,1771,10638,10646,10641,10642,10643,10640,9665,10544,9499,9217,1768,1767,10565,10840,4580,10900,11083,9402,1770,9407,8584,10214,10335,10215,10216,10213,9632,9868,9501,9084,10334,9430,9587,9591,9593,7764,10199,4804,8323,7762,7570,8585,8719,8717,9590,9535,7569,7568,9588,10139,10346,6371,6518,6519,9119,10202,7631,10331,10432,10521,9429,1770,10565,1765,1770,1771,1767,10247,10637,10639,10646,10641,10645,7844,10752,10753,10552,10257,9905,10644,10750,10328,9631,6201,7870,6199,9951,9407,11046,11055,11047,9949,11050,11056,11054,8324,8596,11019,11072,9084,10800,9590,10801,11057,8584,10324,10327,10333,10329,10331,10213,9906,11033,9970,10043,10253,10255,9907,10256,11030,10925,11032,6197,6198,7698,11037,6199,10552,9632,10561,7772,9493,6532,6534,6535,6533,6505,10239,6506,11069,8154,11174,11173,11175,11185,11176,11186,11181,11183,11182,11184,11178,11179,6198,11176,11173,11151,3073,3070,3071,6689,8946,6688,10053,9665,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10647,11922,3874,11432,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,9632,7695,9920,9633,6197,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,6526,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,11252,11190,5383,11192,11194,11243,10797,11245,7610,11246,9407,8584,11181,11191,11251,6538,6503,8703,7172,11177,7567,11176,7170,6537,11175,7174,6536,7173,6535,11186,6596,6534,7165,11354,6506,7164,510,10639,10752,9518,9521,10753,7168,8917,3719,10637,7167,11320,11321,11461,11493,8585,11218,11466,10849,9520,10923,3894,11019,11422,11431,11459,11407,11240,8247,8242,10606,8703,11191,11193,3070,11375,11432,3073,6354,3071,6689,8088,7752,7753,2780,2789,2812,2791,11464,1589,11493,5792,2779,6896,2787,6688,4512,9129,7751,7972,7973,8946,7184,11148,11147,510,11146,11722,7770,7772,11656,11405,11615,11419,11618,11465,10278,8436,11723,4282,3997,11792,11421,10332,11677,11792,3327,11799,11696,11697,10522,7938,510,4294,10325,11617,11186,11419,11176,11251,11252,11429,11575,11194,9232,11245,11244,11243,11574,4305,11190,11246,7972,3874,4146,11068,11878,11899,11081,11425,11031,11032,11037,7770,7772,510,7771,3282,3719,4580,11051,11033,11080,510,3719,6879,3115,11458,11922,979,11935,8174,11876,11355,7808,9149,11877,11759,10729,7546,10708,10709,1770,1765,10710,9669,7721,10607,10551,10322,10686,3066,10162,10565,8584,10330,10606,9407,10545,8586,10726,10336,10519,10728,11017,9679,10238,10970,8699,11057,10198,8618,7870,10931,8241,8244,8598,8597,10750,8585,6497,9084,10565,11149,6215,11218,11049,9665,8727,1303,10053,10544,9383,10232,9867,8584,9518,9522,9515,9517,9520,9521,8586,8585,10238,7546,2389,8618,11019,10565,7870,8586,10238,7631,8883,9084,1765,1770,10325,3327,9946,5435,10328,10330,275,10333,10331,10326,10327,8333,8332,8584,8585,10565,9407,7870,9084,9920,11019,10565,10238,8584,7546,8585,7631,11218,8586,9151,7178,11203,6652,11204,4386,6654,11207,7182,11205,11206,11013,7187,11209,5635,11322,11146,9517,8321,11148,11138,11147,7184,8699,7185,9424,11016,8328,11422,8242,11421,9415,7189,9416,7176,9409,11418,11240,7179,8332,10336,8330,8597,9428,9427,8249,10239,10981,3385,10323,979,10520,8584,8586,8585,11019,9343,9084,9407,9920,7605,11050,11057,10331,9119,8714,8015,10324,11218,10329,10328,10330,8243,11155,11156,8241,10606,11161,11407,6278,8323,9791,9432,8618,11218,11493,9534,7972,7973,10565,10559,10327,10238,6354,11240,7751,11405,3071,3073,6689,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10176,10637,10199,10642,11055,11138,9232,11049,10799,8875,9113,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,551,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9425,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,551,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11723,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,10314,8585,9920,6947,9407,1912,9084,10695,8515,10238,10565,10665,8618,10505,8586,10674,3549,11019,510,10320,5334,8168,4765,7631,6364,9321,8878,8019,8882,2974,10093,10238,4293,11050,7179,9418,9149,4297,6354,11242,8307,4294,4301,3897,3073,3070,3071,6689,4291,7172,3889,4304,3898,11421,7987,1589,6688,8727,4294,9679,3888,9665,8088,10067,8704,8627,10888,9037,10506,9626,8705,51,10272,10570,10840,8191,3890,7987,7808,11209,5297,3896,11215,8255,11307,10646,9129,3358,8244,6688,11322,8897,10520,11049,7176,8874,11013,8618,11015,7632,11432,11414,11463,9865,10932,10984,11204,11147,10326,11205,5635,11418,9524,9863,8963,10229,7695,1303,7693,8002,10251,653,10389,14,7702,7752,9589,10139,6688,9588,9429,10432,8946,653,9037,8627,10200,9383,3070,10199,9587,8290,8088,6212,9430,8945,8946,8325,8944,8323,7881,9593,2342,10562,1771,10558,1770,10559,1768,1769,10201,10557,1766,8668,9215,8885,10556,10161,7696,8436,10560,6689,8324,10640,10641,9535,6600,8946,10638,10645,10726,8175,9631,10643,9632,3511,9493,7881,8945,8944,9665,10555,10336,10975,9679,8088,8946,8945,7881,9031,8727,9587,9430,7134,9867,4714,10544,11009,10975,8946,10940,1967,7869,2506,9985,8489,8662,10927,10926,11046,10929,538,531,539,10335,10930,7881,8946,5810,510,8489,9867,9679,10544,9665,6354,10975,8946,3071,6688,11022,7869,6272,11047,11167,2506,9985,10931,7600,7567,7770,11239,11254,8278,8478,10647,10644,10641,10640,10645,10646,10642,10940,8946,7881,7546,9084,8618,11051,9473,7567,7570,7569,7764,4300,4299,4304,7568,11218,10298,10238,9475,8584,11019,9920,8585,11405,9473,11194,11139,7869,11296,9985,10298,9625,9475,9867,272,6216,8965,11325,7677,9626,6511,8946,6688,9473,11592,6512,11677,8618,9084,7172,9407,10238,11019,9920,10565,9084,7631,11218,7184,11016,5635,4386,7179,7189,6652,7178,7182,11240,510,8897,7770,7180,7772,7771,511,512,8946,6654,11013,6688,9473,11014,7181,7183,11354,7176,6653,7188,11419,11421,11422,7187,11418,11420,9407,9084,10565,10238,9920,11146,11147,11148,11015,11082,11392,9437,11019,7998,4386,9129,11218,9671,9670,9669,8946,7186,11464,11493,11462,11463,8172,10750,11431,8007,6596,9233,10433,11017,8971,11430,11414,11429,11321,6836,11498,8610,11446,5988,11521,10472,6521,11181,11487,11495,11427,1347,5339,5545,9084,9920,11362,8681,11109,9958,8698,11468,848,9492,6216,10864,11269,11649,11349,11664,6497,11377,11378,11678,11069,8154,10042,9638,9220,10941,11493,11647,11349,11724,10895,8900,9638,9220,10569,10787,10856,10042,9904,9086,252,5373,11126,11678,6713,11237,51,4082,7550,8837,5193,3018,10367,8780,4401,10824,24,9896,11355,1770,7184,8306,6713,7185,11016,11647,11463,11464,7176,11488,11664,5255,11876,6800,28,10942,9492,11093,524,543,553,539,535,529,532,554,7124,7078,9933,11592,7107,3888,11624,10482,9439,9290,11349,10354,9601,9334,8902,11724,11981,9888,8542,8434,10442,6740,11121,11690,9300,10056,8541,8922,1190,6836,9233,11622,8582,6240,11442,8819,2294,156,10565,11019,7169,10238,1766,4464,9084,7546,11218,8586,8618,9590,10551,10323,10322,11050,10332,9434,11242,9435,10331,10327,10325,8531,7986,11241,3884,3885,3888,11017,8971,6263,11458,11459,10292,6836,6834,10328,6835,11467,11319,11167,11301,11299,11239,11301,11238,10176,11247,10466,11022,11254,11295,8345,9031,7869,5810,4714,11294,11296,11493,10804,3888,10606,3887,11269,11484,810,11051,11181,7610,7698,10922,10921,10923,11518,10821,10687,11435,6270,390,6789,7006,6076,6880,374,11601,11460,11422,11758,11903,11590,10789,8362,11909,8244,8598,9428,10821,11046,11429,9415,10920,11407,1730,10332,6934,6423,10324,7546,11466,10840,9414,9407,6426,8245,11394,10522,8246,10559,11405,10487,1266,8310,7870,8586,9147,9920,9407,10565,3874,7986,9154,11019,4146,11493,11339,10893,11611,4714,11255,8662,11218,4464,5066,4512,4470,7167,4463,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,4599,4598,11899,10155,8432,4598,10610,10448,11016,9981,6929,6377,11358,10622,10599,5635,8965,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,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,2992,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,9143,9408,7610,535,547,11054,8596,545,9430,550,979,1765,548,9143,9437,542,3889,8325,3894,524,10727,7987,8249,527,3896,3888,541,3887,529,7986,536,3883,8272,525,9502,8987,539,6493,8989,528,10556,9147,9146,543,537,531,11080,10822,6042,11077,11075,11076,11079,11078,11077,10957,9231,9144,11458,8665,6390,10502,6474,6475,6473,6471,6470,6453,6469,6465,6461,6462,6464,6466,6467,6463,6468,6460,6454,6457,6458,6459,6456,6455,6470,6471,6469,11493,6468,6467,6466,6465,6464,6473,6474,11019,11432,6461,6462,8586,7546,9084,9407,9920,7870,10238,10565,9084,11218,8585,6039,6036,6034,6023,6038,8584,6041,6040,6542,6544,6444,6540,6539,2224,2221,694,2211,9517,9518,9521,8618,9520,681,695,2208,11429,6521,11574,11576,7631,9407,9084,11650,6520,3890,3895,11677,10565,10269,11493,11218,10327,2779,10963,10463,10328,10326,10325,529,11559,3888,3884,10332,3891,11181,11184,10323,11318,11242,11430,3384,7299,8339,3893,11722,2785,3885,10238,2780,2781,6354,11019,3385,9232,5810,3896,8618,6394,6800,7973,2818,3881,3887,10331,2786,2805,2822,11792,8585,10333,11033,2778,2787,9407,11019,11759,10565,11218,7870,7546,9920,11493,6654,10238,11462,1765,8585,11206,9522,11899,367,391,365,368,10161,6270,8878,8880,9483,8882,380,10846,11241,10323,11019,10750,11722,11493,11218,7631,10726,9407,7631,9084,8618,9920,10238,11899,10036,11660,8585,7870,10731,11714,10687,8586,7546,11493,5770,4503,8624,10579,11658,8816,11673,11770,9920,11657,10868,11656,365,11716,8339,26,8885,11759,8,11306,9507,10331,10323,1885,10326,10325,11677,10333,10279,10327,10330,11242,10324,9482,11241,10328,8880,381,9024,9024,9024,8582,9840,9865,10480,9633,8310,8897,7698,3254,842,8274,6520,3897,8272,3883,3884,3895,3892,3891,3888,3882,3896,3890,3887,11458,11459,10238,8585,9407,9920,7870,8586,8618,7631,11722,11218,9084,7546,10565,2807,2806,10828,7631,1685,9137,7697,7694,7695,11694,7868,10332,11624,7695,11694,3073,10326,10325,6354,8332,3895,3896,3888,3887,8274,3889,3893,3885,8273,6493,3897,3891,8272,3883,3894,3884,8946,10327,10328,10329,10330,10331,10323,8248,10333,10606,9119,8585,9908,10194,8882,8290,8339,9588,9587,8330,9430,9429,11722,11242,11677,8586,8618,9407,9920,9589,10200,10199,10801,11160,10557,11617,11615,11759,11618,10214,10215,10158,10096,10137,10138,10099,11156,11625,8314,11139,11151,11934,11154,9409,10562,10103,10100,10556,10559,11932,11933,11153,10101,9593,10102,10139,11406,8324,9425,9427,9428,9891,10153,10195,10197,510,7772,7770,7771,511,512,512,7637,10558,9894,9410,8241,10332,10325,10326,10327,10725,10329,10328,10330,10331,10333,8329,11241,11407,9592,11046,9593,4769,5996,834,1537,3913,5435,4437,4438,6602,4086,1270,1153,10371,11207,11205,6354,11209,11590,11394,8618,3882,8692,9147,4121,11899,7546,11007,11153,8596,10324,9411,10729,10328,11050,10335,11240,11618,10326,9894,10102,10195,10136,10215,11899,8586,3890,11218,10193,7870,8313,8699,8324,9908,10829,11934,10218,11405,11624,11563,11046,11934,10725,8585,7546,8586,8618,11722,9920,10565,8315,8310,11722,11617,8584,11759,11009,10556,10139,10325,11618,10238,10562,11933,9407,8271,7870,10333,11407,8586,3893,11615,9084,3897,3894,10324,11899,394,11156,3883,3890,10327,6270,10565,11161,3891,10323,11019,3889,367,10331,3888,6505,6076,11242,11318,8273,6533,11493,3881,11241,11249,7546,8274,3885,11139,11046,3892,11154,11159,11405,3895,3884,11153,11218) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC