SELECT
                    a1.cooperator_pk,
                    a1.pk AS product_pk,
                    CONCAT(a1.picture_name, ' ', a1.model_name) AS product_name,
                    a1.model_pk,
                    a1.model_price AS price,
                    a1.model_cost AS cost,
                    a1.model_sale_price AS sale_price,
                    a1.model_show_image_type AS show_image_type,
                    a1.model_description,
                    a1.picture_image
                FROM
                    product AS a1
                WHERE
                    a1.status='Y' AND
                    a1.model_status='Y' AND
                    a1.picture_status='Y' AND
                    (
                        a1.model_category1_pk='26' OR
                        a1.model_category2_pk='26' OR
                        a1.model_category3_pk='26'
                    ) AND a1.model_pk='27' AND a1.picture_pk='8081' ORDER BY sort  ASC LIMIT 0, 36