testdon_querystring(1063) "
SELECT DISTINCT
psp.product_id,
ibpp.image_id,
psm.model_id,
psm.name,
pst.description,
pspt.texture_id,
pst.name as texture,
pspp.value as color,
pspp2.value as code
FROM
ps_models psm
INNER JOIN
ps_products psp
ON
psm.model_id = psp.model_id
INNER JOIN
ib_projects_products ibpp
ON
psp.product_id = ibpp.product_id
LEFT JOIN
ps_products_properties pspp
ON
psp.product_id = pspp.product_id
AND
pspp.property_id = 30
LEFT JOIN
ps_products_properties pspp2
ON
psp.product_id = pspp2.product_id
AND
pspp2.property_id = 48
LEFT JOIN
ps_products_textures pspt
ON
psp.product_id = pspt.product_id
LEFT JOIN
ps_textures pst
ON
pspt.texture_id = pst.texture_id
WHERE
1 = 1
AND
ibpp.project_id = 220
"