SELECT t2.type,t5.value name,IF(t2.type=8,t4.value,t3.value) value, IF(t2.type=8,t4.value,t3.value) value,t2.type_id FROM slud_types t2
               LEFT JOIN slud_data t3 ON t3.type_id=t2.type_id AND t3.product_id=42
               left join slud_c2t t6 on t6.category_id= and t6.type_id=t2.type_id
               LEFT JOIN textdata t5 ON t5.item_id=t2.type_id AND sub_id=1  AND t5.lng='lv'
               LEFT OUTER JOIN typeslist t4 ON t4.type_id=t3.type_id AND t4.list_id=t3.value AND t4.lng='lv'
               where t5.value is not NULL and t3.value is not nULL and length(t3.value) > 0 and deleted=0 and t6.type_id IS NOT NULL
               group by type_id
               ORDER By t2.`order`