SELECT
zk_instrument_brand.bra_id,
zk_instrument_brand.bra_name
FROM
zk_instrument_subcategory_brand, zk_instrument_brand
WHERE
zk_instrument_subcategory_brand.sbra_category_id = 10⊂category_id=55
AND
zk_instrument_subcategory_brand.sbra_subcategory_id = 54
AND
zk_instrument_subcategory_brand.sbra_brand_id = zk_instrument_brand.bra_id
ORDER BY
zk_instrument_brand.bra_name ASC
SELECT
zk_instrument_carproperty.pro_id,
zk_instrument_carproperty.pro_name
FROM
zk_instrument_subcategory_carproperty, zk_instrument_carproperty
WHERE
zk_instrument_subcategory_carproperty.spro_category_id = 10⊂category_id=55
AND
zk_instrument_subcategory_carproperty.spro_subcategory_id = 54
AND
zk_instrument_subcategory_carproperty.spro_carproperty_id = zk_instrument_carproperty.pro_id
ORDER BY
zk_instrument_carproperty.pro_name ASC ซินเธไซเซอร์, หน้า1 : เครื่องดนตรีมือสอง.com
