You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
mysql> SELECT WayFile FROM catalog1c_Realty_ObjectPropertyFile
-> LEFT JOIN catalog1c_Realty_ObjectProperty
-> ON catalog1c_Realty_ObjectPropertyFile.MasterFile = catalog1c_Realty_ObjectProperty.id
-> WHERE catalog1c_Realty_ObjectProperty.id1c = 'О00011555'
-> ;
+---------------------+
| WayFile |
+---------------------+
| 20150614/S/1944.jpg |
| 20150614/S/1945.jpg |
| 20150614/S/1946.jpg |
| 20150614/S/1944.jpg |
| 20150614/S/1945.jpg |
| 20150614/S/1946.jpg |
+---------------------+
6 rows in set (0.17 sec)
Запрос к дампу матрикс от 13.04
mysql> use matrix_master20170413_1604;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>SELECT WayFile FROM catalog1c_Realty_ObjectPropertyFile
->LEFT JOIN catalog1c_Realty_ObjectProperty
->ONcatalog1c_Realty_ObjectPropertyFile.MasterFile=catalog1c_Realty_ObjectProperty.id->WHEREcatalog1c_Realty_ObjectProperty.id1c='О00011555'-> ;
+--------------------+
| WayFile |
+--------------------+
| 20170331/k8ldi.jpg |
| 20170331/1hwir.jpg |
| 20170331/fusgz.jpg |
| 20170331/f5yxp.png |
+--------------------+4 rows inset (0.93 sec)
```mysql