SELECT $sql_tbl[products].*,
       min($sql_tbl[pricing].price) AS price,IF($sql_tbl[images_T].id IS NULL, '', 'Y') AS is_thumbnail, $sql_tbl[images_T].image_path, $sql_tbl[images_T].image_x, $sql_tbl[images_T].image_y,
IF($sql_tbl[images_P].id IS NULL, '', 'P') AS is_pimage, $sql_tbl[images_P].image_path AS pimage_path, $sql_tbl[images_P].image_x AS pimage_x, $sql_tbl[images_P].image_y AS pimage_y FROM $sql_tbl[pricing],$sql_tbl[products] LEFT JOIN $sql_tbl[images_T] ON $sql_tbl[images_T].id = $sql_tbl[products].productid LEFT JOIN $sql_tbl[images_P] ON $sql_tbl[images_P].id = $sql_tbl[products].productid WHERE $sql_tbl[products].productid=$sql_tbl[pricing].productid
AND
$sql_tbl[products].forsale != 'N'
AND
$sql_tbl[products].productid='$productid'
AND
$avail_condition $sql_tbl[pricing].quantity<='$amount'
AND
$sql_tbl[pricing].membershipid IN('$membershipid',
                                  0)
AND
$sql_tbl[pricing].variantid = '$variantid' GROUP BY $sql_tbl[products].productid ORDER BY $sql_tbl[pricing].quantity DESC