docs: def _get_on_trixel_sources_from_database_query(
              self):
          """*generate the mysql query before executing it*
          """
          self.log.debug(
              'completed the ````_get_on_trixel_sources_from_database_query`` method')
  
          tableName = self.tableName
          raCol = self.raCol
          decCol = self.decCol
          radiusArc = self.radius
          radius = self.radius / (60. * 60.)
  
          # GET ALL THE TRIXELS REQUIRED
          trixelArray = self._get_trixel_ids_that_overlap_conesearch_circles()
          if trixelArray.size > 50000 and self.htmDepth == 16:
              self.htmDepth = 13
              self.mesh = HTM(
                  depth=self.htmDepth,
                  log=self.log
              )
              trixelArray = self._get_trixel_ids_that_overlap_conesearch_circles()
          if trixelArray.size > 50000 and self.htmDepth == 13:
              self.htmDepth = 10
              self.mesh = HTM(
                  depth=self.htmDepth,
                  log=self.log
              )
              trixelArray = self._get_trixel_ids_that_overlap_conesearch_circles()
  
          htmLevel = "htm%sID" % self.htmDepth
          if trixelArray.size > 150000:
              self.log.info(
                  "Your search radius of the `%(tableName)s` table may be too large (%(radiusArc)s arcsec)" % locals())
              minID = np.min(trixelArray)
              maxID = np.max(trixelArray)
              htmWhereClause = "where %(htmLevel)s between %(minID)s and %(maxID)s  " % locals(
              )
          else:
              thesHtmIds = ",".join(np.array(map(str, trixelArray)))
              htmWhereClause = "where %(htmLevel)s in (%(thesHtmIds)s)" % locals(
              )
  
          cols = self.columns[:]
          if cols != "*" and raCol.lower() not in cols.lower():
              cols += ", " + raCol
          if cols != "*" and decCol.lower() not in cols.lower():
              cols += ", " + decCol
  
          # FINALLY BUILD THE FULL QUERY
          if self.distinct:
              sqlQuery = """select DISTINCT %(cols)s from %(tableName)s %(htmWhereClause)s""" % locals(
              )
          else:
              sqlQuery = """select %(cols)s from %(tableName)s %(htmWhereClause)s""" % locals(
              )
  
          if self.sqlWhere and len(self.sqlWhere):
              sqlQuery += " and " + self.sqlWhere
  
          self.log.debug(
              'completed the ``_get_on_trixel_sources_from_database_query`` method')
  
          return sqlQuery