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                    |
| 12 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | tFpHRnUJeMZTkn3BDZTJ.jpg  |
| 12 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 12 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |
| 13 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | pDkCDniNGr7Dt9RJGH28.jpg  |
| 13 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 13 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |
| 14 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | daM0PtEL2ZrQB05rRCaC.jpg  |
| 14 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 14 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |
| 15 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | nUctQCAXFslQB0T8GsQl.jpg  |
| 15 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 15 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |
| 16 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | 7GVgAK3BDdBYsl5l6liL.jpg  |
| 16 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 16 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |
| 17 |    7 |    12 | a:2:{s:2:"lv";s:12:"QXR0xJNscw==";s:2:"ru";s:12:"QXR0xJNscw==";}         | 7oJkTBPKWCJEBn3dSMUc.jpg  |
| 17 |    1 |     1 | a:2:{s:2:"lv";s:8:"VmlldGE=";s:2:"ru";s:8:"VmlldGE=";}                   | Eži                       |
| 17 |    1 |     6 | a:2:{s:2:"lv";s:16:"xKpwYcWhbmlla3M=";s:2:"ru";s:16:"xKpwYcWhbmlla3M=";} | Rinalds KÄrkliÅš   |