Tag: sql

20 How to combine ANDs and ORs in the WHERE clause using a Query Object? 2014-12-09T18:34:23.660

7 Recommended practices regarding transfering database from Joomla 1.5 to Joomla 3 2014-07-10T09:22:34.870

6 Structure folder of sql files in my component 2014-04-24T02:38:25.140

5 Joomla 3.6 How to migrate data from repeatable to subform 2016-08-06T18:32:24.527

4 Join an existing table with a generated table of dates and count rows for each date? 2015-04-07T12:52:49.337

4 How can I get the names of the columns in an object or table with Joomla's SQL? 2015-07-12T21:31:43.133

4 How to only transfer new column values from one table to another? 2016-01-10T12:33:13.913

4 How to rewrite SQL-query with CASE/WHEN to Joomla-based "format" 2016-01-15T13:46:11.090

3 Migration Files - post update sql migration scripts generation 2014-06-01T12:00:36.463

3 Error 1146 while installing K2 extension 2015-01-23T08:55:16.810

3 How to write my MySQL query with JOIN logic using JDatabase methods? 2015-05-14T17:59:33.957

3 JDatabase JOIN on multiple values 2015-06-15T11:03:37.423

2 Component Update: DB error file function returned no error 2014-08-15T20:31:25.117

2 Old update sqls being run on update 2014-11-11T02:16:30.273

2 Transfer Joomla data from PHPMyAdmin SQL Dump 2016-12-04T17:26:29.817

2 Run Stored Procedure From Page Load 2017-03-02T01:32:53.477

2 Joomla Migrating Live Site To Localhost -Navigation Not Working 2018-04-26T15:39:56.600

2 What does sql_select="e.*" do? 2018-05-26T11:48:57.030

2 Confusion about using two select() method calls in one query 2018-09-26T17:07:57.180

2 How to query certain rows from a table based on other associated rows in the same table? 2018-10-11T09:27:58.570

1 How can I select IDs of a category and all its (n levels) subcategories? 2014-05-31T11:24:14.383

1 Recycling IDs: re-using articles, category's ID that have been trashed for new articles 2014-11-23T10:27:37.860

1 How to Create a Foreach Loop that Returns Users In a Specific Usergroup 2015-01-05T21:43:52.857

1 Joomla 2.5 and Virtuemart 3 installation problems 2015-02-05T17:04:48.230

1 Extension install scripts without raw sql 2015-02-25T10:39:52.300

1 Retrieving multiple results from the database 2015-04-10T08:19:23.740

1 Achieve k2 item SEF URLS 2015-05-20T15:45:37.567

1 After Joomla update duplicate or create new module get id : 0 2015-07-29T16:43:23.573

1 Trying to set up new joomla from old joomla files 2015-12-12T15:42:05.217

1 getting some sql error 2016-02-15T21:58:18.340

1 Mapping “asset_id” and “ordering” fields of joomla content table using RSform pro mapping feature 2016-06-10T19:15:04.460

1 The MySQL adapter mysqli is not available - how to resolve this issue? 2016-07-29T00:21:38.937

1 Adding a stand alone php (with sql queries built using mysql phpgenerator) to existing Joomla application 2016-09-18T07:00:58.737

1 Retrieve article URL from phpMyAdmin 2017-07-26T02:08:58.860

1 Rewriting code as per Joomla guide, but page showing 404 error 2017-09-16T17:03:17.083

1 Join two similar table SQL 2017-12-15T01:34:40.257

1 How to select records one by one using JDatabaseQuery 2018-02-03T12:10:53.110

1 Error when populating a database table while installing a module 2018-02-28T19:43:18.137

1 How to re-write sql for joomla JDatabase 2018-05-15T13:59:12.500

1 Delete row from custom made SQL when deleting article in Joomla 2018-09-04T18:44:17.237

1 How to construct a JOIN query with Joomla's query methods? 2018-10-18T14:23:02.323

0 How to merge joomla tag using SQL query from phpMyadmin? 2015-03-19T15:16:40.583

0 Joomla MVC Component: Run SQL before deleting record 2015-03-26T14:39:20.850

0 Use different mysql table for users 2015-04-04T09:05:18.833

0 Get current language and DB Query to select content by language 2015-06-03T16:27:38.653

0 Update all rows primary key columnin a table - Joomla 3.4.8 2016-01-11T20:48:52.450

0 Do I need a custom field for a db field alias? 2016-01-15T02:39:36.600

0 joomla 2.5 / K2 - SQL Query to delete trashed items taking care of data integrity 2016-03-16T20:57:30.333

0 Joomla 3.4.8 Component SQL Update Not Working 2016-04-25T09:48:13.257

0 Copy user data into custom table on user registration 2016-05-27T16:31:44.163

0 Dynamic component SQL parameter type 2016-09-08T14:02:43.493

0 Joomla 3x sql field NOT Filtering on Change 2016-09-14T21:06:48.400

0 Error: Incorrect table definition; there can be only one auto column and it must be defined as a key 2017-08-21T15:18:50.563

0 Join two list views without a shared key 2017-08-28T15:31:53.093

0 How to SET a user-defined MySQL variable and increment it to produce ranking values with JDatabaseQuery? 2018-02-04T13:46:42.163

0 Convert PHP code to Jooma PHP syntax? 2018-08-01T09:15:53.200

0 Ordering Joomla menus in code 2018-11-13T08:16:14.217

0 Bulk delete disabled k2 users Joomla 2.5 2018-11-16T16:28:39.530

-1 1054 Unknown column 'extra_query' 2014-09-05T19:51:24.877

-1 Component - Site Model Question 2017-05-26T01:43:39.830

-1 add text after value that is retrieving from SQL in php 2017-07-21T00:01:06.627