SELECT p_id, p_title, p_text, p_price, p_sort_order, p_quantity, p_status FROM products  WHERE p_status = 1 ORDER BY p_quantity,p_sort_order);

 

 

...WHERE ... AND 'status'!=0 ...

 

 

SELECT * FROM TABLE WHERE id=1;

SELECT * FROM TABLE WHERE id=2;

 

 

SELECT t1.`id`,t2.`id`,t3.`id`,t4.`id`

FROM `new_table` AS t1

LEFT JOIN `new_table` AS t2 ON t1.`id`=t2.`parent`

LEFT JOIN `new_table` AS t3 ON t2.`id`=t3.`parent`

LEFT JOIN `new_table` AS t4 ON t3.`id`=t4.`parent`

WHERE t1.`id`=1;