select *, CONCAT(SUBSTR(phone, 1, 6), REPEAT('*', CHAR_LENGTH(phone) - 6)) as mobile, phone as phonenottousefordisplay, ( select CONCAT(SUBSTR(cust.name, 1, 6), REPEAT('*', CHAR_LENGTH(cust.name) - 6)) from classifieds_customer cust where cust.phone = classifieds_broadcast.phone order by id desc limit 1 ) as name, (select hits from classifieds_subscriptionwhatsapp where classifieds_subscriptionwhatsapp.phone = classifieds_broadcast.phone order by classifieds_subscriptionwhatsapp.id desc limit 1) as 'hits', (select max(classifieds_subscriptionwhatsapplog.created_date) from classifieds_subscriptionwhatsapplog where classifieds_subscriptionwhatsapplog.phone = classifieds_broadcast.phone and classifieds_subscriptionwhatsapplog.aid = classifieds_broadcast.aid order by classifieds_subscriptionwhatsapplog.id desc limit 1) as 'recenthiton', (select col_4 from classifieds_advertisement where classifieds_advertisement.email_details like concat('%',classifieds_broadcast.`phone`,'%') order by id desc limit 0, 1) as Budget_Price, (select id from classifieds_advertisement where classifieds_advertisement.email_details like concat('%',classifieds_broadcast.`phone`,'%') order by id desc limit 0, 1) as Budget_Price_AdId, (select name from classifieds_classifiedsuser where id = (select zid from classifieds_advertisement where classifieds_advertisement.email_details like concat('%',classifieds_broadcast.`phone`,'%') order by id desc limit 0, 1)) as Budget_Price_AdId_City, (select title from classifieds_advertisement where classifieds_advertisement.email_details like concat('%',classifieds_broadcast.`phone`,'%') order by id desc limit 0, 1) as Budget_Price_AdId_Title from classifieds_broadcast where aid=11569 order by id desc
Details
Requirement:RENT
Rental Type:Want Rental Property
Furnishing:Unfurnished
Bedrooms:2BHK
Looking for:Family
Work Location and how many members :Government medical college
Budget :For 3 membere