Question: I have inherited a WP multisite without the access to the main site (network admin). I need to install a plugin and have unpacked it via FTP but need to enable it and can't. Any way of doing this via MySQL?

Answer: 
You have in your query `WHERE p.post_type IN ('post', 'page')`, that is why it shows only the posts and pages. Add post type **product** to query:
`WHERE p.post_type IN ('post', 'page', 'product')`
Replace this with your search form and products will show in results:

```
 <form method="get" id="searchform" action="<?php echo esc_url( home_url( '/' ) ); ?>">
    <label for="s">Search</label>
    <input type="text" class="field" name="s" id="s" placeholder="Search Something" />
    <input type="submit" class="submit" name="submit" id="searchsubmit" value="Search" />
    <input type="hidden" name="post_type" id="post_type" value="product"  />
</form>

```