Breaking News: Grepper is joining You.com. Read the official announcement!

$joinProductBranch = array('table' => 'product_branches', 'type' => 'INNER', 'alias' => 'ProductBranch', 'conditions' => array('ProductBranch.product_id = Product.id', 'ProductBranch.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$use

Lor Mengsong answered on August 29, 2023 Popularity 1/10 Helpfulness 1/10

answer $joinProductBranch = array('table' => 'product_branches', 'type' => 'INNER', 'alias' => 'ProductBranch', 'conditions' => array('ProductBranch.product_id = Product.id', 'ProductBranch.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$use

$joinProductBranch = array('table' => 'product_branches', 'type' => 'INNER', 'alias' => 'ProductBranch', 'conditions' => array('ProductBranch.product_id = Product.id', 'ProductBranch.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$use

Comment

SELECT 
    Product.id, 
    Product.code, 
    Product.barcode, 
    Product.name, 
    Product.photo, 
    Uom.id AS Uom_id, 
    Uom.abbr AS Uom_abbr, 
    Pgroup.id AS Pgroup_id
FROM 
    products AS Product
INNER JOIN 
    product_pgroups AS ProductPgroup ON ProductPgroup.product_id = Product.id
INNER JOIN 
    pgroups AS Pgroup ON Pgroup.id = ProductPgroup.pgroup_id 
    AND (Pgroup.user_apply = 0 OR (Pgroup.user_apply = 1 AND Pgroup.id IN (
        SELECT pgroup_id FROM user_pgroups WHERE user_id = [user_id]
    )))
INNER JOIN 
    product_branches AS ProductBranch ON ProductBranch.product_id = Product.id 
    AND ProductBranch.branch_id IN (
        SELECT branch_id FROM user_branches WHERE user_id = [user_id]
    )
INNER JOIN 
    uoms AS Uom ON Uom.id = Product.price_uom_id
WHERE 
    Product.id = [lastInsertId]
    AND Product.company_id IN (
        SELECT company_id FROM user_companies WHERE user_id = [user_id]
    )
    AND Product.is_active = 1 
    AND (Product.price_uom_id IS NOT NULL AND Product.is_packet = 0)
GROUP BY 
    Product.id;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: sql where

Link to this answer
Share Copy Link

Contributed on Aug 29 2023

Lor Mengsong

0 Answers Avg Quality 2/10

$joinProductBranch = array('table' => 'product_branches', 'type' => 'INNER', 'alias' => 'ProductBranch', 'conditions' => array('ProductBranch.product_id = Product.id', 'ProductBranch.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$use

Contents

More Related Answers

$joinProductBranch = array('table' => 'product_branches', 'type' => 'INNER', 'alias' => 'ProductBranch', 'conditions' => array('ProductBranch.product_id = Product.id', 'ProductBranch.branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$use

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.