SELECT
				*
				FROM siptr_goods
				WHERE
				idbrand='121'
				&&
				show_status='y'
				&&
				virtual='n'
				ORDER BY idbrand, num