多子语句sql查询写法

SELECT
	(
		SELECT
			cv.classid
		FROM
			vl_classVirProd AS cp,
			vl_classVirtual AS cv
		WHERE
			cp.classID = cv.classid
		AND cv.virParentID = 0
		AND cp.prodID = p.prodID
		LIMIT 1
	) AS 'cid',
	(
		SELECT
			className
		FROM
			vl_classVirtual
		WHERE
			classid = cid
		LIMIT 1
	) AS 'cname',
	(
		SELECT
			count(*)
		FROM
			vl_order AS o,
			vl_orderdetail AS od
		WHERE
			od.orderID = o.orderID
		AND o.orderDate > '2014 - 06 - 18'
		AND prodID = p.prodID
		AND prodType = 0
		LIMIT 1
	) AS 'hotSell',
	p.prodID,
	p.prodNo,
	p.prodName,
	p.oldPrice,
	p.NewPrice,
	p.putTime,


IF (p.putTime > 2014 - 11 - 12, 1, 0) AS 'isNewP',
 p.pic
FROM
	vl_product AS p
WHERE
	p.isput = 1
AND p.issell = 1
ORDER BY
	p.putTime DESC