<?php
//echo sprintf("CONCAT(product.%1s, (case when product.%1s != '' then CONCAT(' - ',product.%1s) else '' end), (case when product.%1s != '' then CONCAT(' - ',product.%1s) else '' end))", "name");
echo sprintf("CONCAT(product.%1$s, (case when product.%2$s != '' then CONCAT(' - ',product.%2$s) else '' end), (case when product.size != '' then CONCAT(' - ',product.size) else '' end))", "name", "color");
preferences:
37.01 ms | 402 KiB | 5 Q