Skip to content

Instantly share code, notes, and snippets.

@bsa7
Last active April 24, 2017 09:07
Show Gist options
  • Save bsa7/c30fc0d41821b5a4f70fc35a9c7cc992 to your computer and use it in GitHub Desktop.
Save bsa7/c30fc0d41821b5a4f70fc35a9c7cc992 to your computer and use it in GitHub Desktop.
Расхождения связей по изображениям

Запрос к дампу matrix от 23.04.2017

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
    -> ON catalog1c_Realty_ObjectPropertyFile.MasterFile = catalog1c_Realty_ObjectProperty.id
    -> WHERE catalog1c_Realty_ObjectProperty.id1c = 'О00011555'
    -> ;
+--------------------+
| WayFile            |
+--------------------+
| 20170331/k8ldi.jpg |
| 20170331/1hwir.jpg |
| 20170331/fusgz.jpg |
| 20170331/f5yxp.png |
+--------------------+
4 rows in set (0.93 sec)
```mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment