[SQL] Items weergave (Opgelost)

SELECT DISTINCT (shop_structures.structure_id), structure_name, type_name, type_price, structure_type_id, type_description
FROM shop_structures
INNER JOIN shop_structures_type ON ( shop_structures_type.structure_id = shop_structures.structure_id )
LEFT JOIN users_shop ON ( users_shop.type_id != structure_type_id )
WHERE users_shop.user_id = 2
AND users_shop.product = "s"
ORDER BY structure_name ASC

SELECT DISTINCT (shop_structures.structure_id), structure_name, type_name, type_price, structure_type_id, type_description
FROM shop_structures
INNER JOIN shop_structures_type ON ( shop_structures_type.structure_id = shop_structures.structure_id )
LEFT JOIN users_shop ON ( users_shop.type_id != structure_type_id )
WHERE users_shop.user_id = 2
AND users_shop.product = "s"
ORDER BY structure_name ASC

SELECT shop_structures.structure_id, structure_name, type_name, type_price, structure_type_id, type_description
FROM shop_structures
INNER JOIN shop_structures_type ON ( shop_structures_type.structure_id = shop_structures.structure_id )
WHERE structure_type_id NOT IN 
(
  SELECT type_id 
  FROM users_shop
  WHERE user_id = ' . $_SESSION['userdata']['userid'] . '
  AND users_shop.product = "s"
)

SELECT shop_structures.structure_id, structure_name, type_name, type_price, structure_type_id, type_description
FROM shop_structures
INNER JOIN shop_structures_type ON ( shop_structures_type.structure_id = shop_structures.structure_id )
WHERE structure_type_id NOT IN 
(
  SELECT type_id 
  FROM users_shop
  WHERE user_id = ' . $_SESSION['userdata']['userid'] . '
  AND users_shop.product = "s"
)