Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 287
- SELECT *
- FROM yii_doc.TO_DELETE_vitrina_vl vl
- LEFT JOIN yii_doc.TO_DELETE_vitrina_ko ko ON vl.pa_id = ko.pa_id
- WHERE ko.id IS NULL;
- # 5 920
- SELECT *
- FROM yii_doc.TO_DELETE_vitrina_ko ko
- LEFT JOIN yii_doc.TO_DELETE_vitrina_vl vl ON vl.pa_id = ko.pa_id
- WHERE vl.id IS NULL;
- # 2 879
- SELECT *
- FROM yii_doc.TO_DELETE_vitrina_ko ko
- LEFT JOIN yii_doc.TO_DELETE_vitrina_vl vl ON vl.pa_id = ko.pa_id
- WHERE vl.id IS NOT NULL;
- # 45
- SELECT *
- FROM yii_doc.TO_DELETE_vitrina_ko ko
- LEFT JOIN yii_doc.TO_DELETE_vitrina_vl vl ON vl.pa_id = ko.pa_id
- WHERE vl.id IS NOT NULL
- AND (
- NOT(ko.avalaible <=> vl.avalaible)
- OR NOT(ko.price <=> vl.price)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement