delete_status = 0  and car_type != 2 and  daily_price_status='1' and  listings.client_id In (14,22,54,100,113,147,148,174,195,198,239,249,266,269,306,307,308,309,310,315,316,328,335,351,365,371,376,378,382,387,428,438,443,450,461,496,558,564,574,575,576,577,581,597,599,600,606,609,644,667,672,673,688,696,697,699,703,708,710,713,726,730,764,766,767,773,778,880,1007,1115,2010,2012,2013,2022,2024,2032,2033,2039,2040,2042,2047,2051,2058,2084,2086,3003,3004,3027,3029,3035,3050,3053,3057,3058,3063,3064,3066,3079,3081,3086,4001,4003,4023,4024,4026,4035,4037,4040,4041,4044,4051,4072,4080,4081,4091,4096,4105,4106,4126,7144,7148,7174,7180,7188,7197,7200,7203,7206,7223,7231,7243,7256,7262,7268,7269,7274,7311,7326,7331,7332,7346,7373,7380,7389,7402,7421,7426,7445,7479,7504,7507,7516,7517,7519,7522,7536,7541,7545,7554,7565,7574,7586,7595,7596,7600,7618,7623,7673,7677,7680,7695,7724,7738,7740,7741,7744,7748,7749,7767,7777,7803,7832,7838,7842,7848,7852,7853,7858,7860,7861,7862,7867,7871,7874,7876,7877,7878,7883,7884,7887,7892,7893,7894,7896,7903,7911,7914,7921,7925,7926,7929,7936,7938,9231,9234,9237,9241,9244,9245,9250,9251,9252,9256,9257,9259,9263,9264,9269,9274,9278,9280,9281,9287,9288,9290,9291) and clients.emirate like  '%Dubai%' and listings.client_id!=247  and listings.id NOT IN (43372,39980,33519)