SELECT rnkid,rnktitle,rankpicname,weburl,rankyear,mag_id,app_status FROM ranking where mag_id=(select sno from magazine_details where label2='June' and year=2019) and app_status=1
select a.magazine_id,a.companyname,a.companytitle,a.management_name,a.designation,a.management_name2,a.image,a.image2,a.image3,b.weburl,a.companyid,a.column1 from companies a , ranking b where a.rank_id = b.rnkid and a.magazine_id ='9' and CHAR_LENGTH(a.column1)>408 and a.image2!='' order by a.companyid desc limit 3
ForgeRock: Driving the Connected Automotive Era | Auto Tech Outlook Tech
Thank You for subscribing with us !
