mysql> SELECT t1.product_id id,t3.type,t3.order,t3.title,t2.value FROM h_products t1 LEFT JOIN slud_data t2 ON t2.product_id=t1.product_id LEFT JOIN slud_types t3 ON t3.type_id=t2.type_id WHERE category_id=27 and display=1 ORDER BY t1.product_id,t3.type=7 desc,t3.order asc;
+----+------+-------+--------------------------------------------------------------------------+---------------------------+
| id | type | order | title                                                                    | value                     |
+----+------+-------+--------------------------------------------------------------------------+---------------------------+
|  4 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | XP9ni7HkY8pa9b1KGmSC.jpg  |
|  4 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | RÄ«ga                      |
|  4 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Andris                    |
|  5 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | HobVDcPkab9iJpitGr1k.jpg  |
|  5 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | RÄ«ga                      |
|  5 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Andris                    |