Stuff

$query = "SELECT DISTINCT p.*, pd.*
FROM " . TABLE_PRODUCTS . " p
								LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id
								WHERE p.products_id = pd.products_id 
								AND p.products_image = " . '' . "LIMIT 10";