Create a SQL request in OpenCart 2
8 USDAccording 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!
Добрый день уважаемые фрилансеры.
Задание такое - нужно помочь создать SQL запрос для OpenCart 2 в командную строку SQL
по такой логической схеме:
Если кратко сказать то - удалить все товары кроме тех товаров которые имеют хотя бы 1 опцию из этих 68, 66, 64, 62, 60, 58, 56, 54, 52, 50, XXL, XXXL, XXXXL, XXXXXL, XXXXXXL;
Как вы догадались удалить все товары кроме тех что имеют хотя бы 1 опцию из перечисленных - это размер одежды.
Как я это понимаю в командной строке:
DELETE FROM `baby-baby-db`.`oc_product` WHERE `oc_option_value_description`.`name` != 'XXXXXXL' AND != 'XXXXXL' AND != 'XXXXL' AND != 'XXXL' AND != 'XXL' AND != '68' AND != '66' AND != '64' AND != '62' AND != '60' AND != '58' AND != '56' AND != '54' AND != '52' AND != '50';
(но что то не сработало 🙂)
Для тех кто не знает структуру DB OpenCart 2, сказу скажу что таблица - `oc_product` и`oc_option_value_description` и шапка `name` это 2 разные таблицы.
Жду заявок или 200 грн. на карту тому кто первый по тайму напишет рабочий запрос так же актуально!
Client's feedback on 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 day8 USD
5394 773 0 Winning proposal1 day8 USDI can do it without problems.
• • • • • •
Могу без проблем сделать
----------------------------------------------------------
Current freelance projects in the category PHP
Admin panel for an article websiteGood day. It is necessary to write an admin panel for a gaming article website (this website - https://themeforest.net/item/goodgames-portal-store-html-gaming-template/17704593) The admin panel should include: 1. **User Management:** - Creating new users. - Editing… HTML and CSS, PHP ∙ 4 proposals |
Laravel + VueJS + InertiaJSGood day, the project is written, it is working and ready to launch. Except for one nuance. SSR(Server Side Rendering) works very slowly, when launching a bot to check the load - the site crashes after 3-4 minutes. If you restart SSR during the check, it works but very slowly.… JavaScript, PHP ∙ 2 proposals |
Change the logic of the promotion 1+1=3Video about what needs to be done https://www.loom.com/share/e73bc4b1b04c49f7b78acf95e9ce7d15?sid=73b5c8ee-c7c5-4518-86ef-acfc7ffda194 In short, the logic of the promotion 1+1=3 needs to be changed. Currently, when adding 2 pizzas of 40cm, a modal pops up where the user can… PHP ∙ 1 proposal |
Integrate 1c and WoocommerceIt is necessary to implement the import of goods from 1C to the Woocommerce website, as well as their updates. An important point is that there are a number of custom meta fields made through ACF, they also need to be imported. Import all media files for the product (Main photo,… 1C, PHP ∙ 1 proposal |
Laravel developer with skills working with SphinxHello, I am looking for a Laravel developer who can help improve the current functionality of one of the projects. Skills in working with Sphinx are important, as well as the ability to work with JS at a more or less basic level. Please specify the cost of 1 hour of your work in… PHP, Web programming ∙ 2 proposals |