3'lü Aşure

set sql_mode=''; select product_attribute_sku.*, attribute_items.id, attribute_items.title, attribute_items.customurl, attribute_items.queue, attribute_groups.id as gid, attribute_groups.title as gtitle, attribute_groups.customurl as gcustomurl, attribute_groups.type, attribute_groups.queue as gqueue from product_attribute_sku left join product_attribute_combination on product_attribute_combination.product_attribute_sku_id = product_attribute_sku.attribute_related_id left join attribute_items on attribute_items.id = product_attribute_combination.attribute_id left join attribute_groups on attribute_items.parentgroupid = attribute_groups.id where product_attribute_sku.product_id='289' and attribute_items.langid='1' and attribute_groups.langid='1' and product_attribute_sku.stock>5 order by attribute_groups.queue desc,attribute_items.queue desc