delete_status = 0  and car_type != 2 and  daily_price_status='1' and  listings.client_id In (22,23,25,32,33,41,44,51,54,57,63,65,70,73,76,77,80,82,89,90,91,94,97,100,104,105,106,107,110,111,112,113,115,116,119,121,123,133,138,139,141,142,143,145,146,147,148,151,152,154,155,159,160,161,162,164,167,168,170,171,172,173,174,175,176,189,190,192,193,194,195,196,197,198,204,207,208,209,215,219,220,226,227,229,230,231,232,233,234,239,241,242,244,248,249,250,251,254,255,257,258,259,260,262,265,266,267,269,270,271,273,274,275,276,277,278,279,280,281,282,283,285,286,288,289,290,291,293,294,295,297,298,306,307,308,309,310,315,316,317,318,320,321,324,325,326,327,328,331,332,333,334,336,337,338,339,340,341,342,343,344,345,346,348,351,363,365,367,368,369,370,371,373,374,375,376,378,379,380,383,384,389,390,393,394,395,396,397,399,400,401,402,403,404,405,407,410,413,416,417,418,419,420,421,422,423,427,428,429,430,431,435,438,439,440,442,443,444,445,446,447,448,449,450,451,453,454,457,458,460,461,464,465,466,467,468,469,471,474,475,476,478,479,480,481,482,483,486,487,490,492,493,494,495,496,497,499,501,504,507,508,511,512,513,514,516,517,518,519,520,521,522,523,524,525,526,527,555,556,558,559,560,561,562,563,565,566,567,568,569,570,571,574,575,576,577,578,579,580,581,582,589,590,591,592,593,595,596,597,598,599,600,602,606,608,609,610,613,616,618,619,621,622,624,628,629,632,634,635,636,637,638,639,641,642,643,644,647,648,651,654,659,660,662,663,664,665,666,667,668,672,673,674,675,678,680,685,686,687,688,689,690,691,696,697,699,702,703,704,705,708,710,713,714,720,721,722,724,726,730,731,732,739,740,741,745,752,753,755,757,761,764,767,768,770,772,773,774,776,778,779,880,881,883,884,885,886,889,1001,1007,1008,1009,1034,1110,1115,1116,1117,1119,1786,2001,2004,2005,2006,2009,2010,2011,2012,2013,2017,2018,2019,2020,2021,2022,2023,2024,2025,2028,2029,2030,2032,2033,2034,2035,2036,2037,2039,2040,2041,2042,2043,2044,2045,2046,2047,2050,2051,2052,2053,2054,2057,2058,2059,2061,2062,2066,2068,2069,2072,2073,2074,2075,2078,2080,2082,2084,2085,2086,2087,2090,2091,2092,2093,2094,2095,2096,2097,3000,3001,3003,3004,3005,3011,3015,3016,3017,3018,3019,3021,3022,3023,3024,3025,3027,3028,3029,3035,3038,3041,3043,3044,3046,3048,3050,3051,3052,3053,3054,3055,3057,3058,3059,3060,3061,3063,3064,3066,3068,3069,3072,3073,3074,3077,3079,3080,3081,3086,3088,3091,3093,4000,4001,4003,4004,4005,4006,4009,4010,4011,4016,4017,4018,4019,4021,4023,4024,4026,4027,4028,4031,4033,4035,4036,4037,4038,4039,4040,4041,4042,4044,4046,4049,4051,4054,4058,4062,4064,4065,4066,4068,4072,4074,4075,4076,4078,4079,4080,4081,4082,4085,4087,4088,4089,4091,4093,4094,4096,4104,4105,4106,4107,4108,4109,4110,4111,4112,4113,4121,4122,4123,4125,4126,4169,4170,4171,4172,7144,7145,7148,7149,7156,7157,7164,7173,7174,7176,7177,7178,7180,7182,7183,7184,7185,7186,7187,7188,7189,7190,7195,7197,7199,7200,7201,7203,7204,7205,7206,7208,7212,7223,7225,7226,7227,7228,7230,7231,7234,7235,7236,7240,7241,7242,7243,7248,7249,7250,7251,7256,7261,7262,7268,7269,7270,7274,7311,7316,7318,7320,7323,7324,7326,7330,7331,7332,7333,7334,7336,7338,7340,7341,7346,7347,7348,7349,7353,7356,7365,7368,7373,7377,7380,7385,7389,7402,7404,7409,7410,7413,7418,7420,7421,7424,7426,7429,7438,7445,7457,7458,7467,7479,7504,7507,7514,7516,7517,7519,7522,7536,7541,7545,7553,7554,7565,7566,7569,7574,7586,7595,7596,7600,7611,7614,7618,7623,7635,7673,7677,7680,7695,7700,7707,7718,7719,7724,7727,7732,7737,7738,7739,7740,7741,7744,7748,7749,7767,7769,7771,7776,7777,7785,7803,7832,7838,7842,7846,7847,7848,7852,7853,7854,7858,7859,7860,7861,7862,7866,7867,7871,7874,7876,7877,7878,7879,7883,7884,7887,7892,7893,7894,7896,7903,7911,7914,7921,7925,7926,7928,7929,7936,7938,7942,7943,9231,9234,9237,9238,9240,9241,9244,9245,9247,9250,9251,9252,9256,9257,9259,9262,9263,9264,9265,9267,9269,9273,9274,9278,9279,9280,9281,9287,9288,9291) and clients.emirate like  '%Muscat%' and listings.client_id!=247