SELECT * FROM `wp_sada_artists`, ( select count(*) from `wp_sada_artists_photos` where `wp_sada_artists_photos`.`artist_id`= `wp_sada_artists`.`ID`) as photosCount LIMIT 20 OFFSET  0

SELECT * FROM `wp_sada_artists`ORDER BY `wp_sada_artists`.`ID` ASC

CREATE TABLE IF NOT EXISTS `wp_sada_artists` (
`ID` int(10) unsigned NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  ...
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

ALTER TABLE `wp_sada_artists`
 ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `wp_sada_artists_name_UNIQUE` (`name`), ADD KEY `ind_wp_sada_artists _is_active_ordering` (`is_active`,`ordering`);


ALTER TABLE `wp_sada_artists`
MODIFY `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;