-- - ITEM ------
SELECT * FROM `item`
  LEFT JOIN `c_category` ON `c_category`.`c_categoryid_pk`=`item`.`c_categoryid_pk_fk`
  LEFT JOIN `r_item_propertyvalue` ON `r_item_propertyvalue`.`itemid_pk_fk`=`item`.`itemid_pk`
  LEFT JOIN `propertyvalue` ON `propertyvalue`.`propertyvalueid_pk`=`r_item_propertyvalue`.`propertyvalueid_pk_fk`
  LEFT JOIN `c_property` ON `c_property`.`c_propertyid_pk`=`propertyvalue`.`c_propertyid_pk_fk`;

-- - ITEM info, the variable is in WHERE
SELECT * FROM `item`
  LEFT JOIN `c_category` ON `c_category`.`c_categoryid_pk`=`item`.`c_categoryid_pk_fk`
    WHERE `itemid_pk` = 1;

-- - ITEM properties, the variable is in WHERE
SELECT `r_item_propertyvalue`, `itemid_pk_fk`, `propertyvalueid_pk`, `c_propertyid_pk`, `propertyname`, `type`, `value`, `units`, `limits` FROM `r_item_propertyvalue`
  LEFT JOIN `propertyvalue` ON `propertyvalue`.`propertyvalueid_pk`=`r_item_propertyvalue`.`propertyvalueid_pk_fk`
  LEFT JOIN `c_property` ON `c_property`.`c_propertyid_pk`=`propertyvalue`.`c_propertyid_pk_fk`
   WHERE `itemid_pk_fk` = 1;
-- -------------

-- - BASKET ----
SELECT * FROM `basket`
  LEFT JOIN `item` ON `item`.`itemid_pk`=`basket`.`itemid_pk_fk`
  LEFT JOIN `c_category` ON `c_category`.`c_categoryid_pk`=`item`.`c_categoryid_pk_fk`
  LEFT JOIN `r_item_propertyvalue` ON `r_item_propertyvalue`.`itemid_pk_fk`=`item`.`itemid_pk`
  LEFT JOIN `propertyvalue` ON `propertyvalue`.`propertyvalueid_pk`=`r_item_propertyvalue`.`propertyvalueid_pk_fk`
  LEFT JOIN `c_property` ON `c_property`.`c_propertyid_pk`=`propertyvalue`.`c_propertyid_pk_fk`;

-- - BASKET basic info, the variable is in WHERE
SELECT * FROM `basket`
  LEFT JOIN item ON `item`.`itemid_pk`=`basket`.`itemid_pk_fk`
   WHERE `customerid_pk_fk` = 1;

-- - TEMPLATE
SELECT `categorytemplateid_pk`,`c_categoryid_pk`,`templatename`, `categoryname` FROM `categorytemplate`
  LEFT JOIN `c_category` ON `c_category`.`c_categoryid_pk`=`categorytemplate`.`c_categoryid_pk_fk`;

-- - Template properties for category, the variable is in WHERE
SELECT * FROM `r_categorytemplateitem`
  LEFT JOIN `c_property` ON `c_property`.`c_propertyid_pk`=`r_categorytemplateitem`.`c_propertyid_pk_fk`
    WHERE `categorytemplateid_pk_fk` = 2;