SELECT
x.`title`
FROM
`#__occupation_data` AS x
JOIN `#__occupation_data` AS y ON SUBSTRING_INDEX(x.onetsoc_code, '-', 2) = SUBSTRING_INDEX(y.onetsoc_code, '-', 2)
WHERE
y.`title` = '[cb_cat_bus2]'
AND right(x.onetsoc_code, 2) > '00'
ORDER BY
x.`title`
Please Log in to join the conversation.
SELECT * FROM `#__users` LIMIT 10
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.