com.liferay.portlet.social.service.base

Class SocialActivityLimitLocalServiceBaseImpl

Object

com.liferay.portal.kernel.service.BaseLocalServiceImpl

com.liferay.portlet.social.service.base.SocialActivityLimitLocalServiceBaseImpl

All Implemented Interfaces:

com.liferay.portal.kernel.module.framework.service.IdentifiableOSGiService, com.liferay.portal.kernel.service.BaseLocalService, com.liferay.portal.kernel.service.PersistedModelLocalService, com.liferay.social.kernel.service.SocialActivityLimitLocalService

Direct Known Subclasses:

SocialActivityLimitLocalServiceImpl

@ProviderType
public abstract class SocialActivityLimitLocalServiceBaseImpl
extends com.liferay.portal.kernel.service.BaseLocalServiceImpl
implements com.liferay.social.kernel.service.SocialActivityLimitLocalService, com.liferay.portal.kernel.module.framework.service.IdentifiableOSGiService

Provides the base implementation for the social activity limit local service.

This implementation exists only as a container for the default service methods generated by ServiceBuilder. All custom service methods should be put in SocialActivityLimitLocalServiceImpl.

Author:

Brian Wing Shun Chan

See Also:

SocialActivityLimitLocalServiceImpl, SocialActivityLimitLocalServiceUtil

{$generated.description}

Field Summary

Fields

Modifier and Type	Field and Description
protected com.liferay.counter.kernel.service.CounterLocalService	counterLocalService
protected com.liferay.portal.kernel.service.persistence.GroupFinder	groupFinder
protected com.liferay.portal.kernel.service.GroupLocalService	groupLocalService
protected com.liferay.portal.kernel.service.persistence.GroupPersistence	groupPersistence
protected com.liferay.portal.kernel.service.PersistedModelLocalServiceRegistry	persistedModelLocalServiceRegistry
protected com.liferay.social.kernel.service.SocialActivityLimitLocalService	socialActivityLimitLocalService
protected com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence	socialActivityLimitPersistence
protected com.liferay.portal.kernel.service.persistence.UserFinder	userFinder
protected com.liferay.portal.kernel.service.UserLocalService	userLocalService
protected com.liferay.portal.kernel.service.persistence.UserPersistence	userPersistence

Constructor Summary

Constructors

Constructor and Description
SocialActivityLimitLocalServiceBaseImpl()

Method Summary

Modifier and Type	Method and Description
com.liferay.social.kernel.model.SocialActivityLimit	addSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit) Adds the social activity limit to the database.
void	afterPropertiesSet()
com.liferay.social.kernel.model.SocialActivityLimit	createSocialActivityLimit(long activityLimitId) Creates a new social activity limit with the primary key.
com.liferay.portal.kernel.model.PersistedModel	deletePersistedModel(com.liferay.portal.kernel.model.PersistedModel persistedModel)
com.liferay.social.kernel.model.SocialActivityLimit	deleteSocialActivityLimit(long activityLimitId) Deletes the social activity limit with the primary key from the database.
com.liferay.social.kernel.model.SocialActivityLimit	deleteSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit) Deletes the social activity limit from the database.
void	destroy()
com.liferay.portal.kernel.dao.orm.DynamicQuery	dynamicQuery()
<T> List<T>	dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery) Performs a dynamic query on the database and returns the matching rows.
<T> List<T>	dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery, int start, int end) Performs a dynamic query on the database and returns a range of the matching rows.
<T> List<T>	dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<T> orderByComparator) Performs a dynamic query on the database and returns an ordered range of the matching rows.
long	dynamicQueryCount(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery) Returns the number of rows matching the dynamic query.
long	dynamicQueryCount(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery, com.liferay.portal.kernel.dao.orm.Projection projection) Returns the number of rows matching the dynamic query.
com.liferay.social.kernel.model.SocialActivityLimit	fetchSocialActivityLimit(long activityLimitId)
com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery	getActionableDynamicQuery()
com.liferay.counter.kernel.service.CounterLocalService	getCounterLocalService() Returns the counter local service.
com.liferay.portal.kernel.service.persistence.GroupFinder	getGroupFinder() Returns the group finder.
com.liferay.portal.kernel.service.GroupLocalService	getGroupLocalService() Returns the group local service.
com.liferay.portal.kernel.service.persistence.GroupPersistence	getGroupPersistence() Returns the group persistence.
com.liferay.portal.kernel.dao.orm.IndexableActionableDynamicQuery	getIndexableActionableDynamicQuery()
protected Class<?>	getModelClass()
protected String	getModelClassName()
String	getOSGiServiceIdentifier() Returns the OSGi service identifier.
com.liferay.portal.kernel.model.PersistedModel	getPersistedModel(Serializable primaryKeyObj)
com.liferay.social.kernel.model.SocialActivityLimit	getSocialActivityLimit(long activityLimitId) Returns the social activity limit with the primary key.
com.liferay.social.kernel.service.SocialActivityLimitLocalService	getSocialActivityLimitLocalService() Returns the social activity limit local service.
com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence	getSocialActivityLimitPersistence() Returns the social activity limit persistence.
List<com.liferay.social.kernel.model.SocialActivityLimit>	getSocialActivityLimits(int start, int end) Returns a range of all the social activity limits.
int	getSocialActivityLimitsCount() Returns the number of social activity limits.
com.liferay.portal.kernel.service.persistence.UserFinder	getUserFinder() Returns the user finder.
com.liferay.portal.kernel.service.UserLocalService	getUserLocalService() Returns the user local service.
com.liferay.portal.kernel.service.persistence.UserPersistence	getUserPersistence() Returns the user persistence.
protected void	initActionableDynamicQuery(com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery actionableDynamicQuery)
protected void	runSQL(String sql) Performs a SQL query.
void	setCounterLocalService(com.liferay.counter.kernel.service.CounterLocalService counterLocalService) Sets the counter local service.
void	setGroupFinder(com.liferay.portal.kernel.service.persistence.GroupFinder groupFinder) Sets the group finder.
void	setGroupLocalService(com.liferay.portal.kernel.service.GroupLocalService groupLocalService) Sets the group local service.
void	setGroupPersistence(com.liferay.portal.kernel.service.persistence.GroupPersistence groupPersistence) Sets the group persistence.
void	setSocialActivityLimitLocalService(com.liferay.social.kernel.service.SocialActivityLimitLocalService socialActivityLimitLocalService) Sets the social activity limit local service.
void	setSocialActivityLimitPersistence(com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence socialActivityLimitPersistence) Sets the social activity limit persistence.
void	setUserFinder(com.liferay.portal.kernel.service.persistence.UserFinder userFinder) Sets the user finder.
void	setUserLocalService(com.liferay.portal.kernel.service.UserLocalService userLocalService) Sets the user local service.
void	setUserPersistence(com.liferay.portal.kernel.service.persistence.UserPersistence userPersistence) Sets the user persistence.
com.liferay.social.kernel.model.SocialActivityLimit	updateSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit) Updates the social activity limit in the database or adds it if it does not yet exist.

Methods inherited from class com.liferay.portal.kernel.service.BaseLocalServiceImpl

getClassLoader, getLocalizationMap

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

addActivityLimit, fetchActivityLimit

Field Detail

socialActivityLimitLocalService

@BeanReference(type=com.liferay.social.kernel.service.SocialActivityLimitLocalService.class)
protected com.liferay.social.kernel.service.SocialActivityLimitLocalService socialActivityLimitLocalService

socialActivityLimitPersistence

@BeanReference(type=com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence.class)
protected com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence socialActivityLimitPersistence

counterLocalService

@BeanReference(type=com.liferay.counter.kernel.service.CounterLocalService.class)
protected com.liferay.counter.kernel.service.CounterLocalService counterLocalService

groupLocalService

@BeanReference(type=com.liferay.portal.kernel.service.GroupLocalService.class)
protected com.liferay.portal.kernel.service.GroupLocalService groupLocalService

groupPersistence

@BeanReference(type=com.liferay.portal.kernel.service.persistence.GroupPersistence.class)
protected com.liferay.portal.kernel.service.persistence.GroupPersistence groupPersistence

groupFinder

@BeanReference(type=com.liferay.portal.kernel.service.persistence.GroupFinder.class)
protected com.liferay.portal.kernel.service.persistence.GroupFinder groupFinder

userLocalService

@BeanReference(type=com.liferay.portal.kernel.service.UserLocalService.class)
protected com.liferay.portal.kernel.service.UserLocalService userLocalService

userPersistence

@BeanReference(type=com.liferay.portal.kernel.service.persistence.UserPersistence.class)
protected com.liferay.portal.kernel.service.persistence.UserPersistence userPersistence

userFinder

@BeanReference(type=com.liferay.portal.kernel.service.persistence.UserFinder.class)
protected com.liferay.portal.kernel.service.persistence.UserFinder userFinder

persistedModelLocalServiceRegistry

@BeanReference(type=com.liferay.portal.kernel.service.PersistedModelLocalServiceRegistry.class)
protected com.liferay.portal.kernel.service.PersistedModelLocalServiceRegistry persistedModelLocalServiceRegistry

Constructor Detail

SocialActivityLimitLocalServiceBaseImpl

public SocialActivityLimitLocalServiceBaseImpl()

Method Detail

addSocialActivityLimit

@Indexable(type=REINDEX)
public com.liferay.social.kernel.model.SocialActivityLimit addSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit)

Adds the social activity limit to the database. Also notifies the appropriate model listeners.

Specified by:

addSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

socialActivityLimit - the social activity limit

Returns:

the social activity limit that was added

createSocialActivityLimit

@Transactional(enabled=false)
public com.liferay.social.kernel.model.SocialActivityLimit createSocialActivityLimit(long activityLimitId)

Creates a new social activity limit with the primary key. Does not add the social activity limit to the database.

Specified by:

createSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

activityLimitId - the primary key for the new social activity limit

Returns:

the new social activity limit

deleteSocialActivityLimit

@Indexable(type=DELETE)
public com.liferay.social.kernel.model.SocialActivityLimit deleteSocialActivityLimit(long activityLimitId)
                                                                                                      throws com.liferay.portal.kernel.exception.PortalException

Deletes the social activity limit with the primary key from the database. Also notifies the appropriate model listeners.

Specified by:

deleteSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

activityLimitId - the primary key of the social activity limit

Returns:

the social activity limit that was removed

Throws:

com.liferay.portal.kernel.exception.PortalException - if a social activity limit with the primary key could not be found

deleteSocialActivityLimit

@Indexable(type=DELETE)
public com.liferay.social.kernel.model.SocialActivityLimit deleteSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit)

Deletes the social activity limit from the database. Also notifies the appropriate model listeners.

Specified by:

deleteSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

socialActivityLimit - the social activity limit

Returns:

the social activity limit that was removed

dynamicQuery

public com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery()

Specified by:

dynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

dynamicQuery

public <T> List<T> dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery)

Performs a dynamic query on the database and returns the matching rows.

Specified by:

dynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

dynamicQuery - the dynamic query

Returns:

the matching rows

dynamicQuery

public <T> List<T> dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery,
                                int start,
                                int end)

Performs a dynamic query on the database and returns a range of the matching rows.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent and pagination is required (start and end are not QueryUtil.ALL_POS), then the query will include the default ORDER BY logic from SocialActivityLimitModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.

Specified by:

dynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

dynamicQuery - the dynamic query

start - the lower bound of the range of model instances

end - the upper bound of the range of model instances (not inclusive)

Returns:

the range of matching rows

dynamicQuery

public <T> List<T> dynamicQuery(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery,
                                int start,
                                int end,
                                com.liferay.portal.kernel.util.OrderByComparator<T> orderByComparator)

Performs a dynamic query on the database and returns an ordered range of the matching rows.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent and pagination is required (start and end are not QueryUtil.ALL_POS), then the query will include the default ORDER BY logic from SocialActivityLimitModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.

Specified by:

dynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

dynamicQuery - the dynamic query

start - the lower bound of the range of model instances

end - the upper bound of the range of model instances (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching rows

dynamicQueryCount

public long dynamicQueryCount(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery)

Returns the number of rows matching the dynamic query.

Specified by:

dynamicQueryCount in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

dynamicQuery - the dynamic query

Returns:

the number of rows matching the dynamic query

dynamicQueryCount

public long dynamicQueryCount(com.liferay.portal.kernel.dao.orm.DynamicQuery dynamicQuery,
                              com.liferay.portal.kernel.dao.orm.Projection projection)

Returns the number of rows matching the dynamic query.

Specified by:

dynamicQueryCount in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

dynamicQuery - the dynamic query

projection - the projection to apply to the query

Returns:

the number of rows matching the dynamic query

fetchSocialActivityLimit

public com.liferay.social.kernel.model.SocialActivityLimit fetchSocialActivityLimit(long activityLimitId)

Specified by:

fetchSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

getSocialActivityLimit

public com.liferay.social.kernel.model.SocialActivityLimit getSocialActivityLimit(long activityLimitId)
                                                                           throws com.liferay.portal.kernel.exception.PortalException

Returns the social activity limit with the primary key.

Specified by:

getSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

activityLimitId - the primary key of the social activity limit

Returns:

the social activity limit

Throws:

com.liferay.portal.kernel.exception.PortalException - if a social activity limit with the primary key could not be found

getActionableDynamicQuery

public com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery getActionableDynamicQuery()

Specified by:

getActionableDynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

getIndexableActionableDynamicQuery

public com.liferay.portal.kernel.dao.orm.IndexableActionableDynamicQuery getIndexableActionableDynamicQuery()

Specified by:

getIndexableActionableDynamicQuery in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

initActionableDynamicQuery

protected void initActionableDynamicQuery(com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery actionableDynamicQuery)

deletePersistedModel

public com.liferay.portal.kernel.model.PersistedModel deletePersistedModel(com.liferay.portal.kernel.model.PersistedModel persistedModel)
                                                                    throws com.liferay.portal.kernel.exception.PortalException

Specified by:

deletePersistedModel in interface com.liferay.portal.kernel.service.PersistedModelLocalService

Specified by:

deletePersistedModel in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Throws:

com.liferay.portal.kernel.exception.PortalException

getPersistedModel

public com.liferay.portal.kernel.model.PersistedModel getPersistedModel(Serializable primaryKeyObj)
                                                                 throws com.liferay.portal.kernel.exception.PortalException

Specified by:

getPersistedModel in interface com.liferay.portal.kernel.service.PersistedModelLocalService

Specified by:

getPersistedModel in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Throws:

com.liferay.portal.kernel.exception.PortalException

getSocialActivityLimits

public List<com.liferay.social.kernel.model.SocialActivityLimit> getSocialActivityLimits(int start,
                                                                                         int end)

Returns a range of all the social activity limits.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent and pagination is required (start and end are not QueryUtil.ALL_POS), then the query will include the default ORDER BY logic from SocialActivityLimitModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.

Specified by:

getSocialActivityLimits in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

start - the lower bound of the range of social activity limits

end - the upper bound of the range of social activity limits (not inclusive)

Returns:

the range of social activity limits

getSocialActivityLimitsCount

public int getSocialActivityLimitsCount()

Returns the number of social activity limits.

Specified by:

getSocialActivityLimitsCount in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Returns:

the number of social activity limits

updateSocialActivityLimit

@Indexable(type=REINDEX)
public com.liferay.social.kernel.model.SocialActivityLimit updateSocialActivityLimit(com.liferay.social.kernel.model.SocialActivityLimit socialActivityLimit)

Updates the social activity limit in the database or adds it if it does not yet exist. Also notifies the appropriate model listeners.

Specified by:

updateSocialActivityLimit in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Parameters:

socialActivityLimit - the social activity limit

Returns:

the social activity limit that was updated

getSocialActivityLimitLocalService

public com.liferay.social.kernel.service.SocialActivityLimitLocalService getSocialActivityLimitLocalService()

Returns the social activity limit local service.

Returns:

the social activity limit local service

setSocialActivityLimitLocalService

public void setSocialActivityLimitLocalService(com.liferay.social.kernel.service.SocialActivityLimitLocalService socialActivityLimitLocalService)

Sets the social activity limit local service.

Parameters:

socialActivityLimitLocalService - the social activity limit local service

getSocialActivityLimitPersistence

public com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence getSocialActivityLimitPersistence()

Returns the social activity limit persistence.

Returns:

the social activity limit persistence

setSocialActivityLimitPersistence

public void setSocialActivityLimitPersistence(com.liferay.social.kernel.service.persistence.SocialActivityLimitPersistence socialActivityLimitPersistence)

Sets the social activity limit persistence.

Parameters:

socialActivityLimitPersistence - the social activity limit persistence

getCounterLocalService

public com.liferay.counter.kernel.service.CounterLocalService getCounterLocalService()

Returns the counter local service.

Returns:

the counter local service

setCounterLocalService

public void setCounterLocalService(com.liferay.counter.kernel.service.CounterLocalService counterLocalService)

Sets the counter local service.

Parameters:

counterLocalService - the counter local service

getGroupLocalService

public com.liferay.portal.kernel.service.GroupLocalService getGroupLocalService()

Returns the group local service.

Returns:

the group local service

setGroupLocalService

public void setGroupLocalService(com.liferay.portal.kernel.service.GroupLocalService groupLocalService)

Sets the group local service.

Parameters:

groupLocalService - the group local service

getGroupPersistence

public com.liferay.portal.kernel.service.persistence.GroupPersistence getGroupPersistence()

Returns the group persistence.

Returns:

the group persistence

setGroupPersistence

public void setGroupPersistence(com.liferay.portal.kernel.service.persistence.GroupPersistence groupPersistence)

Sets the group persistence.

Parameters:

groupPersistence - the group persistence

getGroupFinder

public com.liferay.portal.kernel.service.persistence.GroupFinder getGroupFinder()

Returns the group finder.

Returns:

the group finder

setGroupFinder

public void setGroupFinder(com.liferay.portal.kernel.service.persistence.GroupFinder groupFinder)

Sets the group finder.

Parameters:

groupFinder - the group finder

getUserLocalService

public com.liferay.portal.kernel.service.UserLocalService getUserLocalService()

Returns the user local service.

Returns:

the user local service

setUserLocalService

public void setUserLocalService(com.liferay.portal.kernel.service.UserLocalService userLocalService)

Sets the user local service.

Parameters:

userLocalService - the user local service

getUserPersistence

public com.liferay.portal.kernel.service.persistence.UserPersistence getUserPersistence()

Returns the user persistence.

Returns:

the user persistence

setUserPersistence

public void setUserPersistence(com.liferay.portal.kernel.service.persistence.UserPersistence userPersistence)

Sets the user persistence.

Parameters:

userPersistence - the user persistence

getUserFinder

public com.liferay.portal.kernel.service.persistence.UserFinder getUserFinder()

Returns the user finder.

Returns:

the user finder

setUserFinder

public void setUserFinder(com.liferay.portal.kernel.service.persistence.UserFinder userFinder)

Sets the user finder.

Parameters:

userFinder - the user finder

afterPropertiesSet

public void afterPropertiesSet()

destroy

public void destroy()

getOSGiServiceIdentifier

public String getOSGiServiceIdentifier()

Returns the OSGi service identifier.

Specified by:

getOSGiServiceIdentifier in interface com.liferay.portal.kernel.module.framework.service.IdentifiableOSGiService

Specified by:

getOSGiServiceIdentifier in interface com.liferay.social.kernel.service.SocialActivityLimitLocalService

Returns:

the OSGi service identifier

getModelClass

protected Class<?> getModelClass()

getModelClassName

protected String getModelClassName()

runSQL

protected void runSQL(String sql)

Performs a SQL query.

Parameters:

sql - the sql query