SELECT SQL_CALC_FOUND_ROWS
dpcd.*
FROM
d_pcd_all dpcd
JOIN
d_data ddd ON ddd.pcd_all_id = dpcd.id
JOIN
d_radius_depend drd ON drd.model_code = ddd.code
JOIN
d_size_depend dsd ON dsd.id = drd.size_id
JOIN
d_radius dsr ON dsr.id = dsd.radius_id
JOIN
d_size dsw ON dsw.id = dsd.width_id
WHERE dsw.url ='8_0' AND dsr.name!='' AND dsr.name!='R'
Group by dpcd.name
Order by rpad (dpcd.name, 50, '!')
