delete_status = 0  and car_type != 2 and  daily_price_status='1' and  listings.client_id In (147,148,209,266,365,450,512,574,597,672,688,767,3050,3080,4094,4123,7145,7174,7203,7268,7269,7353,7504,7507,7516,7536,7565,7623,7673,7677,7737,7842,7848,7884,7921,7926,9280,9287) and clients.emirate like  '%Dubai%' and listings.client_id!=247  and listings.id NOT IN (43372,39980,33519)