Semantic search

From Who Called Me
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Picture Framers & Frame Makers]]
SQL Query
SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t2
INNER JOIN
  `smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id='518'
   AND (t4.p_id='524' AND t4.o_id='5768')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const592Using where; Using temporary; Using filesort
1SIMPLEt2refs_id,o_id,s_id_2,o_id_2s_id4callto_wikidb.t4.s_id1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4callto_wikidb.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
Phone numberCompanyBusiness categoryLocationE-mailCompany homepage
01224627164BELVIDERE GALLERY LIMITEDPicture Framers & Frame Makersmail@belvideregallery.comhttp://www.belvideregallery.com
01225469100FRONTIER PICTURE FRAMES LIMITEDPicture Framers & Frame MakersBRISTOLinfo@frontierpictureframes.comhttp://www.frontierpictureframes.com
01225482748THE FRAMING WORKSHOP LIMITEDPicture Framers & Frame Makershttp://www.theframingworkshop.com
01225920210THE BATH FRAMER LIMITEDPicture Framers & Frame MakersBATHkelly@thebathframer.co.ukhttp://www.thebathpictureframer.co.uk/
01226243814IMPACT FRAMING LTDPicture Framers & Frame MakersBARNSLEYhttp://www.impactframingltd.co.uk
01228531837GRAYS PICTURE FRAMERS LIMITEDPicture Framers & Frame MakersCARLISLEhttp://www.graysframers.co.uk
01228536291KINGSTOWN PICTURE FRAMES LIMITEDPicture Framers & Frame MakersCARLISLE
01228810840CASTLE FRAMING LIMITEDPicture Framers & Frame MakersBRAMPTONhttp://www.castle-picture-framing.co.uk
01229837494THE GALLERY LTDPicture Framers & Frame MakersKENILWORTHhttp://www.emptywall.co.uk
01233637104WESSEX PICTURES LIMITEDPicture Framers & Frame MakersLYMINGTONhttp://www.wessexpictures.com
01235523191SURROUNDINGS LIMITEDPicture Framers & Frame MakersROXBURGHSHIRE
01235815934THE FRAMING STUDIO LTDPicture Framers & Frame MakersBRIGHTONframingstudiodidcot@aol.co.ukhttp://www.framingstudiodidcot.co.uk
01235818273SWALLOWS LIMITEDPicture Framers & Frame MakersUXBRIDGE
01235821452AWARD FRAMERS INTERNATIONAL LTDPicture Framers & Frame MakersABINGDON-ON-THAMES
01242584132OFF THE WALL LIMITEDPicture Framers & Frame MakersNEWCASTLE UPON TYNE
01242672785CLEEVE PICTURE FRAMING LIMITEDPicture Framers & Frame MakersCHELTENHAMcleevepictureframing@hotmail.co.ukhttp://www.cleevepictureframing.co.uk
01243519455EDGE ON ART LTDPicture Framers & Frame MakersCHICHESTERhttp://www.edgeonart.co.uk
01243781532ART FOR ALL LTDPicture Framers & Frame MakersLONDONsales@artforall.co.ukhttp://www.artforall.co.uk
01243789343BOND-A-FRAME LIMITEDPicture Framers & Frame MakersCHICHESTERhttp://www.bond-a-frame.co.uk
01244532608FRAMED LIMITEDPicture Framers & Frame MakersLANCASTER
01244675847PICTURE THIS LIMITEDPicture Framers & Frame MakersCHOBHAM
01244819990REDBILL LTDPicture Framers & Frame MakersOLDHAMhttp://www.redbill.co.uk
01245323123FRAMES FIRST LIMITEDPicture Framers & Frame MakersSOUTHEND-ON-SEAsales@framesfirst.co.ukhttp://www.framesfirst.co.uk
01245477000FRAMES BY POST LIMITEDPicture Framers & Frame MakersESSEXhttp://www.framesbypost.com
01246209690THE REAL MCCOY LIMITEDPicture Framers & Frame MakersHARROW
01246474742IN2FRAMES LIMITEDPicture Framers & Frame MakersCHESTERFIELDhttp://www.in2frames.co.uk
01246813059QUADRO LTDPicture Framers & Frame MakersWATFORD
01253313219THE PICTURE FRAMING CENTRE LIMITEDPicture Framers & Frame MakersBLACKPOOLhttp://www.pictureframingblackpool.com
01253403020FRAMING INCREDIBLE LTDPicture Framers & Frame MakersBLACKPOOLhttp://www.framingincredible.com
01253623170REDROSE MANUFACTURING LIMITEDPicture Framers & Frame MakersHOUGHTON LE SPRINGhttp://www.redrosepictureframing.co.uk
01254659532IN THE FRAME LIMITEDPicture Framers & Frame MakersLONDONhttp://www.intheframelancashire.com
01254822002ARTISAN ONE LIMITEDPicture Framers & Frame MakersCLITHEROEhttp://www.artisanone.co.uk
01255675221FRINTON FRAMES LTDPicture Framers & Frame MakersFRINTON-ON-SEAhttp://www.frintonframes.co.uk
01255860800STUDIO ONE FRAMES LIMITEDPicture Framers & Frame MakersCLACTON ON SEApaul@studiooneframes.co.ukhttp://www.studiooneframes.co.uk
01257422258SPACE FRAMING LIMITEDPicture Framers & Frame MakersBRISTOLhttp://www.spaceframing.co.uk
01257423551THE FRAMING STUDIO LTDPicture Framers & Frame MakersBRIGHTONhttp://www.theframingstudio.com
01257462500SPACE FRAMING LIMITEDPicture Framers & Frame MakersBRISTOLhttp://www.spaceframing.co.uk
01262400279PARK VIEW GALLERY LIMITEDPicture Framers & Frame MakersCOVENTRY
01264358424ANDOVER FRAMING LIMITEDPicture Framers & Frame MakersANDOVER
01264749391CREATIVE PICTURE FRAMING LIMITEDPicture Framers & Frame MakersLONDON
01268272950TERRA FUSION LTDPicture Framers & Frame MakersLONDONhttp://www.terrafusion.co.uk
01268411059MALGRAVES FINE ART LIMITEDPicture Framers & Frame MakersLETCHWORTH GARDEN CITY
01268795033FRAMEWORKS (ESSEX) LIMITEDPicture Framers & Frame MakersLEIGH ON SEAhttp://www.frameworks-essex.com
01269832680CREATIVE EDGE LIMITEDPicture Framers & Frame MakersLONDONhttp://www.credframing.co.uk
01270215917PICTURESQUE LIMITEDPicture Framers & Frame MakersFLEET
01273471647KEIZER FRAMES LIMITEDPicture Framers & Frame MakersLEWEShttp://www.pictureframinglewes.co.uk
01273486356OCHRE FRAMING LIMITEDPicture Framers & Frame MakersEAST SUSSEXmade@ochreframing.comhttp://www.ochreframing.com
01273609207THE FRAME FACTORY LIMITEDPicture Framers & Frame MakersDARTFORDhttp://www.frame-factory.co.uk/
01273724829ARTREPUBLIC LIMITEDPicture Framers & Frame MakersLONDON
01273731405THE FRAMING STUDIO LTDPicture Framers & Frame MakersBRIGHTONlauraholden@framing-studio.co.ukhttp://www.framing-studio.co.uk