Array
(
[0] => Array
(
[cat_abb] => mk
[cat_label] => Merken
[cat_name] => brands
[cat_db_label] => brand_label
[cat_db_name] => brand_name
)
[1] => Array
(
[cat_abb] => kl
[cat_label] => Kleuren
[cat_name] => colours
[cat_db_label] => color_label
[cat_db_name] => color_name
)
[2] => Array
(
[cat_abb] => uv
[cat_label] => Uitvoering
[cat_name] => type
[cat_db_label] => type_label
[cat_db_name] => type_name
)
)
SELECT `coll`.*, `pr`.`product_id`, `pr`.`brand_id`, `mk`.*, `kl`.*, `uv`.*
FROM `collection` as `coll`
LEFT OUTER JOIN `products` as `pr` ON `coll`.`product_id` = `pr`.`product_id`
LEFT OUTER JOIN `brands` as `mk` ON `pr`.`brand_id` = `mk`.`brand_id`
LEFT OUTER JOIN `colours` as `kl` ON `coll`.`color_id` = `kl`.`color_id`
LEFT OUTER JOIN `types` as `uv` ON `coll`.`type_id` = `uv`.`type_id`
WHERE (`pr`.`status` = 1) GROUP BY `pr`.`product_id`
Array
(
[mk] => Array
(
[0] => merktest17
)
)
/mk:merktest17
