Написать запросы для базы Данных mysql

Bazy danych i SQL — podano nieprawidłowe kategorie?

Есть БД для работы с базой надо написать запросы.
Описание структура всё есть буду только показывать через демонстрацию экрана.
сам файл отправлю исполнителю.
вот один из элементов всего 19

SET  @ PCID  =  1014 ;  - Автобус FORD TRANSIT (V_ _) 2.0 (VAS, VIL, VLS, VUL, VZS)
 
   ВЫБОР 
         CONCAT (  MFA_BRAND ,  '' ,  MS_NAME . DES_TEXT ,  '' ,  PC_MODEL . DES_TEXT )  А.С.  TYPEL , 
         PC_COUNTRY_SPECIFICS . PCS_CONSTRUCTION_INTERVAL_START , 
         PC_COUNTRY_SPECIFICS . PCS_CONSTRUCTION_INTERVAL_END , 
         PC_COUNTRY_SPECIFICS . PCS_POWER_KW , 
         PC_COUNTRY_SPECIFICS . PCS_POWER_PS , 
         PC_COUNTRY_SPECIFICS . PCS_CAPACITY_TAX , 
         PC_COUNTRY_SPECIFICS .PCS_CAPACITY_LT , 
         PC_COUNTRY_SPECIFICS . PCS_CAPACITY_TECH , 
         PC_COUNTRY_SPECIFICS . PCS_ABS , 
         PC_COUNTRY_SPECIFICS . PCS_ASR , 
         PC_COUNTRY_SPECIFICS . PCS_NUMBER_OF_CYLINDERS ,
         
         PC_BODY_TYPE . DES_TEXT  AS  PC_BODY_TYPE , 
         PC_ENGINE_TYPE . DES_TEXT  AS  PC_ENGINE_TYPE , 
         PC_GEAR_TYPE . DES_TEXT  AS  PC_GEAR_TYPE , 
         PC_DRIVE_TYPE . DES_TEXT  AS  PC_DRIVE_TYPE , 
         PC_BRAKE_SYSTEM . DES_TEXT  AS  PC_BRAKE_SYSTEM , 
         PC_BRAKE_TYPE . DES_TEXT  AS  PC_BRAKE_TYPE , 
         PC_FUEL_TYPE . DES_TEXT  AS  PC_FUEL_TYPE , 
         PC_CATALYSATOR_TYPE .DES_TEXT  AS  PC_CATALYSATOR_TYPE , 
         PC_FUEL_MIXTURE . DES_TEXT  AS  PC_FUEL_MIXTURE ,
         
         ( ВЫБЕРИТЕ 
                GROUP_CONCAT ( ENGINES . ENG_CODE ) 
          ИЗ 
                ДВИГАТЕЛЕЙ, 
                ПРИСОЕДИНЯЙТЕСЬ К  ENG_DESIGNATIONS  ON  ( ENGINES . ENG_ID = ENG_DESIGNATIONS . ENG_ID ) 
          WHERE 
                ENG_DESIGNATIONS . PC_ID  =  PASSENGER_CARS . PC_ID )  AS  PC_ENG_CODES
         
   FROM  
         PASSENGER_CARS
         
         INNER  JOIN  PC_COUNTRY_SPECIFICS  ON  PC_COUNTRY_SPECIFICS . PCS_PC_ID  =  PASSENGER_CARS . PC_ID 
              AND  ( PC_COUNTRY_SPECIFICS . PCS_COU_ID  =  @ COUNTRY_FILTER  ИЛИ  PC_COUNTRY_SPECIFICS . PCS_COU_ID  =  255 )
         
         INNER  JOIN  MODELS_SERIES  ON  MODELS_SERIES . MS_ID  =  PASSENGER_CARS . PC_MS_ID
         
         ВНУТРЕННЕЕ  СОЕДИНЕНИЕ  ПРОИЗВОДИТЕЛЕЙ  ПО  ПРОИЗВОДИТЕЛЯМ . MFA_ID  =  PASSENGER_CARS . PC_MFA_ID
         
         INNER  JOIN  MS_COUNTRY_SPECIFICS  ON  MS_COUNTRY_SPECIFICS . MSCS_ID  =  MODELS_SERIES . MS_ID 
              AND  ( MS_COUNTRY_SPECIFICS . MSCS_COU_ID  =  @ COUNTRY_FILTER  ИЛИ  MS_COUNTRY_SPECIFICS . MSCS_COU_ID  =  255 ) 
              И  MS_COUNTRY_SPECIFICS . MSCS_AXL  =  0
        
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  MS_NAME  ON  MS_COUNTRY_SPECIFICS . MSCS_NAME_DES  =  MS_NAME . DES_ID  
              AND  MS_NAME . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_MODEL  НА  PASSENGER_CARS . PC_MODEL_DES  =  PC_MODEL . DES_ID  
              AND  PC_MODEL . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_BODY_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_BODY_TYPE  =  PC_BODY_TYPE . DES_ID  
              AND  PC_BODY_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_ENGINE_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_ENGINE_TYPE  =  PC_ENGINE_TYPE . DES_ID  
              AND  PC_ENGINE_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_GEAR_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_GEAR_TYPE  =  PC_GEAR_TYPE . DES_ID  
              AND  PC_GEAR_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_DRIVE_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_DRIVE_TYPE  =  PC_DRIVE_TYPE . DES_ID  
              AND  PC_DRIVE_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_BRAKE_SYSTEM  ON  PC_COUNTRY_SPECIFICS . PCS_BRAKE_SYSTEM  =  PC_BRAKE_SYSTEM . DES_ID  
              AND  PC_BRAKE_SYSTEM . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_BRAKE_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_BRAKE_TYPE  =  PC_BRAKE_TYPE . DES_ID  
              AND  PC_BRAKE_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_FUEL_TYPE  ON  PC_COUNTRY_SPECIFICS . PCS_FUEL_TYPE  =  PC_FUEL_TYPE . DES_ID  
              AND  PC_FUEL_TYPE . DES_LNG_ID  =  @ LNGID
              
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_CATALYSATOR_TYPE  
              ON  PC_COUNTRY_SPECIFICS . PCS_CATALYSATOR_TYPE  =  PC_CATALYSATOR_TYPE . DES_ID  
              AND  PC_CATALYSATOR_TYPE . DES_LNG_ID  =  @ LNGID
                            
         ЛЕВЫЙ  OUTER  JOIN  TEXT_DESIGNATIONS  AS  PC_FUEL_MIXTURE  ON  PC_COUNTRY_SPECIFICS . PCS_FUEL_MIXTURE  =  PC_FUEL_MIXTURE . DES_ID  
              И  PC_FUEL_MIXTURE . DES_LNG_ID  =  @ LNGID

   ГДЕ  
         PASSENGER_CARS . PC_ID  =  @ PCID

Aktualizacja #1 od 1 lipca 2020

Для работы над проектом понадобится хорошие знания php

Oferty 3 Wycofane 1 Dyskusje 4