SELECT  products.title_en as title,seller.company_name<br />
 FROM products<br />
join users_sellers seller on seller.user_id=products.user_id<br />
 WHERE products.product_id in ()<br />
<br />
<br />
<br />

        <link rel="stylesheet" href="/shared/less/main.v1656080627.css" type="text/css" />
        <script>
    $(function(){
        script=new TN.script({url:'/css/view_product.1651228808.css',type:'css'});
    TN.loader.loadScript(script,function(){});
        script=new TN.script({url:'/css/forms.1651228808.css',type:'css'});
    TN.loader.loadScript(script,function(){});
            
        script=new TN.script({url:'/js/view_product.1651228808.js',type:'js'});    
    TN.loader.loadScript(script,function(){});
    })
</script>
        <form action="/?page=mvc&p=product&t=request" method="post" id="VPMessageForm">
            <input type="hidden" name="undo_ref"    value="0">
            <input type="hidden" name="product_id"  value="">
            <input type="hidden" name="start"       value="1">
            <input type="hidden" name="referrer"    value="https://www.trademed.com/?page=mvc&p=product&t=contact&product_id=">
			<input type="hidden" name="type"       	value="product_info">
            <table cellpadding="0" cellspacing="6" border="0" align="center">
                <tr>
                    <td></td>
                    <td><span class="MyRequiredInformation"><b>*</b> Required Information</span></td>
                </tr>
                
                <script>
                    TN.loader.loadFrom("/js/view_product.js", "js", function(){
                        VP.nonUserInit();
                    });
                    TN.loader.loadFrom("/css/view_product.css","css");
                </script>
                <tr class="onLogin hidden">
                    <td></td>
                    <td class="LoggedIn">Logged in as <span id="loggedInAs"></span></td>
                </tr>
                <tr class="onLogin">
                    <td class="form_label">
                        <span class="form_required">*</span>
                        <span>Email</span>
                    </td>
                    <td class="form_data">
                            <input name="registration[email]" class="MyFormInput" type="text" id="VPMessageFrom">
                            <span class="emailExists hidden">
                                <span class="message">Already registered</span>
                            </span>
                    </td>
                </tr>
                <tr class="emailExists hidden onLogin" valign="top">
                    <td class="form_label" valign="top">
                        <span class="wrong_password">
                            Password                        </span>
                    </td>
                    <td class="of form_data">
                            <input class="MyFormInput fl" type="password" id="VPMessagePassword">
                            <span class="fl of" style="width:300px;padding-left:4px" id="VPPassMessagesHolder">
                                <span class="wrong_password hidden">
                                    <span class="message">
                                        Wrong Password.                                    </span>
                                </span>
                                <span class="message">
                                                                        If you have forgot password please <a href="/?page=mvc&p=user_password&t=remind_password">click here.</a>
                                </span>
                            </span>
                                                </td>
                </tr>
                
                <tr>
                    <td class="form_label"><b>To</b></td>
                    <td class="form_data MyFormTo">
                                            </td>
                </tr>
				
                <tr>
                    <td class="form_label">
                        <span class="form_required">*</span>

                        <span>
                            Message                        </span>

                    </td>
                        <td class="form_data">
                            <textarea name="user_message" required class="MyTextAreaXL" id="VPMessageMessage"></textarea>

                                                    </td>
                </tr>
                                        <tr>
                    <td><br></td>
                </tr>
                <tr>
                    <td colspan="2"><div class="fr">
                            <input type="Submit" id="VPMessageBtnSubmit" class="site_buttons" value="Send message to supplier">
                                            </td>
                </tr>
            </table>
        </form>