Slide 14
Slide 14 text
"MMDPOUFOUTh.VMF4PGU*OD
%BUBCBTF$POOFDUPSˊ 2VFSZך㹀纏
1. SQL Query Text
http://bit.ly/jp_mulehandson_2
2. Input Parameters
- Key : id
- Value : attributes.uriParams.productId
SELECT product.*, CONCAT('["', (GROUP_CONCAT(variant.picture SEPARATOR
'", "')),'"]') AS pictures, CONCAT('[',
GROUP_CONCAT('{"',variant.identifierType, '":"', variant.identifier,
'"}'),']') AS identifiers FROM product INNER JOIN variant ON product.uuid
= variant.productUUID WHERE product.uuid = :id;