SELECT pc.* FROM oc_product_colors pc LEFT JOIN oc_product p ON (p.product_id = pc.product_id) WHERE pc.product_id='2499' AND p.status=1
Array
(
    [0] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1981
        )

    [1] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1994
        )

    [2] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1993
        )

    [3] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1991
        )

    [4] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1992
        )

    [5] => Array
        (
            [product_id] => 2499
            [product_color_id] => 1995
        )

)
#166 - CHARCOAL - Small Jerusalem Brick corner 24"H x 12"W x 1 1/2"D
First Name:  
Last Name:  
Address Street1:  
Address Street2:  
City:  
Zip Code:  
State:  
Daytime Phone:  
Evening Phone:  
Email:  
How Did You Hear About Us:  
Comment:  
Security Code:   10 + 1 =
   
Sorry only Sample products are allowed to be purchased...