delete_status = 0  and car_type != 2 and  daily_price_status='1' and  listings.client_id In (14,51,90,148,172,189,198,204,209,348,365,375,379,383,417,419,423,427,431,438,440,443,444,445,446,461,465,466,474,486,487,504,523,527,558,559,570,574,575,576,577,581,582,593,595,597,600,609,616,622,625,628,629,634,635,636,637,639,643,649,662,663,664,665,671,672,675,685,688,689,697,704,719,721,732,736,741,761,764,767,768,773,880,1009,1116,1119,1786,2017,2018,2022,2024,2025,2030,2033,2041,2052,2072,2073,2074,2075,2080,2082,2084,2085,2087,2091,3003,3028,3046,3050,3053,3059,3061,3064,3066,3073,3079,3080,3081,4001,4005,4010,4017,4019,4031,4033,4037,4039,4042,4044,4050,4051,4054,4062,4064,4074,4079,4082,4087,4089,4104,4106,4122,4170,7145,7149,7156,7157,7164,7173,7174,7176,7178,7182,7183,7185,7188,7189,7195,7200,7203,7204,7205,7212,7223,7224,7225,7226,7230,7231,7234,7235,7236,7262,7268,7269,7318,7334,7338,7340,7341,7346,7347,7353,7365,7402,7404,7406,7409,7418,7438,7445,7458,7504,7507,7514,7516,7536,7565,7569,7586,7595,7600,7618,7623,7673,7680,7695,7718,7727,7732,7737,7738,7741,7744,7748,7776,7777,7803,7842,7852,7854,7859,7871,7879,7887,7892,7894,7896,7903,7911,7921,7925,7928,7936,7938,9231,9240,9244,9245,9257,9264,9265,9267,9269,9273,9274,9279,9280,9287,9288) and clients.emirate like  '%Dubai%' and listings.client_id!=247  and listings.id NOT IN (43372,39980,33519)