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

    [1] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2915
        )

    [2] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2917
        )

    [3] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2938
        )

    [4] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2939
        )

    [5] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2941
        )

    [6] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2943
        )

    [7] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2946
        )

    [8] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2947
        )

    [9] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2948
        )

    [10] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2949
        )

    [11] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2950
        )

    [12] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2951
        )

    [13] => Array
        (
            [product_id] => 5166
            [product_color_id] => 3205
        )

    [14] => Array
        (
            [product_id] => 5166
            [product_color_id] => 2953
        )

)
#136-CT2- ECLIPSE - Veneer Stacked Stone Outside Corner - 48"H x 3 ½" W x 1 ½"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:   8 + 8 =
   
Sorry only Sample products are allowed to be purchased...