Create a SQL request in OpenCart 2
7 USD 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!
Client's review of cooperation with Andrey S
Create a SQL request in OpenCart 2Very 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!
-
Winning proposal1 day7 USD
3068 805 0 Winning proposal1 day7 USDI can do it without problems.
• • • • • •
Current freelance projects in the category PHP
Integration needed: KeyCRM → Cash Register KashalotIt is necessary to set up integration between KeyCRM and the Cash Register Kahalot. When placing an order in KeyCRM, the data must be automatically transmitted to Kahalot: • order information • products, nomenclature • prices • quantity More details in private. Content Management Systems, PHP ∙ 1 day 4 hours back ∙ 27 proposals |
A WordPress site using the Kadence theme and Kadence Blocks.
223 USD
We need to create a website on WordPress using the Kadence theme and Kadence Blocks. There will be no online store (although it may be added in the future). We need a homepage and several internal pages. The graphics are already prepared, the layout structure is mostly defined,… Content Management Systems, PHP ∙ 2 days 13 hours back ∙ 38 proposals |
Development of 2 SEO-oriented websites for selling spare parts (ATVs and special equipment)Development of Two Specialized Websites for Selling Spare PartsGeneral Information It is necessary to develop two specialized websites: Spare parts for ATVs, UTVs, SSVs, and other similar equipment. Spare parts for special equipment. Existing company website:… PHP, Web Programming ∙ 3 days 11 hours back ∙ 76 proposals |
Development of a WordPress website
22 USD
We are looking for a contractor to develop a custom website on WordPress for a jewelry store. The first stage will be a consultation. Content Management Systems, PHP ∙ 6 days 2 hours back ∙ 73 proposals |
Parser expireddomains.net
112 USD
A parser is needed for expireddomains.net. You need to log in to the site first; the problem is that it blocks the IP when trying to parse data. You need to parse thematic domains based on a list of keywords. If you are not confident in your abilities, please do not write. PHP, Web Programming ∙ 8 days 10 hours back ∙ 52 proposals |
Kyiv