Create a SQL request in OpenCart 2

PHP, Online Stores & E-commerce — incorrectly specified categories?

7 USD

Client's review of cooperation with Andrey S

Create a SQL request in OpenCart 2

7 USD

Very satisfied with the work. He is satisfied with the speed, satisfied with the price and attitude to work and people!
Thank you for help! I will not talk once again!

5.0

Roman Boo

Reciprocal Feedback

13 June 2020

Freelancer's review of cooperation with Roman Boo

Create a SQL request in OpenCart 2

7 USD

Well, I recommend cooperation!

5.0

Project translated automatically. Log in or register, to view the original Good day dear freelancers.This is the task - you need to help create a SQL request for OpenCart 2 in the SQL command line According to this logical scheme: In short, to remove all goods except those goods that have at least 1 option of these 68, 66, 64, 62, 60, 58, 56, 54, 52, 50, XXL, XXXL, XXXXL, XXXXXL, XXXXXXL; As you guessed to remove all items except those that have at least 1 option from the listed - this is the size of clothes.How I understand this in the command line: DELETE FROM `baby-baby-db`.`oc_product` WHERE `oc_option_value_description`.`name` != 'XXXXL' AND != 'XXXXL' AND != 'XXL' AND != 'XXL' AND != '68' AND != '66' AND != '64' AND != '62' AND != '60' AND != '58' AND != '56' AND != '54' AND != '52' AND != '50'; (But it didn’t work.) For those who don’t know the structure of DB OpenCart 2, I’ll say that the table – ‘oc_product’ and ‘oc_option_value_description’ and the hat ‘name’ are 2 different tables.I am waiting for applications or 200 UAH.On the map to the first person to write the job request is equally relevant!

Proposals 1