!!!SELECT * FROM assets_scan_paths WHERE 1=1  && `parent_id` = '0' && `status` = 'active' ORDER BY path