Can we use SOQL query in VF page?
If yes then please give an eg.

Hello,

A  'lookup' window have to be open automatically when page loads, so I used the below code. It is working fine in Chrome and firefox but not in IE.
eg: I want to open the 'account' lookup window on contact

Here is the vf page:

<apex:page standardController="Contact" id="page">

    <apex:form id="form1">
    <apex:inputField value="{!Contact.AccountId}" id="acc"/>
    </apex:form>
 
    <script type='text/javascript'>
window.onload=function()
{
// alert('check');
var l = document.getElementById('page:form1:acc_lkwgt');
// document.getElementById('page:form1:acc_lkwgt').click();
l.click();
  }
      </script>
</apex:page>

Hi guys/gals,

Do you have any idea on how to obtain the Cloak of Adventure sweatshirt after completing 5 badges on trailheads?

Source: http://go.pardot.com/l/27572/2016-01-06/4wy4tn?utm_campaign=newyear-trailhead-sweatshirt

I haven't received any email address or notification about the completion after I had received 5 new badges on my profile. 

The sweetshirt looks really cool and I want to get it :D  Ty
 

Hello,

A  'lookup' window have to be open automatically when page loads, so I used the below code. It is working fine in Chrome and firefox but not in IE.
eg: I want to open the 'account' lookup window on contact

Here is the vf page:

<apex:page standardController="Contact" id="page">

    <apex:form id="form1">
    <apex:inputField value="{!Contact.AccountId}" id="acc"/>
    </apex:form>
 
    <script type='text/javascript'>
window.onload=function()
{
// alert('check');
var l = document.getElementById('page:form1:acc_lkwgt');
// document.getElementById('page:form1:acc_lkwgt').click();
l.click();
  }
      </script>
</apex:page>